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 FND_LOG

Line 29: if (p_text is null or p_text='' or FND_LOG.G_CURRENT_RUNTIME_LEVEL < FND_LOG.LEVEL_STATEMENT)

25: l_start number := 1;
26: l_end number := 1;
27: last_reached boolean := false;
28: BEGIN
29: if (p_text is null or p_text='' or FND_LOG.G_CURRENT_RUNTIME_LEVEL < FND_LOG.LEVEL_STATEMENT)
30: then
31: return;
32: end if;
33:

Line 49: if( p_severity >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

45: last_reached:=true;
46: end if;
47: -- hard coding as it is giving GSCC warning
48: -- for now it is ok as only unexpected errors are generated
49: if( p_severity >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
50: FND_LOG.STRING(p_severity, p_module_name, substr(p_text, l_start, 250));
51: end if;
52: l_start:=l_start+250;
53: if last_reached then

Line 50: FND_LOG.STRING(p_severity, p_module_name, substr(p_text, l_start, 250));

46: end if;
47: -- hard coding as it is giving GSCC warning
48: -- for now it is ok as only unexpected errors are generated
49: if( p_severity >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
50: FND_LOG.STRING(p_severity, p_module_name, substr(p_text, l_start, 250));
51: end if;
52: l_start:=l_start+250;
53: if last_reached then
54: exit;

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 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: