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_TERR_ENGINE_GEN_PVT dependencies on FND_API

Line 333: terr_qual_id NUMBER:=FND_API.G_MISS_NUM

329: IS
330:
331:
332: TYPE terrqual_type IS RECORD(
333: terr_qual_id NUMBER:=FND_API.G_MISS_NUM
334: );
335:
336: TYPE terrqual_tbl_type IS TABLE OF terrqual_type
337: INDEX BY BINARY_INTEGER;

Line 341: seeded_qualifier_id NUMBER:=FND_API.G_MISS_NUM

337: INDEX BY BINARY_INTEGER;
338:
339:
340: TYPE seeded_qual_type IS RECORD(
341: seeded_qualifier_id NUMBER:=FND_API.G_MISS_NUM
342: );
343:
344: TYPE seeded_qual_tbl_type IS TABLE OF seeded_qual_type
345: INDEX BY BINARY_INTEGER;

Line 348: grp_role_id NUMBER:=FND_API.G_MISS_NUM

344: TYPE seeded_qual_tbl_type IS TABLE OF seeded_qual_type
345: INDEX BY BINARY_INTEGER;
346:
347: TYPE role_typ IS RECORD(
348: grp_role_id NUMBER:=FND_API.G_MISS_NUM
349: );
350:
351: TYPE grp_role_tbl_type IS TABLE OF role_typ
352: INDEX BY BINARY_INTEGER;

Line 1023: l_init_msg_list := FND_API.G_TRUE;

1019: l_terr_qualtypeusgs_tbl(3).LAST_UPDATE_LOGIN := G_LOGIN_ID;
1020: l_terr_qualtypeusgs_tbl(3).TERR_ID := null;
1021: l_terr_qualtypeusgs_tbl(3).ORG_ID := terr_group.ORG_ID;
1022:
1023: l_init_msg_list := FND_API.G_TRUE;
1024:
1025:
1026: /* set org context using ORG_ID of Territory
1027: ** Group'S TOP-LEVEL PARENT TERRITORY */

Line 1038: p_validation_level => fnd_api.g_valid_level_NONE,

1034: jtf_territory_pvt.create_territory (
1035: p_api_version_number => l_api_version_number,
1036: p_init_msg_list => l_init_msg_list,
1037: p_commit => l_commit,
1038: p_validation_level => fnd_api.g_valid_level_NONE,
1039: x_return_status => x_return_status,
1040: x_msg_count => x_msg_count,
1041: x_msg_data => x_msg_data,
1042: p_terr_all_rec => l_terr_all_rec,

Line 1072: X_MSG_DATA := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

1068:
1069: ELSE
1070: WRITE_LOG(2,'ERROR: PLACEHOLDER TERRITORY CREATION FAILED ' ||
1071: 'FOR TERRITORY_GROUP_ID# ' ||TERR_GROUP.TERR_GROUP_ID);
1072: X_MSG_DATA := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
1073: WRITE_LOG(2,X_MSG_DATA);
1074:
1075: END IF;
1076: /* END: SUCCESSFUL TERRITORY CREATION? */

Line 1269: l_init_msg_list := FND_API.G_TRUE;

1265: l_terr_values_tbl(k).qualifier_tbl_index := 1;
1266:
1267: end loop;
1268:
1269: l_init_msg_list := FND_API.G_TRUE;
1270:
1271: -- 07/08/03: JDOCHERT: bug#3023653
1272: --mo_global.set_org_context(terr_group.ORG_ID,null);
1273: --

Line 1278: p_validation_level => fnd_api.g_valid_level_NONE,

1274: jtf_territory_pvt.create_territory (
1275: p_api_version_number => l_api_version_number,
1276: p_init_msg_list => l_init_msg_list,
1277: p_commit => l_commit,
1278: p_validation_level => fnd_api.g_valid_level_NONE,
1279: x_return_status => x_return_status,
1280: x_msg_count => x_msg_count,
1281: x_msg_data => x_msg_data,
1282: p_terr_all_rec => l_terr_all_rec,

Line 1306: l_init_msg_list :=FND_API.G_TRUE;

1302: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
1303: , CATCH_ALL_FLAG = 'Y'
1304: where terr_id = x_terr_id;
1305:
1306: l_init_msg_list :=FND_API.G_TRUE;
1307:
1308: SELECT JTF_TERR_RSC_S.nextval
1309: into l_terr_rsc_id
1310: FROM DUAL;

Line 1394: l_init_msg_list := FND_API.G_TRUE;

1390:
1391: end if;
1392: end loop; /* End of rsc_acc */
1393:
1394: l_init_msg_list := FND_API.G_TRUE;
1395:
1396: -- 07/08/03: JDOCHERT: bug#3023653
1397: jtf_territory_resource_pvt.create_terrresource (
1398: p_api_version_number => l_Api_Version_Number,

Line 1401: p_validation_level => fnd_api.g_valid_level_NONE,

1397: jtf_territory_resource_pvt.create_terrresource (
1398: p_api_version_number => l_Api_Version_Number,
1399: p_init_msg_list => l_Init_Msg_List,
1400: p_commit => l_Commit,
1401: p_validation_level => fnd_api.g_valid_level_NONE,
1402: x_return_status => x_Return_Status,
1403: x_msg_count => x_Msg_Count,
1404: x_msg_data => x_msg_data,
1405: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 1417: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);

1413: x_terr_id);
1414: else
1415: write_log( 2,' FAILED IN RESOURCE CREATION FOR NAMED ACCOUNT CATCH ALL TERRITORY' ||
1416: x_terr_id);
1417: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
1418: write_log(2, x_msg_data);
1419: end if;
1420:
1421: /* else of -if the catch all territory creation failed */

Line 1423: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);

1419: end if;
1420:
1421: /* else of -if the catch all territory creation failed */
1422: else
1423: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
1424: write_log(2,x_msg_data);
1425: WRITE_LOG(2,'ERROR: NA CATCH-ALL TERRITORY CREATION FAILED ' ||
1426: 'FOR TERRITORY_GROUP_ID# ' ||TERR_GROUP.TERR_GROUP_ID);
1427: end if;

Line 1644: l_init_msg_list :=FND_API.G_TRUE;

1640:
1641: end loop; /* qval IN pqual */
1642:
1643:
1644: l_init_msg_list :=FND_API.G_TRUE;
1645:
1646: -- 07/08/03: JDOCHERT: bug#3023653
1647: --mo_global.set_org_context(terr_group.ORG_ID,null);
1648: --

Line 1654: p_validation_level => fnd_api.g_valid_level_NONE,

1650: jtf_territory_pvt.create_territory (
1651: p_api_version_number => l_api_version_number,
1652: p_init_msg_list => l_init_msg_list,
1653: p_commit => l_commit,
1654: p_validation_level => fnd_api.g_valid_level_NONE,
1655: x_return_status => x_return_status,
1656: x_msg_count => x_msg_count,
1657: x_msg_data => x_msg_data,
1658: p_terr_all_rec => l_terr_all_rec,

Line 1688: l_init_msg_list :=FND_API.G_TRUE;

1684: where terr_id = x_terr_id;
1685:
1686: --write_log(2,terr_group.terr_group_id);
1687: --write_log(2,tran_type.role_code);
1688: l_init_msg_list :=FND_API.G_TRUE;
1689: i := 0;
1690: a := 0;
1691:
1692: FOR tran_type in role_interest_nonpi(terr_group.Terr_gROUP_ID)

Line 1788: l_init_msg_list :=FND_API.G_TRUE;

1784: end loop; /* FOR rsc in resource_grp */
1785:
1786: end loop;/* FOR tran_type in role_interest_nonpi */
1787:
1788: l_init_msg_list :=FND_API.G_TRUE;
1789:
1790: -- 07/08/03: JDOCHERT: bug#3023653
1791: jtf_territory_resource_pvt.create_terrresource (
1792: p_api_version_number => l_Api_Version_Number,

Line 1795: p_validation_level => fnd_api.g_valid_level_NONE,

1791: jtf_territory_resource_pvt.create_terrresource (
1792: p_api_version_number => l_Api_Version_Number,
1793: p_init_msg_list => l_Init_Msg_List,
1794: p_commit => l_Commit,
1795: p_validation_level => fnd_api.g_valid_level_NONE,
1796: x_return_status => x_Return_Status,
1797: x_msg_count => x_Msg_Count,
1798: x_msg_data => x_msg_data,
1799: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 1808: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);

1804:
1805: if x_Return_Status='S' then
1806: write_log(2,' Resource created for NA territory # ' ||x_terr_id);
1807: else
1808: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);
1809: write_log(2,x_msg_data);
1810: write_log(2, ' Failed in resource creation for NA territory # ' ||
1811: x_terr_id);
1812: end if;

Line 1815: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);

1811: x_terr_id);
1812: end if;
1813:
1814: else
1815: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);
1816: write_log(2,substr(x_msg_data,1,254));
1817: WRITE_LOG(2,'ERROR: NA TERRITORY CREATION FAILED ' ||
1818: 'FOR NAMED_ACCOUNT_ID# ' || naterr.named_account_id );
1819: end if; /* END: Successful Territory creation? */

Line 2038: l_init_msg_list :=FND_API.G_TRUE;

2034:
2035: end loop; /* qval IN pqual */
2036:
2037:
2038: l_init_msg_list :=FND_API.G_TRUE;
2039:
2040: -- 07/08/03: JDOCHERT: bug#3023653
2041: --mo_global.set_org_context(terr_group.ORG_ID,null);
2042: --

Line 2048: p_validation_level => fnd_api.g_valid_level_NONE,

2044: jtf_territory_pvt.create_territory (
2045: p_api_version_number => l_api_version_number,
2046: p_init_msg_list => l_init_msg_list,
2047: p_commit => l_commit,
2048: p_validation_level => fnd_api.g_valid_level_NONE,
2049: x_return_status => x_return_status,
2050: x_msg_count => x_msg_count,
2051: x_msg_data => x_msg_data,
2052: p_terr_all_rec => l_terr_all_rec,

Line 2082: l_init_msg_list :=FND_API.G_TRUE;

2078: where terr_id = x_terr_id;
2079:
2080: --write_log(2,terr_group.terr_group_id);
2081: --write_log(2,tran_type.role_code);
2082: l_init_msg_list :=FND_API.G_TRUE;
2083: i := 0;
2084: a := 0;
2085:
2086: FOR tran_type in role_interest_nonpi(terr_group.Terr_gROUP_ID)

Line 2182: l_init_msg_list :=FND_API.G_TRUE;

2178: end loop; /* FOR rsc in resource_grp */
2179:
2180: end loop;/* FOR tran_type in role_interest_nonpi */
2181:
2182: l_init_msg_list :=FND_API.G_TRUE;
2183:
2184: -- 07/08/03: JDOCHERT: bug#3023653
2185: jtf_territory_resource_pvt.create_terrresource (
2186: p_api_version_number => l_Api_Version_Number,

Line 2189: p_validation_level => fnd_api.g_valid_level_NONE,

2185: jtf_territory_resource_pvt.create_terrresource (
2186: p_api_version_number => l_Api_Version_Number,
2187: p_init_msg_list => l_Init_Msg_List,
2188: p_commit => l_Commit,
2189: p_validation_level => fnd_api.g_valid_level_NONE,
2190: x_return_status => x_Return_Status,
2191: x_msg_count => x_Msg_Count,
2192: x_msg_data => x_msg_data,
2193: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 2202: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);

2198:
2199: if x_Return_Status='S' then
2200: write_log(2,' Resource created for NA territory # ' ||x_terr_id);
2201: else
2202: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);
2203: write_log(2,x_msg_data);
2204: write_log(2, ' Failed in resource creation for NA territory # ' ||
2205: x_terr_id);
2206: end if;

Line 2209: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);

2205: x_terr_id);
2206: end if;
2207:
2208: else
2209: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);
2210: write_log(2,substr(x_msg_data,1,254));
2211: WRITE_LOG(2,'ERROR: NA TERRITORY CREATION FAILED ' ||
2212: 'FOR NAMED_ACCOUNT_ID# ' || naterr.named_account_id );
2213: end if; /* END: Successful Territory creation? */

Line 2438: l_init_msg_list :=FND_API.G_TRUE;

2434: END LOOP; /* csr_qual_val IN csr_get_qual_val */
2435: end loop; /* csr_qual IN csr_get_qual */
2436:
2437:
2438: l_init_msg_list :=FND_API.G_TRUE;
2439:
2440: -- 07/08/03: JDOCHERT: bug#3023653
2441: --mo_global.set_org_context(terr_group.ORG_ID,null);
2442: --

Line 2447: p_validation_level => fnd_api.g_valid_level_NONE,

2443: jtf_territory_pvt.create_territory (
2444: p_api_version_number => l_api_version_number,
2445: p_init_msg_list => l_init_msg_list,
2446: p_commit => l_commit,
2447: p_validation_level => fnd_api.g_valid_level_NONE,
2448: x_return_status => x_return_status,
2449: x_msg_count => x_msg_count,
2450: x_msg_data => x_msg_data,
2451: p_terr_all_rec => l_terr_all_rec,

Line 2631: l_init_msg_list :=FND_API.G_TRUE;

2627: l_terr_values_tbl(k).qualifier_tbl_index := j;
2628:
2629: end loop;
2630:
2631: l_init_msg_list :=FND_API.G_TRUE;
2632:
2633: -- 07/08/03: JDOCHERT: bug#3023653
2634: --mo_global.set_org_context(terr_group.ORG_ID,null);
2635: --

Line 2641: p_validation_level => fnd_api.g_valid_level_NONE,

2637: jtf_territory_pvt.create_territory (
2638: p_api_version_number => l_api_version_number,
2639: p_init_msg_list => l_init_msg_list,
2640: p_commit => l_commit,
2641: p_validation_level => fnd_api.g_valid_level_NONE,
2642: x_return_status => x_return_status,
2643: x_msg_count => x_msg_count,
2644: x_msg_data => x_msg_data,
2645: p_terr_all_rec => l_terr_all_rec,

Line 2875: l_init_msg_list :=FND_API.G_TRUE;

2871: end if;
2872:
2873: end loop;
2874:
2875: l_init_msg_list :=FND_API.G_TRUE;
2876:
2877: -- 07/08/03: JDOCHERT: bug#3023653
2878: --mo_global.set_org_context(terr_group.ORG_ID,null);
2879: --

Line 2885: p_validation_level => fnd_api.g_valid_level_NONE,

2881: jtf_territory_pvt.create_territory (
2882: p_api_version_number => l_api_version_number,
2883: p_init_msg_list => l_init_msg_list,
2884: p_commit => l_commit,
2885: p_validation_level => fnd_api.g_valid_level_NONE,
2886: x_return_status => x_return_status,
2887: x_msg_count => x_msg_count,
2888: x_msg_data => x_msg_data,
2889: p_terr_all_rec => l_terr_all_rec,

Line 2916: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);

2912:
2913: write_log(2,' OVERLAY PI Territory Created = '||l_terr_all_rec.NAME);
2914:
2915: else
2916: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
2917: write_log(2,x_msg_data);
2918: write_log(2, 'Failed in OVERLAY PI Territory Creation for TERR_GROUP_ACCOUNT_ID#'||
2919: overlayterr.terr_group_account_id);
2920:

Line 3024: l_init_msg_list :=FND_API.G_TRUE;

3020: l_TerrRsc_Access_Tbl(a).qualifier_tbl_index:= i;
3021: end if;
3022: end loop; /* rsc_acc in role_access */
3023:
3024: l_init_msg_list :=FND_API.G_TRUE;
3025:
3026: -- 07/08/03: JDOCHERT: bug#3023653
3027: jtf_territory_resource_pvt.create_terrresource (
3028: p_api_version_number => l_Api_Version_Number,

Line 3031: p_validation_level => fnd_api.g_valid_level_NONE,

3027: jtf_territory_resource_pvt.create_terrresource (
3028: p_api_version_number => l_Api_Version_Number,
3029: p_init_msg_list => l_Init_Msg_List,
3030: p_commit => l_Commit,
3031: p_validation_level => fnd_api.g_valid_level_NONE,
3032: x_return_status => x_Return_Status,
3033: x_msg_count => x_Msg_Count,
3034: x_msg_data => x_msg_data,
3035: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 3053: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);

3049:
3050: end loop;
3051:
3052: else
3053: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
3054: write_log(2,x_msg_data);
3055: write_log(2,'Failed in OVERLAY Territory Creation for Territory Group: ' ||
3056: terr_group.terr_group_id || ' : ' ||
3057: terr_group.terr_group_name );

Line 3214: l_init_msg_list :=FND_API.G_TRUE;

3210: l_terr_values_tbl(k).qualifier_tbl_index := j;
3211:
3212: end loop;
3213:
3214: l_init_msg_list :=FND_API.G_TRUE;
3215:
3216: -- 07/08/03: JDOCHERT: bug#3023653
3217: --mo_global.set_org_context(terr_group.ORG_ID,null);
3218: --

Line 3224: p_validation_level => fnd_api.g_valid_level_NONE,

3220: jtf_territory_pvt.create_territory (
3221: p_api_version_number => l_api_version_number,
3222: p_init_msg_list => l_init_msg_list,
3223: p_commit => l_commit,
3224: p_validation_level => fnd_api.g_valid_level_NONE,
3225: x_return_status => x_return_status,
3226: x_msg_count => x_msg_count,
3227: x_msg_data => x_msg_data,
3228: p_terr_all_rec => l_terr_all_rec,

Line 3454: l_init_msg_list :=FND_API.G_TRUE;

3450: end if;
3451:
3452: end loop;
3453:
3454: l_init_msg_list :=FND_API.G_TRUE;
3455:
3456: -- 07/08/03: JDOCHERT: bug#3023653
3457: --mo_global.set_org_context(terr_group.ORG_ID,null);
3458: --

Line 3467: p_validation_level => fnd_api.g_valid_level_NONE,

3463: jtf_territory_pvt.create_territory (
3464: p_api_version_number => l_api_version_number,
3465: p_init_msg_list => l_init_msg_list,
3466: p_commit => l_commit,
3467: p_validation_level => fnd_api.g_valid_level_NONE,
3468: x_return_status => x_return_status,
3469: x_msg_count => x_msg_count,
3470: x_msg_data => x_msg_data,
3471: p_terr_all_rec => l_terr_all_rec,

Line 3498: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);

3494:
3495: write_log(2,' OVERLAY CNR territory created:' || l_terr_all_rec.NAME);
3496:
3497: else
3498: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
3499: write_log(2,x_msg_data);
3500: write_log(2,'Failed in OVERLAY CNR territory treation for ' ||
3501: 'TERR_GROUP_ACCOUNT_ID = ' ||
3502: overlayterr.terr_group_account_id );

Line 3608: l_init_msg_list :=FND_API.G_TRUE;

3604: l_TerrRsc_Access_Tbl(a).qualifier_tbl_index:= i;
3605: end if;
3606: end loop; /* rsc_acc in role_access */
3607:
3608: l_init_msg_list :=FND_API.G_TRUE;
3609:
3610: -- 07/08/03: JDOCHERT: bug#3023653
3611: jtf_territory_resource_pvt.create_terrresource (
3612: p_api_version_number => l_Api_Version_Number,

Line 3615: p_validation_level => fnd_api.g_valid_level_NONE,

3611: jtf_territory_resource_pvt.create_terrresource (
3612: p_api_version_number => l_Api_Version_Number,
3613: p_init_msg_list => l_Init_Msg_List,
3614: p_commit => l_Commit,
3615: p_validation_level => fnd_api.g_valid_level_NONE,
3616: x_return_status => x_Return_Status,
3617: x_msg_count => x_Msg_Count,
3618: x_msg_data => x_msg_data,
3619: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 3638: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);

3634:
3635: end loop;
3636:
3637: else
3638: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
3639: write_log(2,x_msg_data);
3640: write_log(2,'Failed in OVERLAY Territory Creation for Territory Group: ' ||
3641: terr_group.terr_group_id || ' : ' ||
3642: terr_group.terr_group_name );