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

Line 324: terr_qual_id NUMBER:=FND_API.G_MISS_NUM

320: IS
321:
322:
323: TYPE terrqual_type IS RECORD(
324: terr_qual_id NUMBER:=FND_API.G_MISS_NUM
325: );
326:
327: TYPE terrqual_tbl_type IS TABLE OF terrqual_type
328: INDEX BY BINARY_INTEGER;

Line 332: seeded_qualifier_id NUMBER:=FND_API.G_MISS_NUM

328: INDEX BY BINARY_INTEGER;
329:
330:
331: TYPE seeded_qual_type IS RECORD(
332: seeded_qualifier_id NUMBER:=FND_API.G_MISS_NUM
333: );
334:
335: TYPE seeded_qual_tbl_type IS TABLE OF seeded_qual_type
336: INDEX BY BINARY_INTEGER;

Line 339: grp_role_id NUMBER:=FND_API.G_MISS_NUM

335: TYPE seeded_qual_tbl_type IS TABLE OF seeded_qual_type
336: INDEX BY BINARY_INTEGER;
337:
338: TYPE role_typ IS RECORD(
339: grp_role_id NUMBER:=FND_API.G_MISS_NUM
340: );
341:
342: TYPE grp_role_tbl_type IS TABLE OF role_typ
343: INDEX BY BINARY_INTEGER;

Line 1035: l_init_msg_list := FND_API.G_TRUE;

1031: l_terr_qualtypeusgs_tbl(3).LAST_UPDATE_LOGIN := G_LOGIN_ID;
1032: l_terr_qualtypeusgs_tbl(3).TERR_ID := null;
1033: l_terr_qualtypeusgs_tbl(3).ORG_ID := terr_group.ORG_ID;
1034:
1035: l_init_msg_list := FND_API.G_TRUE;
1036:
1037:
1038: /* set org context using ORG_ID of Territory
1039: ** Group'S TOP-LEVEL PARENT TERRITORY */

Line 1050: p_validation_level => fnd_api.g_valid_level_NONE,

1046: jtf_territory_pvt.create_territory (
1047: p_api_version_number => l_api_version_number,
1048: p_init_msg_list => l_init_msg_list,
1049: p_commit => l_commit,
1050: p_validation_level => fnd_api.g_valid_level_NONE,
1051: x_return_status => x_return_status,
1052: x_msg_count => x_msg_count,
1053: x_msg_data => x_msg_data,
1054: p_terr_all_rec => l_terr_all_rec,

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

1081:
1082: ELSE
1083: WRITE_LOG(2,'ERROR: PLACEHOLDER TERRITORY CREATION FAILED ' ||
1084: 'FOR TERRITORY_GROUP_ID# ' ||TERR_GROUP.TERR_GROUP_ID);
1085: X_MSG_DATA := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
1086: WRITE_LOG(2,X_MSG_DATA);
1087:
1088: END IF;
1089: /* END: SUCCESSFUL TERRITORY CREATION? */

Line 1285: l_init_msg_list := FND_API.G_TRUE;

1281: l_terr_values_tbl(k).qualifier_tbl_index := 1;
1282:
1283: end loop;
1284:
1285: l_init_msg_list := FND_API.G_TRUE;
1286:
1287: -- 07/08/03: JDOCHERT: bug#3023653
1288: -- mo_global.set_org_context(terr_group.ORG_ID,null);
1289: --

Line 1294: p_validation_level => fnd_api.g_valid_level_NONE,

1290: jtf_territory_pvt.create_territory (
1291: p_api_version_number => l_api_version_number,
1292: p_init_msg_list => l_init_msg_list,
1293: p_commit => l_commit,
1294: p_validation_level => fnd_api.g_valid_level_NONE,
1295: x_return_status => x_return_status,
1296: x_msg_count => x_msg_count,
1297: x_msg_data => x_msg_data,
1298: p_terr_all_rec => l_terr_all_rec,

Line 1321: l_init_msg_list :=FND_API.G_TRUE;

1317: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
1318: , CATCH_ALL_FLAG = 'Y'
1319: where terr_id = x_terr_id;
1320:
1321: l_init_msg_list :=FND_API.G_TRUE;
1322:
1323: SELECT JTF_TERR_RSC_S.nextval
1324: into l_terr_rsc_id
1325: FROM DUAL;

Line 1409: l_init_msg_list := FND_API.G_TRUE;

1405:
1406: end if;
1407: end loop; /* End of rsc_acc */
1408:
1409: l_init_msg_list := FND_API.G_TRUE;
1410:
1411: -- 07/08/03: JDOCHERT: bug#3023653
1412: jtf_territory_resource_pvt.create_terrresource (
1413: p_api_version_number => l_Api_Version_Number,

Line 1416: p_validation_level => fnd_api.g_valid_level_NONE,

1412: jtf_territory_resource_pvt.create_terrresource (
1413: p_api_version_number => l_Api_Version_Number,
1414: p_init_msg_list => l_Init_Msg_List,
1415: p_commit => l_Commit,
1416: p_validation_level => fnd_api.g_valid_level_NONE,
1417: x_return_status => x_Return_Status,
1418: x_msg_count => x_Msg_Count,
1419: x_msg_data => x_msg_data,
1420: p_terrrsc_tbl => l_TerrRsc_tbl,

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

1428: x_terr_id);
1429: else
1430: write_log( 2,' FAILED IN RESOURCE CREATION FOR NAMED ACCOUNT CATCH ALL TERRITORY' ||
1431: x_terr_id);
1432: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
1433: end if;
1434:
1435: /* else of -if the catch all territory creation failed */
1436: else

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

1433: end if;
1434:
1435: /* else of -if the catch all territory creation failed */
1436: else
1437: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
1438: write_log(2,x_msg_data);
1439: WRITE_LOG(2,'ERROR: NA CATCH-ALL TERRITORY CREATION FAILED ' ||
1440: 'FOR TERRITORY_GROUP_ID# ' ||TERR_GROUP.TERR_GROUP_ID);
1441: end if;

Line 1660: l_init_msg_list :=FND_API.G_TRUE;

1656:
1657: end loop; /* qval IN pqual */
1658:
1659:
1660: l_init_msg_list :=FND_API.G_TRUE;
1661:
1662: -- 07/08/03: JDOCHERT: bug#3023653
1663: --mo_global.set_org_context(terr_group.ORG_ID,null);
1664: --

Line 1670: p_validation_level => fnd_api.g_valid_level_NONE,

1666: jtf_territory_pvt.create_territory (
1667: p_api_version_number => l_api_version_number,
1668: p_init_msg_list => l_init_msg_list,
1669: p_commit => l_commit,
1670: p_validation_level => fnd_api.g_valid_level_NONE,
1671: x_return_status => x_return_status,
1672: x_msg_count => x_msg_count,
1673: x_msg_data => x_msg_data,
1674: p_terr_all_rec => l_terr_all_rec,

Line 1701: l_init_msg_list :=FND_API.G_TRUE;

1697: , NAMED_ACCOUNT_FLAG = 'Y'
1698: , TERR_GROUP_ACCOUNT_ID = naterr.terr_group_account_id
1699: where terr_id = x_terr_id;
1700:
1701: l_init_msg_list :=FND_API.G_TRUE;
1702: i := 0;
1703: a := 0;
1704:
1705: FOR tran_type in role_interest_nonpi(terr_group.Terr_gROUP_ID)

Line 1801: l_init_msg_list :=FND_API.G_TRUE;

1797: end loop; /* FOR rsc in resource_grp */
1798:
1799: end loop;/* FOR tran_type in role_interest_nonpi */
1800:
1801: l_init_msg_list :=FND_API.G_TRUE;
1802:
1803: -- 07/08/03: JDOCHERT: bug#3023653
1804: jtf_territory_resource_pvt.create_terrresource (
1805: p_api_version_number => l_Api_Version_Number,

Line 1808: p_validation_level => fnd_api.g_valid_level_NONE,

1804: jtf_territory_resource_pvt.create_terrresource (
1805: p_api_version_number => l_Api_Version_Number,
1806: p_init_msg_list => l_Init_Msg_List,
1807: p_commit => l_Commit,
1808: p_validation_level => fnd_api.g_valid_level_NONE,
1809: x_return_status => x_Return_Status,
1810: x_msg_count => x_Msg_Count,
1811: x_msg_data => x_msg_data,
1812: p_terrrsc_tbl => l_TerrRsc_tbl,

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

1817:
1818: if x_Return_Status='S' then
1819: write_log(2,' Resource created for NA territory # ' ||x_terr_id);
1820: else
1821: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);
1822: write_log(2,x_msg_data);
1823: write_log(2, ' Failed in resource creation for NA territory # ' ||
1824: x_terr_id);
1825: end if;

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

1824: x_terr_id);
1825: end if;
1826:
1827: else
1828: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);
1829: write_log(2,substr(x_msg_data,1,254));
1830: WRITE_LOG(2,'ERROR: NA TERRITORY CREATION FAILED ' ||
1831: 'FOR NAMED_ACCOUNT_ID# ' || naterr.named_account_id );
1832: end if; /* END: Successful Territory creation? */

Line 2050: l_init_msg_list :=FND_API.G_TRUE;

2046:
2047: end loop; /* qval IN pqual */
2048:
2049:
2050: l_init_msg_list :=FND_API.G_TRUE;
2051:
2052: -- 07/08/03: JDOCHERT: bug#3023653
2053: --mo_global.set_org_context(terr_group.ORG_ID,null);
2054: --

Line 2060: p_validation_level => fnd_api.g_valid_level_NONE,

2056: jtf_territory_pvt.create_territory (
2057: p_api_version_number => l_api_version_number,
2058: p_init_msg_list => l_init_msg_list,
2059: p_commit => l_commit,
2060: p_validation_level => fnd_api.g_valid_level_NONE,
2061: x_return_status => x_return_status,
2062: x_msg_count => x_msg_count,
2063: x_msg_data => x_msg_data,
2064: p_terr_all_rec => l_terr_all_rec,

Line 2093: l_init_msg_list :=FND_API.G_TRUE;

2089: where terr_id = x_terr_id;
2090:
2091: --write_log(2,terr_group.terr_group_id);
2092: --write_log(2,tran_type.role_code);
2093: l_init_msg_list :=FND_API.G_TRUE;
2094: i := 0;
2095: a := 0;
2096:
2097: FOR tran_type in role_interest_nonpi(terr_group.Terr_gROUP_ID)

Line 2193: l_init_msg_list :=FND_API.G_TRUE;

2189: end loop; /* FOR rsc in resource_grp */
2190:
2191: end loop;/* FOR tran_type in role_interest_nonpi */
2192:
2193: l_init_msg_list :=FND_API.G_TRUE;
2194:
2195: -- 07/08/03: JDOCHERT: bug#3023653
2196: jtf_territory_resource_pvt.create_terrresource (
2197: p_api_version_number => l_Api_Version_Number,

Line 2200: p_validation_level => fnd_api.g_valid_level_NONE,

2196: jtf_territory_resource_pvt.create_terrresource (
2197: p_api_version_number => l_Api_Version_Number,
2198: p_init_msg_list => l_Init_Msg_List,
2199: p_commit => l_Commit,
2200: p_validation_level => fnd_api.g_valid_level_NONE,
2201: x_return_status => x_Return_Status,
2202: x_msg_count => x_Msg_Count,
2203: x_msg_data => x_msg_data,
2204: p_terrrsc_tbl => l_TerrRsc_tbl,

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

2209:
2210: if x_Return_Status='S' then
2211: write_log(2,' Resource created for NA territory # ' ||x_terr_id);
2212: else
2213: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);
2214: write_log(2,x_msg_data);
2215: write_log(2, ' Failed in resource creation for NA territory # ' ||
2216: x_terr_id);
2217: end if;

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

2216: x_terr_id);
2217: end if;
2218:
2219: else
2220: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);
2221: write_log(2,substr(x_msg_data,1,254));
2222: WRITE_LOG(2,'ERROR: NA TERRITORY CREATION FAILED ' ||
2223: 'FOR NAMED_ACCOUNT_ID# ' || naterr.named_account_id );
2224: end if; /* END: Successful Territory creation? */

Line 2449: l_init_msg_list :=FND_API.G_TRUE;

2445: END LOOP; /* csr_qual_val IN csr_get_qual_val */
2446: end loop; /* csr_qual IN csr_get_qual */
2447:
2448:
2449: l_init_msg_list :=FND_API.G_TRUE;
2450:
2451: -- 07/08/03: JDOCHERT: bug#3023653
2452: --mo_global.set_org_context(terr_group.ORG_ID,null);
2453: --

Line 2458: p_validation_level => fnd_api.g_valid_level_NONE,

2454: jtf_territory_pvt.create_territory (
2455: p_api_version_number => l_api_version_number,
2456: p_init_msg_list => l_init_msg_list,
2457: p_commit => l_commit,
2458: p_validation_level => fnd_api.g_valid_level_NONE,
2459: x_return_status => x_return_status,
2460: x_msg_count => x_msg_count,
2461: x_msg_data => x_msg_data,
2462: p_terr_all_rec => l_terr_all_rec,

Line 2641: l_init_msg_list :=FND_API.G_TRUE;

2637: l_terr_values_tbl(k).qualifier_tbl_index := j;
2638:
2639: end loop;
2640:
2641: l_init_msg_list :=FND_API.G_TRUE;
2642:
2643: -- 07/08/03: JDOCHERT: bug#3023653
2644: --mo_global.set_org_context(terr_group.ORG_ID,null);
2645: --

Line 2651: p_validation_level => fnd_api.g_valid_level_NONE,

2647: jtf_territory_pvt.create_territory (
2648: p_api_version_number => l_api_version_number,
2649: p_init_msg_list => l_init_msg_list,
2650: p_commit => l_commit,
2651: p_validation_level => fnd_api.g_valid_level_NONE,
2652: x_return_status => x_return_status,
2653: x_msg_count => x_msg_count,
2654: x_msg_data => x_msg_data,
2655: p_terr_all_rec => l_terr_all_rec,

Line 2883: l_init_msg_list :=FND_API.G_TRUE;

2879: end if;
2880:
2881: end loop;
2882:
2883: l_init_msg_list :=FND_API.G_TRUE;
2884:
2885: -- 07/08/03: JDOCHERT: bug#3023653
2886: --mo_global.set_org_context(terr_group.ORG_ID,null);
2887: --

Line 2893: p_validation_level => fnd_api.g_valid_level_NONE,

2889: jtf_territory_pvt.create_territory (
2890: p_api_version_number => l_api_version_number,
2891: p_init_msg_list => l_init_msg_list,
2892: p_commit => l_commit,
2893: p_validation_level => fnd_api.g_valid_level_NONE,
2894: x_return_status => x_return_status,
2895: x_msg_count => x_msg_count,
2896: x_msg_data => x_msg_data,
2897: p_terr_all_rec => l_terr_all_rec,

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

2920:
2921: write_log(2,' OVERLAY PI Territory Created = '||l_terr_all_rec.NAME);
2922:
2923: else
2924: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
2925: write_log(2,x_msg_data);
2926: write_log(2, 'Failed in OVERLAY PI Territory Creation for TERR_GROUP_ACCOUNT_ID#'||
2927: overlayterr.terr_group_account_id);
2928:

Line 3032: l_init_msg_list :=FND_API.G_TRUE;

3028: l_TerrRsc_Access_Tbl(a).qualifier_tbl_index:= i;
3029: end if;
3030: end loop; /* rsc_acc in role_access */
3031:
3032: l_init_msg_list :=FND_API.G_TRUE;
3033:
3034: -- 07/08/03: JDOCHERT: bug#3023653
3035: jtf_territory_resource_pvt.create_terrresource (
3036: p_api_version_number => l_Api_Version_Number,

Line 3039: p_validation_level => fnd_api.g_valid_level_NONE,

3035: jtf_territory_resource_pvt.create_terrresource (
3036: p_api_version_number => l_Api_Version_Number,
3037: p_init_msg_list => l_Init_Msg_List,
3038: p_commit => l_Commit,
3039: p_validation_level => fnd_api.g_valid_level_NONE,
3040: x_return_status => x_Return_Status,
3041: x_msg_count => x_Msg_Count,
3042: x_msg_data => x_msg_data,
3043: p_terrrsc_tbl => l_TerrRsc_tbl,

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

3057:
3058: end loop;
3059:
3060: else
3061: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
3062: write_log(2,x_msg_data);
3063: write_log(2,'Failed in OVERLAY Territory Creation for Territory Group: ' ||
3064: terr_group.terr_group_id || ' : ' ||
3065: terr_group.terr_group_name );

Line 3222: l_init_msg_list :=FND_API.G_TRUE;

3218: l_terr_values_tbl(k).qualifier_tbl_index := j;
3219:
3220: end loop;
3221:
3222: l_init_msg_list :=FND_API.G_TRUE;
3223:
3224: -- 07/08/03: JDOCHERT: bug#3023653
3225: --mo_global.set_org_context(terr_group.ORG_ID,null);
3226: --

Line 3232: p_validation_level => fnd_api.g_valid_level_NONE,

3228: jtf_territory_pvt.create_territory (
3229: p_api_version_number => l_api_version_number,
3230: p_init_msg_list => l_init_msg_list,
3231: p_commit => l_commit,
3232: p_validation_level => fnd_api.g_valid_level_NONE,
3233: x_return_status => x_return_status,
3234: x_msg_count => x_msg_count,
3235: x_msg_data => x_msg_data,
3236: p_terr_all_rec => l_terr_all_rec,

Line 3462: l_init_msg_list :=FND_API.G_TRUE;

3458: end if;
3459:
3460: end loop;
3461:
3462: l_init_msg_list :=FND_API.G_TRUE;
3463:
3464: -- 07/08/03: JDOCHERT: bug#3023653
3465: --mo_global.set_org_context(terr_group.ORG_ID,null);
3466: --

Line 3475: p_validation_level => fnd_api.g_valid_level_NONE,

3471: jtf_territory_pvt.create_territory (
3472: p_api_version_number => l_api_version_number,
3473: p_init_msg_list => l_init_msg_list,
3474: p_commit => l_commit,
3475: p_validation_level => fnd_api.g_valid_level_NONE,
3476: x_return_status => x_return_status,
3477: x_msg_count => x_msg_count,
3478: x_msg_data => x_msg_data,
3479: p_terr_all_rec => l_terr_all_rec,

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

3502:
3503: write_log(2,' OVERLAY CNR territory created:' || l_terr_all_rec.NAME);
3504:
3505: else
3506: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
3507: write_log(2,x_msg_data);
3508: write_log(2,'Failed in OVERLAY CNR territory treation for ' ||
3509: 'TERR_GROUP_ACCOUNT_ID = ' ||
3510: overlayterr.terr_group_account_id );

Line 3616: l_init_msg_list :=FND_API.G_TRUE;

3612: l_TerrRsc_Access_Tbl(a).qualifier_tbl_index:= i;
3613: end if;
3614: end loop; /* rsc_acc in role_access */
3615:
3616: l_init_msg_list :=FND_API.G_TRUE;
3617:
3618: -- 07/08/03: JDOCHERT: bug#3023653
3619: jtf_territory_resource_pvt.create_terrresource (
3620: p_api_version_number => l_Api_Version_Number,

Line 3623: p_validation_level => fnd_api.g_valid_level_NONE,

3619: jtf_territory_resource_pvt.create_terrresource (
3620: p_api_version_number => l_Api_Version_Number,
3621: p_init_msg_list => l_Init_Msg_List,
3622: p_commit => l_Commit,
3623: p_validation_level => fnd_api.g_valid_level_NONE,
3624: x_return_status => x_Return_Status,
3625: x_msg_count => x_Msg_Count,
3626: x_msg_data => x_msg_data,
3627: p_terrrsc_tbl => l_TerrRsc_tbl,

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

3642:
3643: end loop;
3644:
3645: else
3646: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
3647: write_log(2,x_msg_data);
3648: write_log(2,'Failed in OVERLAY Territory Creation for Territory Group: ' ||
3649: terr_group.terr_group_id || ' : ' ||
3650: terr_group.terr_group_name );

Line 4262: l_init_msg_list :=FND_API.G_TRUE;

4258: l_terr_values_tbl(k).qualifier_tbl_index := j;
4259:
4260: end loop; /* qval IN pqual */
4261:
4262: l_init_msg_list :=FND_API.G_TRUE;
4263:
4264: if l_prev_qual_usg_id <> 1 then -- geography territory values are there if this condition is true
4265: jtf_territory_pvt.create_territory (
4266: p_api_version_number => l_api_version_number,

Line 4269: p_validation_level => fnd_api.g_valid_level_NONE,

4265: jtf_territory_pvt.create_territory (
4266: p_api_version_number => l_api_version_number,
4267: p_init_msg_list => l_init_msg_list,
4268: p_commit=> l_commit,
4269: p_validation_level => fnd_api.g_valid_level_NONE,
4270: x_return_status => x_return_status,
4271: x_msg_count => x_msg_count,
4272: x_msg_data => x_msg_data,
4273: p_terr_all_rec => l_terr_all_rec,

Line 4301: l_init_msg_list :=FND_API.G_TRUE;

4297:
4298: --write_log(2,p_terr_group_rec.terr_group_id);
4299: --write_log(2,tran_type.role_code);
4300:
4301: l_init_msg_list :=FND_API.G_TRUE;
4302: i := 0;
4303: a := 0;
4304:
4305: FOR tran_type in role_interest_nonpi(p_terr_group_rec.Terr_gROUP_ID)

Line 4397: l_init_msg_list :=FND_API.G_TRUE;

4393: end loop; /* FOR rsc in resource_grp */
4394:
4395: end loop;/* FOR tran_type in role_interest_nonpi */
4396:
4397: l_init_msg_list :=FND_API.G_TRUE;
4398:
4399: jtf_territory_resource_pvt.create_terrresource (
4400: p_api_version_number => l_Api_Version_Number,
4401: p_init_msg_list => l_Init_Msg_List,

Line 4403: p_validation_level => fnd_api.g_valid_level_NONE,

4399: jtf_territory_resource_pvt.create_terrresource (
4400: p_api_version_number => l_Api_Version_Number,
4401: p_init_msg_list => l_Init_Msg_List,
4402: p_commit => l_Commit,
4403: p_validation_level => fnd_api.g_valid_level_NONE,
4404: x_return_status => x_Return_Status,
4405: x_msg_count => x_Msg_Count,
4406: x_msg_data => x_msg_data,
4407: p_terrrsc_tbl => l_TerrRsc_tbl,

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

4412:
4413: if x_Return_Status='S' then
4414: write_log(2,'Resource created for Geo territory # ' ||x_terr_id);
4415: else
4416: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);
4417: write_log(2,x_msg_data);
4418: write_log(2, ' Failed in resource creation for Geo territory # ' ||
4419: x_terr_id);
4420: end if;

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

4419: x_terr_id);
4420: end if;
4421:
4422: else
4423: x_msg_data := substr(fnd_msg_pub.get(1, fnd_api.g_false),1,254);
4424: write_log(2,substr(x_msg_data,1,254));
4425: WRITE_LOG(2,'ERROR: NA TERRITORY CREATION FAILED ' ||
4426: 'FOR NAMED_ACCOUNT_ID# ' );
4427: end if; /* END: Successful Territory creation? */

Line 4631: l_init_msg_list :=FND_API.G_TRUE;

4627:
4628: end loop; /* csr_qual IN csr_get_qual */
4629:
4630:
4631: l_init_msg_list :=FND_API.G_TRUE;
4632:
4633: -- 07/08/03: JDOCHERT: bug#3023653
4634: --mo_global.set_org_context(p_terr_group_rec.ORG_ID,null);
4635: --

Line 4641: p_validation_level => fnd_api.g_valid_level_NONE,

4637: jtf_territory_pvt.create_territory (
4638: p_api_version_number => l_api_version_number,
4639: p_init_msg_list => l_init_msg_list,
4640: p_commit => l_commit,
4641: p_validation_level => fnd_api.g_valid_level_NONE,
4642: x_return_status => x_return_status,
4643: x_msg_count => x_msg_count,
4644: x_msg_data => x_msg_data,
4645: p_terr_all_rec => l_terr_all_rec,

Line 4822: l_init_msg_list :=FND_API.G_TRUE;

4818: l_terr_values_tbl(k).qualifier_tbl_index := j;
4819:
4820: end loop; /* gval */
4821:
4822: l_init_msg_list :=FND_API.G_TRUE;
4823:
4824:
4825: jtf_territory_pvt.create_territory (
4826: p_api_version_number => l_api_version_number,

Line 4829: p_validation_level => fnd_api.g_valid_level_NONE,

4825: jtf_territory_pvt.create_territory (
4826: p_api_version_number => l_api_version_number,
4827: p_init_msg_list => l_init_msg_list,
4828: p_commit => l_commit,
4829: p_validation_level => fnd_api.g_valid_level_NONE,
4830: x_return_status => x_return_status,
4831: x_msg_count => x_msg_count,
4832: x_msg_data => x_msg_data,
4833: p_terr_all_rec => l_terr_all_rec,

Line 5059: l_init_msg_list :=FND_API.G_TRUE;

5055: end if;
5056:
5057: end loop; /* acc_type */
5058:
5059: l_init_msg_list :=FND_API.G_TRUE;
5060:
5061: jtf_territory_pvt.create_territory (
5062: p_api_version_number => l_api_version_number,
5063: p_init_msg_list => l_init_msg_list,

Line 5065: p_validation_level => fnd_api.g_valid_level_NONE,

5061: jtf_territory_pvt.create_territory (
5062: p_api_version_number => l_api_version_number,
5063: p_init_msg_list => l_init_msg_list,
5064: p_commit => l_commit,
5065: p_validation_level => fnd_api.g_valid_level_NONE,
5066: x_return_status => x_return_status,
5067: x_msg_count => x_msg_count,
5068: x_msg_data => x_msg_data,
5069: p_terr_all_rec => l_terr_all_rec,

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

5088:
5089: write_log(2,' OVERLAY PI Territory Created = '||l_terr_all_rec.NAME);
5090:
5091: else
5092: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
5093: write_log(2,x_msg_data);
5094: write_log(2, 'Failed in OVERLAY PI Territory Creation for p_terr_group_rec.ACCOUNT_ID#');
5095:
5096: end if; /* x_return_status */

Line 5179: l_init_msg_list :=FND_API.G_TRUE;

5175: end loop; /* rsc_acc in role_access */
5176:
5177: end loop; /* rsc in resource_grp */
5178:
5179: l_init_msg_list :=FND_API.G_TRUE;
5180:
5181: jtf_territory_resource_pvt.create_terrresource (
5182: p_api_version_number => l_Api_Version_Number,
5183: p_init_msg_list => l_Init_Msg_List,

Line 5185: p_validation_level => fnd_api.g_valid_level_NONE,

5181: jtf_territory_resource_pvt.create_terrresource (
5182: p_api_version_number => l_Api_Version_Number,
5183: p_init_msg_list => l_Init_Msg_List,
5184: p_commit => l_Commit,
5185: p_validation_level => fnd_api.g_valid_level_NONE,
5186: x_return_status => x_Return_Status,
5187: x_msg_count => x_Msg_Count,
5188: x_msg_data => x_msg_data,
5189: p_terrrsc_tbl => l_TerrRsc_tbl,

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

5205:
5206: end loop; /* pit */
5207:
5208: else
5209: x_msg_data := fnd_msg_pub.get(1, fnd_api.g_false);
5210: write_log(2,x_msg_data);
5211: write_log(2,'Failed in OVERLAY Territory Creation for Territory Group: ' ||
5212: p_terr_group_rec.terr_group_id || ' : ' ||
5213: p_terr_group_rec.terr_group_name );

Line 5227: when FND_API.G_EXC_ERROR then

5223: end if; /* l_pi_count*/
5224:
5225:
5226: EXCEPTION
5227: when FND_API.G_EXC_ERROR then
5228: -- JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
5229: RETURN;
5230: when FND_API.G_EXC_UNEXPECTED_ERROR then
5231: -- JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );

Line 5230: when FND_API.G_EXC_UNEXPECTED_ERROR then

5226: EXCEPTION
5227: when FND_API.G_EXC_ERROR then
5228: -- JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
5229: RETURN;
5230: when FND_API.G_EXC_UNEXPECTED_ERROR then
5231: -- JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );
5232: RETURN;
5233: when others then
5234: -- JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log (' Error in Synchronizing the SUMM table' || SQLERRM );