eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on JTF_TTY_MAINTAIN_NA_PVT

Line 1: PACKAGE BODY JTF_TTY_MAINTAIN_NA_PVT AS

1: PACKAGE BODY JTF_TTY_MAINTAIN_NA_PVT AS
2: /* $Header: jtftmnab.pls 120.19 2011/07/19 05:12:07 nbombili ship $ */
3: -- Start of Comments
4: -- PURPOSE
5: -- For handling Admin Excel Export functionalities like Add Org To

Line 261: put_jty_log('Error in GET_TERR_GRP_ACCT_DETAILS: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

257: l_error_msg := substr(sqlerrm,1,200);
258: fnd_message.clear;
259: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
260: fnd_message.set_token('ERRMSG', l_error_msg );
261: put_jty_log('Error in GET_TERR_GRP_ACCT_DETAILS: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
262: return;
263: END GET_TERR_GRP_ACCT_DETAILS;
264:
265: --This procedure deletes a named account from a territory group

Line 353: put_jty_log('Error in DELETE_ACCT_FROM_TG: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

349: l_error_msg := substr(sqlerrm,1,200);
350: fnd_message.clear;
351: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
352: fnd_message.set_token('ERRMSG', l_error_msg );
353: put_jty_log('Error in DELETE_ACCT_FROM_TG: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
354: return;
355: END DELETE_ACCT_FROM_TG;
356:
357:

Line 430: put_jty_log('Error in GET_SITE_TYPE_CODE: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

426: RETURN(l_site_type_code);
427:
428: EXCEPTION
429: WHEN OTHERS THEN
430: put_jty_log('Error in GET_SITE_TYPE_CODE: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
431:
432: END GET_SITE_TYPE_CODE;
433:
434: --This procedure creates qualifier mappings for a named account

Line 764: l_site_type_code := JTF_TTY_MAINTAIN_NA_PVT.get_site_type_code(l_party_id);

760: OPEN c_check_na_exists(l_party_id, p_party_site_id);
761: FETCH c_check_na_exists into l_na_id, l_mapping_flag;
762:
763: --Get site_type_code and user_id needed while creating NA and TGA
764: l_site_type_code := JTF_TTY_MAINTAIN_NA_PVT.get_site_type_code(l_party_id);
765: l_user_id := fnd_global.user_id;
766: l_login_id := fnd_global.login_id;
767:
768: --If named account does not exist, then create a named account for the party

Line 800: JTF_TTY_MAINTAIN_NA_PVT.create_acct_mappings

796: sysdate,
797: l_login_id);
798:
799: IF l_match_rule_code = '1' THEN
800: JTF_TTY_MAINTAIN_NA_PVT.create_acct_mappings
801: (P_API_VERSION_NUMBER => 1.0,
802: P_INIT_MSG_LIST => fnd_api.g_false,
803: P_COMMIT => fnd_api.g_false,
804: P_VALIDATION_LEVEL => fnd_api.g_valid_level_full,

Line 918: put_jty_log('Error in ADD_ORG_TO_TG: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

914: l_error_msg := substr(sqlerrm,1,200);
915: fnd_message.clear;
916: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
917: fnd_message.set_token('ERRMSG', l_error_msg );
918: put_jty_log('Error in ADD_ORG_TO_TG: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
919: return;
920: END ADD_ORG_TO_TG;
921:
922: --This procedure assigns a named account to respective TG owner(s)

Line 997: put_jty_log('Error in ASSIGN_ACCT_TO_TG_OWNERS: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

993: l_error_msg := substr(sqlerrm,1,200);
994: fnd_message.clear;
995: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
996: fnd_message.set_token('ERRMSG', l_error_msg );
997: put_jty_log('Error in ASSIGN_ACCT_TO_TG_OWNERS: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
998: return;
999: END ASSIGN_ACCT_TO_TG_OWNERS;
1000:
1001: --Procedure to validate resource, called by populate sales team

Line 1214: put_jty_log('Error in VALIDATE_RESOURCE: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

1210: l_error_msg := substr(sqlerrm,1,200);
1211: fnd_message.clear;
1212: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
1213: fnd_message.set_token('ERRMSG', l_error_msg );
1214: put_jty_log('Error in VALIDATE_RESOURCE: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
1215: RETURN;
1216: END;
1217:
1218: -- check the role code

Line 1254: put_jty_log('Error in VALIDATE_RESOURCE: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

1250: l_error_msg := substr(sqlerrm,1,200);
1251: fnd_message.clear;
1252: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
1253: fnd_message.set_token('ERRMSG', l_error_msg );
1254: put_jty_log('Error in VALIDATE_RESOURCE: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
1255: RETURN;
1256: END VALIDATE_RESOURCE;
1257:
1258: /* Procedure which checks whether the user can add the given

Line 1325: put_jty_log('Error in CHECK_VALID_RESOURCE_ADD: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

1321: WHEN OTHERS THEN
1322: -- x_status := 'E';
1323: x_error_code := 4;
1324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1325: put_jty_log('Error in CHECK_VALID_RESOURCE_ADD: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
1326: l_error_msg := substr(sqlerrm,1,200);
1327: fnd_message.clear;
1328: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
1329: fnd_message.set_token('ERRMSG', l_error_msg );

Line 1534: put_jty_log('Error in GET_RESOURCE_OWNERS: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

1530: l_error_msg := substr(sqlerrm,1,200);
1531: fnd_message.clear;
1532: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
1533: fnd_message.set_token('ERRMSG', l_error_msg );
1534: put_jty_log('Error in GET_RESOURCE_OWNERS: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
1535: RETURN;
1536:
1537:
1538: END GET_RESOURCE_OWNERS;

Line 1630: put_jty_log('Error in ASSIGN_UA_ACCT_TO_TGOWNERS: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

1626: l_error_msg := substr(sqlerrm,1,200);
1627: fnd_message.clear;
1628: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
1629: fnd_message.set_token('ERRMSG', l_error_msg );
1630: put_jty_log('Error in ASSIGN_UA_ACCT_TO_TGOWNERS: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
1631: RETURN;
1632:
1633: END ASSIGN_UA_ACCT_TO_TGOWNERS;
1634:

Line 2214: put_jty_log('Error in POPULATE_SALES_TEAM: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

2210: l_error_msg := substr(sqlerrm,1,200);
2211: fnd_message.clear;
2212: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
2213: fnd_message.set_token('ERRMSG', l_error_msg );
2214: put_jty_log('Error in POPULATE_SALES_TEAM: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
2215: return;
2216:
2217: END POPULATE_SALES_TEAM;
2218:

Line 2350: put_jty_log('Error in VALIDATE_SALES_TEAM: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

2346: l_error_msg := substr(sqlerrm,1,200);
2347: fnd_message.clear;
2348: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
2349: fnd_message.set_token('ERRMSG', l_error_msg );
2350: put_jty_log('Error in VALIDATE_SALES_TEAM: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
2351: return;
2352: END VALIDATE_SALES_TEAM;
2353:
2354: /* Procedure to update the sales team assignments for an account

Line 2584: put_jty_log('Error in UPDATE_SALES_TEAM: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

2580: l_error_msg := substr(sqlerrm,1,200);
2581: fnd_message.clear;
2582: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
2583: fnd_message.set_token('ERRMSG', l_error_msg );
2584: put_jty_log('Error in UPDATE_SALES_TEAM: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
2585: return;
2586: END IF;
2587: END IF;
2588: IF (X_Return_Status = FND_API.G_RET_STS_SUCCESS) THEN

Line 2646: put_jty_log('Error in UPDATE_SALES_TEAM: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

2642: l_error_msg := substr(sqlerrm,1,200);
2643: fnd_message.clear;
2644: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
2645: fnd_message.set_token('ERRMSG', l_error_msg );
2646: put_jty_log('Error in UPDATE_SALES_TEAM: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
2647: return;
2648: end;
2649: end if; -- if l_res_found = FALSE
2650: end loop; -- end of c_res loop

Line 2694: put_jty_log('Error in UPDATE_SALES_TEAM: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

2690: l_error_msg := substr(sqlerrm,1,200);
2691: fnd_message.clear;
2692: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
2693: fnd_message.set_token('ERRMSG', l_error_msg );
2694: put_jty_log('Error in UPDATE_SALES_TEAM: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
2695: return;
2696:
2697: END UPDATE_SALES_TEAM;
2698:

Line 2941: put_jty_log('Error in ADD_SALES_TEAM: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);

2937: l_error_msg := substr(sqlerrm,1,200);
2938: fnd_message.clear;
2939: fnd_message.set_name ('JTF', 'JTF_TTY_ERROR');
2940: fnd_message.set_token('ERRMSG', l_error_msg );
2941: put_jty_log('Error in ADD_SALES_TEAM: ' || SQLERRM, 'ORACLE.APPS.ORACLE.APPS.ORACLE.APPS.JTF.JTF_TTY_MAINTAIN_NA_PVT', FND_LOG.LEVEL_UNEXPECTED);
2942: return;
2943:
2944: END ADD_SALES_TEAM;
2945:

Line 4175: END JTF_TTY_MAINTAIN_NA_PVT;

4171: fnd_message.set_token('ERRMSG', l_error_msg );
4172:
4173: -- dbms_output.put_line ('error : '|| l_error_msg);
4174: END POPULATE_ADMIN_EXCEL_DATA;
4175: END JTF_TTY_MAINTAIN_NA_PVT;