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

Line 486: x_return_status := FND_API.G_RET_STS_SUCCESS;

482: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA',
483: 'Start of the procedure JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA');
484: END IF;
485:
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487:
488: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
489: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
490: 'jtf.plsql.JTF_TTY_GEN_TERR_PVT.delete_bulk_TGA',

Line 576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

572: EXCEPTION
573: WHEN NO_DATA_FOUND THEN
574: NULL;
575: WHEN OTHERS THEN
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
577: x_msg_data := SQLCODE || ' : ' || SQLERRM;
578: x_msg_count := 1;
579: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
580: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,

Line 930: grp_role_id NUMBER:=FND_API.G_MISS_NUM

926: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
927: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
928:
929: TYPE role_typ IS RECORD(
930: grp_role_id NUMBER:=FND_API.G_MISS_NUM
931: );
932:
933: TYPE grp_role_tbl_type IS TABLE OF role_typ
934: INDEX BY BINARY_INTEGER;

Line 1580: l_init_msg_list := FND_API.G_TRUE;

1576: l_terr_values_tbl(k).qualifier_tbl_index := j;
1577:
1578: END LOOP; /* end FOR gval IN geo_values */
1579:
1580: l_init_msg_list := FND_API.G_TRUE;
1581:
1582: IF l_prev_qual_usg_id <> 1 THEN -- geography territory values are there if this condition is true
1583: JTF_TERRITORY_PVT.create_territory (
1584: p_api_version_number => l_api_version_number,

Line 1587: p_validation_level => FND_API.g_valid_level_NONE,

1583: JTF_TERRITORY_PVT.create_territory (
1584: p_api_version_number => l_api_version_number,
1585: p_init_msg_list => l_init_msg_list,
1586: p_commit => l_commit,
1587: p_validation_level => FND_API.g_valid_level_NONE,
1588: x_return_status => x_return_status,
1589: x_msg_count => x_msg_count,
1590: x_msg_data => x_msg_data,
1591: p_terr_all_rec => l_terr_all_rec,

Line 1615: l_init_msg_list :=FND_API.G_TRUE;

1611: , GEO_TERR_FLAG = 'Y'
1612: , GEO_TERRITORY_ID = p_geo_territory_id(x)
1613: WHERE terr_id = x_terr_id;
1614:
1615: l_init_msg_list :=FND_API.G_TRUE;
1616: i := 0;
1617: a := 0;
1618:
1619: FOR tran_type IN role_interest_nonpi(p_Terr_gROUP_ID(x)) LOOP

Line 1709: l_init_msg_list :=FND_API.G_TRUE;

1705: END LOOP; /* FOR rsc in resource_grp */
1706:
1707: END LOOP;/* FOR tran_type in role_interest_nonpi */
1708:
1709: l_init_msg_list :=FND_API.G_TRUE;
1710:
1711: Jtf_Territory_Resource_Pvt.create_terrresource (
1712: p_api_version_number => l_Api_Version_Number,
1713: p_init_msg_list => l_Init_Msg_List,

Line 1715: p_validation_level => FND_API.g_valid_level_NONE,

1711: Jtf_Territory_Resource_Pvt.create_terrresource (
1712: p_api_version_number => l_Api_Version_Number,
1713: p_init_msg_list => l_Init_Msg_List,
1714: p_commit => l_Commit,
1715: p_validation_level => FND_API.g_valid_level_NONE,
1716: x_return_status => x_Return_Status,
1717: x_msg_count => x_Msg_Count,
1718: x_msg_data => x_msg_data,
1719: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 1731: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);

1727: write_log(2,'Resource created for Geo territory # ' ||x_terr_id);
1728: END IF;
1729: ELSE
1730: IF G_Debug THEN
1731: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);
1732: write_log(2,x_msg_data);
1733: write_log(2, ' Failed in resource creation for Geo territory # ' || x_terr_id);
1734: END IF;
1735: END IF;

Line 1739: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);

1735: END IF;
1736:
1737: ELSE
1738: IF G_Debug THEN
1739: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);
1740: write_log(2,SUBSTR(x_msg_data,1,254));
1741: END IF;
1742: END IF; /* END: Successful Territory creation? */
1743: END IF; /* end if l_prev_qual_usg_id <> 1 */

Line 1935: l_init_msg_list :=FND_API.G_TRUE;

1931: l_terr_values_tbl(k).qualifier_tbl_index := j;
1932:
1933: END LOOP; /* gval */
1934:
1935: l_init_msg_list :=FND_API.G_TRUE;
1936:
1937: JTF_TERRITORY_PVT.create_territory (
1938: p_api_version_number => l_api_version_number,
1939: p_init_msg_list => l_init_msg_list,

Line 1941: p_validation_level => FND_API.g_valid_level_NONE,

1937: JTF_TERRITORY_PVT.create_territory (
1938: p_api_version_number => l_api_version_number,
1939: p_init_msg_list => l_init_msg_list,
1940: p_commit => l_commit,
1941: p_validation_level => FND_API.g_valid_level_NONE,
1942: x_return_status => x_return_status,
1943: x_msg_count => x_msg_count,
1944: x_msg_data => x_msg_data,
1945: p_terr_all_rec => l_terr_all_rec,

Line 2173: l_init_msg_list :=FND_API.G_TRUE;

2169: END IF;
2170:
2171: END LOOP; /* end for acc_type in role_access */
2172:
2173: l_init_msg_list :=FND_API.G_TRUE;
2174:
2175: JTF_TERRITORY_PVT.create_territory (
2176: p_api_version_number => l_api_version_number,
2177: p_init_msg_list => l_init_msg_list,

Line 2179: p_validation_level => FND_API.g_valid_level_NONE,

2175: JTF_TERRITORY_PVT.create_territory (
2176: p_api_version_number => l_api_version_number,
2177: p_init_msg_list => l_init_msg_list,
2178: p_commit => l_commit,
2179: p_validation_level => FND_API.g_valid_level_NONE,
2180: x_return_status => x_return_status,
2181: x_msg_count => x_msg_count,
2182: x_msg_data => x_msg_data,
2183: p_terr_all_rec => l_terr_all_rec,

Line 2212: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

2208: END IF;
2209:
2210: ELSE
2211: IF G_Debug THEN
2212: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
2213: write_log(2,x_msg_data);
2214: END IF;
2215:
2216: END IF; /* x_return_status */

Line 2292: l_init_msg_list :=FND_API.G_TRUE;

2288: END LOOP; /* rsc_acc in role_access */
2289:
2290: END LOOP; /* rsc in resource_grp */
2291:
2292: l_init_msg_list :=FND_API.G_TRUE;
2293:
2294: Jtf_Territory_Resource_Pvt.create_terrresource (
2295: p_api_version_number => l_Api_Version_Number,
2296: p_init_msg_list => l_Init_Msg_List,

Line 2298: p_validation_level => FND_API.g_valid_level_NONE,

2294: Jtf_Territory_Resource_Pvt.create_terrresource (
2295: p_api_version_number => l_Api_Version_Number,
2296: p_init_msg_list => l_Init_Msg_List,
2297: p_commit => l_Commit,
2298: p_validation_level => FND_API.g_valid_level_NONE,
2299: x_return_status => x_Return_Status,
2300: x_msg_count => x_Msg_Count,
2301: x_msg_data => x_msg_data,
2302: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 2323: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

2319: END LOOP; /* end for pit in role_pi */
2320:
2321: ELSE
2322: IF G_Debug THEN
2323: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
2324: write_log(2,x_msg_data);
2325: write_log(2,'Failed in OVERLAY Territory Creation for Territory : ' ||
2326: p_geo_territory_id(x) || ' : ' ||
2327: p_geo_terr_name(x) );

Line 2427: grp_role_id NUMBER:=FND_API.G_MISS_NUM

2423: l_terr_qual_empty_tbl JTF_TERRITORY_PVT.terr_qual_tbl_type;
2424: l_terr_values_empty_tbl JTF_TERRITORY_PVT.terr_values_tbl_type;
2425:
2426: TYPE role_typ IS RECORD(
2427: grp_role_id NUMBER:=FND_API.G_MISS_NUM
2428: );
2429:
2430: TYPE grp_role_tbl_type IS TABLE OF role_typ
2431: INDEX BY BINARY_INTEGER;

Line 3008: l_init_msg_list := FND_API.G_TRUE;

3004: l_terr_qualtypeusgs_tbl(3).LAST_UPDATE_LOGIN := G_LOGIN_ID;
3005: l_terr_qualtypeusgs_tbl(3).TERR_ID := NULL;
3006: l_terr_qualtypeusgs_tbl(3).ORG_ID := p_ORG_ID(x);
3007:
3008: l_init_msg_list := FND_API.G_TRUE;
3009:
3010: /* CALL CREATE TERRITORY API */
3011: JTF_TERRITORY_PVT.create_territory (
3012: p_api_version_number => l_api_version_number,

Line 3015: p_validation_level => FND_API.g_valid_level_NONE,

3011: JTF_TERRITORY_PVT.create_territory (
3012: p_api_version_number => l_api_version_number,
3013: p_init_msg_list => l_init_msg_list,
3014: p_commit => l_commit,
3015: p_validation_level => FND_API.g_valid_level_NONE,
3016: x_return_status => x_return_status,
3017: x_msg_count => x_msg_count,
3018: x_msg_data => x_msg_data,
3019: p_terr_all_rec => l_terr_all_rec,

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

3049: ELSE
3050: IF G_Debug THEN
3051: WRITE_LOG(2,'ERROR: PLACEHOLDER TERRITORY CREATION FAILED ' ||
3052: 'FOR TERRITORY_GROUP_ID# ' || p_TERR_GROUP_ID(x));
3053: X_MSG_DATA := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
3054: WRITE_LOG(2,X_MSG_DATA);
3055: END IF;
3056:
3057: END IF;

Line 3239: l_init_msg_list := FND_API.G_TRUE;

3235: l_terr_values_tbl(k).qualifier_tbl_index := j;
3236:
3237: END LOOP; /* end FOR gval IN geo_values */
3238:
3239: l_init_msg_list := FND_API.G_TRUE;
3240:
3241: IF l_prev_qual_usg_id <> 1 THEN -- geography territory values are there if this condition is true
3242: JTF_TERRITORY_PVT.create_territory (
3243: p_api_version_number => l_api_version_number,

Line 3246: p_validation_level => FND_API.g_valid_level_NONE,

3242: JTF_TERRITORY_PVT.create_territory (
3243: p_api_version_number => l_api_version_number,
3244: p_init_msg_list => l_init_msg_list,
3245: p_commit => l_commit,
3246: p_validation_level => FND_API.g_valid_level_NONE,
3247: x_return_status => x_return_status,
3248: x_msg_count => x_msg_count,
3249: x_msg_data => x_msg_data,
3250: p_terr_all_rec => l_terr_all_rec,

Line 3277: l_init_msg_list :=FND_API.G_TRUE;

3273: , GEO_TERR_FLAG = 'Y'
3274: , GEO_TERRITORY_ID = geo_terr.geo_territory_id
3275: WHERE terr_id = x_terr_id;
3276:
3277: l_init_msg_list :=FND_API.G_TRUE;
3278: i := 0;
3279: a := 0;
3280:
3281: FOR tran_type IN role_interest_nonpi(p_Terr_gROUP_ID(x)) LOOP

Line 3371: l_init_msg_list :=FND_API.G_TRUE;

3367: END LOOP; /* FOR rsc in resource_grp */
3368:
3369: END LOOP;/* FOR tran_type in role_interest_nonpi */
3370:
3371: l_init_msg_list :=FND_API.G_TRUE;
3372:
3373: Jtf_Territory_Resource_Pvt.create_terrresource (
3374: p_api_version_number => l_Api_Version_Number,
3375: p_init_msg_list => l_Init_Msg_List,

Line 3377: p_validation_level => FND_API.g_valid_level_NONE,

3373: Jtf_Territory_Resource_Pvt.create_terrresource (
3374: p_api_version_number => l_Api_Version_Number,
3375: p_init_msg_list => l_Init_Msg_List,
3376: p_commit => l_Commit,
3377: p_validation_level => FND_API.g_valid_level_NONE,
3378: x_return_status => x_Return_Status,
3379: x_msg_count => x_Msg_Count,
3380: x_msg_data => x_msg_data,
3381: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 3393: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);

3389: write_log(2,'Resource created for Geo territory # ' ||x_terr_id);
3390: END IF;
3391: ELSE
3392: IF G_Debug THEN
3393: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);
3394: write_log(2,x_msg_data);
3395: write_log(2, ' Failed in resource creation for Geo territory # ' || x_terr_id);
3396: END IF;
3397: END IF;

Line 3401: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);

3397: END IF;
3398:
3399: ELSE
3400: IF G_Debug THEN
3401: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);
3402: write_log(2,SUBSTR(x_msg_data,1,254));
3403: END IF;
3404: END IF; /* END: Successful Territory creation? */
3405: END IF; /* end if l_prev_qual_usg_id <> 1 */

Line 3610: l_init_msg_list :=FND_API.G_TRUE;

3606: END LOOP;/* csr_qual_val IN csr_get_qual_val */
3607:
3608: END LOOP; /* csr_qual IN csr_get_qual */
3609:
3610: l_init_msg_list :=FND_API.G_TRUE;
3611:
3612: JTF_TERRITORY_PVT.create_territory (
3613: p_api_version_number => l_api_version_number,
3614: p_init_msg_list => l_init_msg_list,

Line 3616: p_validation_level => FND_API.g_valid_level_NONE,

3612: JTF_TERRITORY_PVT.create_territory (
3613: p_api_version_number => l_api_version_number,
3614: p_init_msg_list => l_init_msg_list,
3615: p_commit => l_commit,
3616: p_validation_level => FND_API.g_valid_level_NONE,
3617: x_return_status => x_return_status,
3618: x_msg_count => x_msg_count,
3619: x_msg_data => x_msg_data,
3620: p_terr_all_rec => l_terr_all_rec,

Line 3791: l_init_msg_list :=FND_API.G_TRUE;

3787: l_terr_values_tbl(k).qualifier_tbl_index := j;
3788:
3789: END LOOP; /* gval */
3790:
3791: l_init_msg_list :=FND_API.G_TRUE;
3792:
3793: JTF_TERRITORY_PVT.create_territory (
3794: p_api_version_number => l_api_version_number,
3795: p_init_msg_list => l_init_msg_list,

Line 3797: p_validation_level => FND_API.g_valid_level_NONE,

3793: JTF_TERRITORY_PVT.create_territory (
3794: p_api_version_number => l_api_version_number,
3795: p_init_msg_list => l_init_msg_list,
3796: p_commit => l_commit,
3797: p_validation_level => FND_API.g_valid_level_NONE,
3798: x_return_status => x_return_status,
3799: x_msg_count => x_msg_count,
3800: x_msg_data => x_msg_data,
3801: p_terr_all_rec => l_terr_all_rec,

Line 4029: l_init_msg_list :=FND_API.G_TRUE;

4025: END IF;
4026:
4027: END LOOP; /* end for acc_type in role_access */
4028:
4029: l_init_msg_list :=FND_API.G_TRUE;
4030:
4031: JTF_TERRITORY_PVT.create_territory (
4032: p_api_version_number => l_api_version_number,
4033: p_init_msg_list => l_init_msg_list,

Line 4035: p_validation_level => FND_API.g_valid_level_NONE,

4031: JTF_TERRITORY_PVT.create_territory (
4032: p_api_version_number => l_api_version_number,
4033: p_init_msg_list => l_init_msg_list,
4034: p_commit => l_commit,
4035: p_validation_level => FND_API.g_valid_level_NONE,
4036: x_return_status => x_return_status,
4037: x_msg_count => x_msg_count,
4038: x_msg_data => x_msg_data,
4039: p_terr_all_rec => l_terr_all_rec,

Line 4068: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

4064: END IF;
4065:
4066: ELSE
4067: IF G_Debug THEN
4068: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
4069: write_log(2,x_msg_data);
4070: END IF;
4071:
4072: END IF; /* x_return_status */

Line 4148: l_init_msg_list :=FND_API.G_TRUE;

4144: END LOOP; /* rsc_acc in role_access */
4145:
4146: END LOOP; /* rsc in resource_grp */
4147:
4148: l_init_msg_list :=FND_API.G_TRUE;
4149:
4150: Jtf_Territory_Resource_Pvt.create_terrresource (
4151: p_api_version_number => l_Api_Version_Number,
4152: p_init_msg_list => l_Init_Msg_List,

Line 4154: p_validation_level => FND_API.g_valid_level_NONE,

4150: Jtf_Territory_Resource_Pvt.create_terrresource (
4151: p_api_version_number => l_Api_Version_Number,
4152: p_init_msg_list => l_Init_Msg_List,
4153: p_commit => l_Commit,
4154: p_validation_level => FND_API.g_valid_level_NONE,
4155: x_return_status => x_Return_Status,
4156: x_msg_count => x_Msg_Count,
4157: x_msg_data => x_msg_data,
4158: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 4179: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

4175: END LOOP; /* end for pit in role_pi */
4176:
4177: ELSE
4178: IF G_Debug THEN
4179: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
4180: write_log(2,x_msg_data);
4181: write_log(2,'Failed in OVERLAY Territory Creation for Territory Group: ' ||
4182: p_terr_group_id(x) || ' : ' ||
4183: p_terr_group_name(x) );

Line 4291: grp_role_id NUMBER:=FND_API.G_MISS_NUM

4287: ,p_terr_attribute15 IN g_terr_attribute_tab)
4288: IS
4289:
4290: TYPE role_typ IS RECORD(
4291: grp_role_id NUMBER:=FND_API.G_MISS_NUM
4292: );
4293:
4294: TYPE grp_role_tbl_type IS TABLE OF role_typ
4295: INDEX BY BINARY_INTEGER;

Line 4831: p_validation_level => FND_API.g_valid_level_NONE,

4827: JTF_TERRITORY_PVT.Create_Terr_Value(
4828: P_Api_Version_Number => l_Api_Version_Number,
4829: P_Init_Msg_List => l_Init_Msg_List,
4830: P_Commit => l_Commit,
4831: p_validation_level => FND_API.g_valid_level_NONE,
4832: P_Terr_Id => p_catchall_terr_id(x),
4833: p_terr_qual_id => l_Terr_Qual_Id,
4834: P_Terr_Value_Tbl => l_Terr_Values_Tbl,
4835: X_Return_Status => x_Return_Status,

Line 5087: l_init_msg_list :=FND_API.G_TRUE;

5083: END IF;
5084:
5085: END LOOP; /* qval IN pqual */
5086:
5087: l_init_msg_list :=FND_API.G_TRUE;
5088:
5089: JTF_TERRITORY_PVT.create_territory (
5090: p_api_version_number => l_api_version_number,
5091: p_init_msg_list => l_init_msg_list,

Line 5093: p_validation_level => FND_API.g_valid_level_NONE,

5089: JTF_TERRITORY_PVT.create_territory (
5090: p_api_version_number => l_api_version_number,
5091: p_init_msg_list => l_init_msg_list,
5092: p_commit => l_commit,
5093: p_validation_level => FND_API.g_valid_level_NONE,
5094: x_return_status => x_return_status,
5095: x_msg_count => x_msg_count,
5096: x_msg_data => x_msg_data,
5097: p_terr_all_rec => l_terr_all_rec,

Line 5127: l_init_msg_list :=FND_API.G_TRUE;

5123: , NAMED_ACCOUNT_FLAG = 'Y'
5124: , TERR_GROUP_ACCOUNT_ID = naterr.terr_group_account_id
5125: WHERE terr_id = x_terr_id;
5126:
5127: l_init_msg_list :=FND_API.G_TRUE;
5128: i := 0;
5129: a := 0;
5130:
5131: FOR tran_type IN role_interest_nonpi(p_terr_group_id(x)) LOOP

Line 5219: l_init_msg_list :=FND_API.G_TRUE;

5215: END LOOP; /* FOR rsc in resource_grp */
5216:
5217: END LOOP;/* FOR tran_type in role_interest_nonpi */
5218:
5219: l_init_msg_list :=FND_API.G_TRUE;
5220:
5221:
5222: -- 07/08/03: JDOCHERT: bug#3023653
5223: Jtf_Territory_Resource_Pvt.create_terrresource (

Line 5227: p_validation_level => FND_API.g_valid_level_NONE,

5223: Jtf_Territory_Resource_Pvt.create_terrresource (
5224: p_api_version_number => l_Api_Version_Number,
5225: p_init_msg_list => l_Init_Msg_List,
5226: p_commit => l_Commit,
5227: p_validation_level => FND_API.g_valid_level_NONE,
5228: x_return_status => x_Return_Status,
5229: x_msg_count => x_Msg_Count,
5230: x_msg_data => x_msg_data,
5231: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 5243: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);

5239: IF G_Debug THEN
5240: write_log(2,' Resource created for NA territory # ' ||x_terr_id);
5241: END IF;
5242: ELSE
5243: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);
5244: IF G_Debug THEN
5245: write_log(2,x_msg_data);
5246: write_log(2, ' Failed in resource creation for NA territory # ' || x_terr_id);
5247: END IF;

Line 5251: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);

5247: END IF;
5248: END IF;
5249:
5250: ELSE
5251: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);
5252: IF G_Debug THEN
5253: write_log(2,SUBSTR(x_msg_data,1,254));
5254: WRITE_LOG(2,'ERROR: NA TERRITORY CREATION FAILED ' || 'FOR NAMED_ACCOUNT_ID# ' || naterr.named_account_id );
5255: END IF;

Line 5467: l_init_msg_list :=FND_API.G_TRUE;

5463: l_terr_values_tbl(k).qualifier_tbl_index := j;
5464:
5465: END LOOP; /* qval IN pqual */
5466:
5467: l_init_msg_list :=FND_API.G_TRUE;
5468:
5469: JTF_TERRITORY_PVT.create_territory (
5470: p_api_version_number => l_api_version_number,
5471: p_init_msg_list => l_init_msg_list,

Line 5473: p_validation_level => FND_API.g_valid_level_NONE,

5469: JTF_TERRITORY_PVT.create_territory (
5470: p_api_version_number => l_api_version_number,
5471: p_init_msg_list => l_init_msg_list,
5472: p_commit => l_commit,
5473: p_validation_level => FND_API.g_valid_level_NONE,
5474: x_return_status => x_return_status,
5475: x_msg_count => x_msg_count,
5476: x_msg_data => x_msg_data,
5477: p_terr_all_rec => l_terr_all_rec,

Line 5508: l_init_msg_list :=FND_API.G_TRUE;

5504: , NAMED_ACCOUNT_FLAG = 'Y'
5505: , TERR_GROUP_ACCOUNT_ID = naterr.terr_group_account_id
5506: WHERE terr_id = x_terr_id;
5507:
5508: l_init_msg_list :=FND_API.G_TRUE;
5509: i := 0;
5510: a := 0;
5511:
5512: FOR tran_type IN role_interest_nonpi(p_terr_group_id(x)) LOOP

Line 5598: l_init_msg_list :=FND_API.G_TRUE;

5594: END LOOP; /* FOR rsc in resource_grp */
5595:
5596: END LOOP;/* FOR tran_type in role_interest_nonpi */
5597:
5598: l_init_msg_list :=FND_API.G_TRUE;
5599:
5600: Jtf_Territory_Resource_Pvt.create_terrresource (
5601: p_api_version_number => l_Api_Version_Number,
5602: p_init_msg_list => l_Init_Msg_List,

Line 5604: p_validation_level => FND_API.g_valid_level_NONE,

5600: Jtf_Territory_Resource_Pvt.create_terrresource (
5601: p_api_version_number => l_Api_Version_Number,
5602: p_init_msg_list => l_Init_Msg_List,
5603: p_commit => l_Commit,
5604: p_validation_level => FND_API.g_valid_level_NONE,
5605: x_return_status => x_Return_Status,
5606: x_msg_count => x_Msg_Count,
5607: x_msg_data => x_msg_data,
5608: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 5620: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);

5616: IF G_Debug THEN
5617: write_log(2,' Resource created for NA territory # ' ||x_terr_id);
5618: END IF;
5619: ELSE
5620: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);
5621: IF G_Debug THEN
5622: write_log(2,x_msg_data);
5623: write_log(2, ' Failed in resource creation for NA territory # ' || x_terr_id);
5624: END IF;

Line 5628: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);

5624: END IF;
5625: END IF;
5626:
5627: ELSE
5628: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);
5629: IF G_Debug THEN
5630: write_log(2,SUBSTR(x_msg_data,1,254));
5631: WRITE_LOG(2,'ERROR: NA TERRITORY CREATION FAILED ' || 'FOR NAMED_ACCOUNT_ID# ' || naterr.named_account_id );
5632: END IF;

Line 5853: l_init_msg_list :=FND_API.G_TRUE;

5849: l_terr_values_tbl(k).qualifier_tbl_index := j;
5850:
5851: END LOOP;
5852:
5853: l_init_msg_list :=FND_API.G_TRUE;
5854:
5855: JTF_TERRITORY_PVT.create_territory (
5856: p_api_version_number => l_api_version_number,
5857: p_init_msg_list => l_init_msg_list,

Line 5859: p_validation_level => FND_API.g_valid_level_NONE,

5855: JTF_TERRITORY_PVT.create_territory (
5856: p_api_version_number => l_api_version_number,
5857: p_init_msg_list => l_init_msg_list,
5858: p_commit => l_commit,
5859: p_validation_level => FND_API.g_valid_level_NONE,
5860: x_return_status => x_return_status,
5861: x_msg_count => x_msg_count,
5862: x_msg_data => x_msg_data,
5863: p_terr_all_rec => l_terr_all_rec,

Line 6126: l_init_msg_list :=FND_API.G_TRUE;

6122: END IF;
6123:
6124: END LOOP;
6125:
6126: l_init_msg_list :=FND_API.G_TRUE;
6127:
6128: JTF_TERRITORY_PVT.create_territory (
6129: p_api_version_number => l_api_version_number,
6130: p_init_msg_list => l_init_msg_list,

Line 6132: p_validation_level => FND_API.g_valid_level_NONE,

6128: JTF_TERRITORY_PVT.create_territory (
6129: p_api_version_number => l_api_version_number,
6130: p_init_msg_list => l_init_msg_list,
6131: p_commit => l_commit,
6132: p_validation_level => FND_API.g_valid_level_NONE,
6133: x_return_status => x_return_status,
6134: x_msg_count => x_msg_count,
6135: x_msg_data => x_msg_data,
6136: p_terr_all_rec => l_terr_all_rec,

Line 6165: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

6161: write_log(2,' OVERLAY PI Territory Created = '||l_terr_all_rec.NAME);
6162: END IF;
6163:
6164: ELSE
6165: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
6166: IF G_Debug THEN
6167: write_log(2,x_msg_data);
6168: write_log(2, 'Failed in OVERLAY PI Territory Creation for TERR_GROUP_ACCOUNT_ID#'||
6169: overlayterr.terr_group_account_id);

Line 6262: l_init_msg_list :=FND_API.G_TRUE;

6258: l_TerrRsc_Access_Tbl(a).qualifier_tbl_index := i;
6259: END IF;
6260: END LOOP; /* rsc_acc in role_access */
6261:
6262: l_init_msg_list :=FND_API.G_TRUE;
6263:
6264: -- 07/08/03: JDOCHERT: bug#3023653
6265: Jtf_Territory_Resource_Pvt.create_terrresource (
6266: p_api_version_number => l_Api_Version_Number,

Line 6269: p_validation_level => FND_API.g_valid_level_NONE,

6265: Jtf_Territory_Resource_Pvt.create_terrresource (
6266: p_api_version_number => l_Api_Version_Number,
6267: p_init_msg_list => l_Init_Msg_List,
6268: p_commit => l_Commit,
6269: p_validation_level => FND_API.g_valid_level_NONE,
6270: x_return_status => x_Return_Status,
6271: x_msg_count => x_Msg_Count,
6272: x_msg_data => x_msg_data,
6273: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 6295: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

6291:
6292: END LOOP;
6293:
6294: ELSE
6295: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
6296: IF G_Debug THEN
6297: write_log(2,x_msg_data);
6298: write_log(2,'Failed in OVERLAY Territory Creation for Territory Group: ' || p_terr_group_id(x));
6299: END IF;

Line 6450: l_init_msg_list :=FND_API.G_TRUE;

6446: l_terr_values_tbl(k).qualifier_tbl_index := j;
6447:
6448: END LOOP;
6449:
6450: l_init_msg_list :=FND_API.G_TRUE;
6451:
6452: JTF_TERRITORY_PVT.create_territory (
6453: p_api_version_number => l_api_version_number,
6454: p_init_msg_list => l_init_msg_list,

Line 6456: p_validation_level => FND_API.g_valid_level_NONE,

6452: JTF_TERRITORY_PVT.create_territory (
6453: p_api_version_number => l_api_version_number,
6454: p_init_msg_list => l_init_msg_list,
6455: p_commit => l_commit,
6456: p_validation_level => FND_API.g_valid_level_NONE,
6457: x_return_status => x_return_status,
6458: x_msg_count => x_msg_count,
6459: x_msg_data => x_msg_data,
6460: p_terr_all_rec => l_terr_all_rec,

Line 6707: l_init_msg_list :=FND_API.G_TRUE;

6703: END IF;
6704:
6705: END LOOP;
6706:
6707: l_init_msg_list :=FND_API.G_TRUE;
6708:
6709: JTF_TERRITORY_PVT.create_territory (
6710: p_api_version_number => l_api_version_number,
6711: p_init_msg_list => l_init_msg_list,

Line 6713: p_validation_level => FND_API.g_valid_level_NONE,

6709: JTF_TERRITORY_PVT.create_territory (
6710: p_api_version_number => l_api_version_number,
6711: p_init_msg_list => l_init_msg_list,
6712: p_commit => l_commit,
6713: p_validation_level => FND_API.g_valid_level_NONE,
6714: x_return_status => x_return_status,
6715: x_msg_count => x_msg_count,
6716: x_msg_data => x_msg_data,
6717: p_terr_all_rec => l_terr_all_rec,

Line 6746: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

6742: write_log(2,' OVERLAY CNR territory created:' || l_terr_all_rec.NAME);
6743: END IF;
6744:
6745: ELSE
6746: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
6747: IF G_Debug THEN
6748: write_log(2,x_msg_data);
6749: write_log(2,'Failed in OVERLAY CNR territory treation for ' || 'TERR_GROUP_ACCOUNT_ID = ' ||
6750: overlayterr.terr_group_account_id );

Line 6844: l_init_msg_list :=FND_API.G_TRUE;

6840: l_TerrRsc_Access_Tbl(a).qualifier_tbl_index := i;
6841: END IF;
6842: END LOOP; /* rsc_acc in role_access */
6843:
6844: l_init_msg_list :=FND_API.G_TRUE;
6845:
6846: -- 07/08/03: JDOCHERT: bug#3023653
6847: Jtf_Territory_Resource_Pvt.create_terrresource (
6848: p_api_version_number => l_Api_Version_Number,

Line 6851: p_validation_level => FND_API.g_valid_level_NONE,

6847: Jtf_Territory_Resource_Pvt.create_terrresource (
6848: p_api_version_number => l_Api_Version_Number,
6849: p_init_msg_list => l_Init_Msg_List,
6850: p_commit => l_Commit,
6851: p_validation_level => FND_API.g_valid_level_NONE,
6852: x_return_status => x_Return_Status,
6853: x_msg_count => x_Msg_Count,
6854: x_msg_data => x_msg_data,
6855: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 6876: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

6872:
6873: END LOOP;
6874:
6875: ELSE
6876: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
6877: IF G_Debug THEN
6878: write_log(2,x_msg_data);
6879: write_log(2,'Failed in OVERLAY Territory Creation for Territory Group: ' || p_terr_group_id(x));
6880: END IF;

Line 6994: grp_role_id NUMBER:=FND_API.G_MISS_NUM

6990: )
6991: IS
6992:
6993: TYPE role_typ IS RECORD(
6994: grp_role_id NUMBER:=FND_API.G_MISS_NUM
6995: );
6996:
6997: TYPE grp_role_tbl_type IS TABLE OF role_typ
6998: INDEX BY BINARY_INTEGER;

Line 7688: l_init_msg_list := FND_API.G_TRUE;

7684: IF (na_access%ISOPEN) THEN
7685: CLOSE na_access;
7686: END IF;
7687:
7688: l_init_msg_list := FND_API.G_TRUE;
7689: /* CALL CREATE TERRITORY API */
7690: JTF_TERRITORY_PVT.create_territory (
7691: p_api_version_number => l_api_version_number,
7692: p_init_msg_list => l_init_msg_list,

Line 7694: p_validation_level => FND_API.g_valid_level_NONE,

7690: JTF_TERRITORY_PVT.create_territory (
7691: p_api_version_number => l_api_version_number,
7692: p_init_msg_list => l_init_msg_list,
7693: p_commit => l_commit,
7694: p_validation_level => FND_API.g_valid_level_NONE,
7695: x_return_status => x_return_status,
7696: x_msg_count => x_msg_count,
7697: x_msg_data => x_msg_data,
7698: p_terr_all_rec => l_terr_all_rec,

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

7726: ELSE
7727: IF G_Debug THEN
7728: WRITE_LOG(2,'ERROR: PLACEHOLDER TERRITORY CREATION FAILED ' ||
7729: 'FOR TERRITORY_GROUP_ID# ' ||p_terr_group_id(x));
7730: X_MSG_DATA := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
7731: WRITE_LOG(2,X_MSG_DATA);
7732: END IF;
7733: END IF;
7734:

Line 7899: l_init_msg_list := FND_API.G_TRUE;

7895: l_terr_values_tbl(k).qualifier_tbl_index := 1;
7896:
7897: END LOOP;
7898:
7899: l_init_msg_list := FND_API.G_TRUE;
7900:
7901: JTF_TERRITORY_PVT.create_territory (
7902: p_api_version_number => l_api_version_number,
7903: p_init_msg_list => l_init_msg_list,

Line 7905: p_validation_level => FND_API.g_valid_level_NONE,

7901: JTF_TERRITORY_PVT.create_territory (
7902: p_api_version_number => l_api_version_number,
7903: p_init_msg_list => l_init_msg_list,
7904: p_commit => l_commit,
7905: p_validation_level => FND_API.g_valid_level_NONE,
7906: x_return_status => x_return_status,
7907: x_msg_count => x_msg_count,
7908: x_msg_data => x_msg_data,
7909: p_terr_all_rec => l_terr_all_rec,

Line 7936: l_init_msg_list :=FND_API.G_TRUE;

7932: , TERR_GROUP_ID = p_terr_group_id(x)
7933: , CATCH_ALL_FLAG = 'Y'
7934: WHERE terr_id = x_terr_id;
7935:
7936: l_init_msg_list :=FND_API.G_TRUE;
7937:
7938: /* The resources for catch ALL territory will be created through a seperate
7939: procedure call in UI : JTF_TTY_GEN_TERR_PVT.create_catchall_terr_rsc.
7940:

Line 8021: l_init_msg_list := FND_API.G_TRUE;

8017:
8018: END IF;
8019: END LOOP;
8020:
8021: l_init_msg_list := FND_API.G_TRUE;
8022:
8023: Jtf_Territory_Resource_Pvt.create_terrresource (
8024: p_api_version_number => l_Api_Version_Number,
8025: p_init_msg_list => l_Init_Msg_List,

Line 8027: p_validation_level => FND_API.g_valid_level_NONE,

8023: Jtf_Territory_Resource_Pvt.create_terrresource (
8024: p_api_version_number => l_Api_Version_Number,
8025: p_init_msg_list => l_Init_Msg_List,
8026: p_commit => l_Commit,
8027: p_validation_level => FND_API.g_valid_level_NONE,
8028: x_return_status => x_Return_Status,
8029: x_msg_count => x_Msg_Count,
8030: x_msg_data => x_msg_data,
8031: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 8044: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

8040: END IF;
8041: ELSE
8042: IF G_Debug THEN
8043: write_log( 2,' FAILED IN RESOURCE CREATION FOR NAMED ACCOUNT CATCH ALL TERRITORY' || x_terr_id);
8044: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
8045: write_log(2, x_msg_data);
8046: END IF;
8047: END IF;
8048:

Line 8053: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

8049: */
8050:
8051: /* else of -if the catch all territory creation failed */
8052: ELSE
8053: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
8054: IF G_Debug THEN
8055: write_log(2,x_msg_data);
8056: WRITE_LOG(2,'ERROR: NA CATCH-ALL TERRITORY CREATION FAILED ' || 'FOR TERRITORY_GROUP_ID# '
8057: ||p_terr_group_id(x));

Line 8305: l_init_msg_list :=FND_API.G_TRUE;

8301: END IF;
8302:
8303: END LOOP; /* qval IN pqual */
8304:
8305: l_init_msg_list :=FND_API.G_TRUE;
8306:
8307: JTF_TERRITORY_PVT.create_territory (
8308: p_api_version_number => l_api_version_number,
8309: p_init_msg_list => l_init_msg_list,

Line 8311: p_validation_level => FND_API.g_valid_level_NONE,

8307: JTF_TERRITORY_PVT.create_territory (
8308: p_api_version_number => l_api_version_number,
8309: p_init_msg_list => l_init_msg_list,
8310: p_commit => l_commit,
8311: p_validation_level => FND_API.g_valid_level_NONE,
8312: x_return_status => x_return_status,
8313: x_msg_count => x_msg_count,
8314: x_msg_data => x_msg_data,
8315: p_terr_all_rec => l_terr_all_rec,

Line 8346: l_init_msg_list :=FND_API.G_TRUE;

8342: , NAMED_ACCOUNT_FLAG = 'Y'
8343: , TERR_GROUP_ACCOUNT_ID = naterr.terr_group_account_id
8344: WHERE terr_id = x_terr_id;
8345:
8346: l_init_msg_list :=FND_API.G_TRUE;
8347: i := 0;
8348: a := 0;
8349:
8350: FOR tran_type IN role_interest_nonpi(p_Terr_gROUP_ID(x)) LOOP

Line 8437: l_init_msg_list :=FND_API.G_TRUE;

8433: END LOOP; /* FOR rsc in resource_grp */
8434:
8435: END LOOP;/* FOR tran_type in role_interest_nonpi */
8436:
8437: l_init_msg_list :=FND_API.G_TRUE;
8438:
8439: -- 07/08/03: JDOCHERT: bug#3023653
8440: Jtf_Territory_Resource_Pvt.create_terrresource (
8441: p_api_version_number => l_Api_Version_Number,

Line 8444: p_validation_level => FND_API.g_valid_level_NONE,

8440: Jtf_Territory_Resource_Pvt.create_terrresource (
8441: p_api_version_number => l_Api_Version_Number,
8442: p_init_msg_list => l_Init_Msg_List,
8443: p_commit => l_Commit,
8444: p_validation_level => FND_API.g_valid_level_NONE,
8445: x_return_status => x_Return_Status,
8446: x_msg_count => x_Msg_Count,
8447: x_msg_data => x_msg_data,
8448: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 8460: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);

8456: write_log(2,' Resource created for NA territory # ' ||x_terr_id);
8457: END IF;
8458: ELSE
8459: IF G_Debug THEN
8460: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);
8461: write_log(2,x_msg_data);
8462: write_log(2, ' Failed in resource creation for NA territory # ' || x_terr_id);
8463: END IF;
8464: END IF;

Line 8468: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);

8464: END IF;
8465:
8466: ELSE
8467: IF G_Debug THEN
8468: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);
8469: write_log(2,SUBSTR(x_msg_data,1,254));
8470: WRITE_LOG(2,'ERROR: NA TERRITORY CREATION FAILED ' || 'FOR NAMED_ACCOUNT_ID# ' || naterr.named_account_id );
8471: END IF;
8472: END IF; /* END: Successful Territory creation? */

Line 8684: l_init_msg_list :=FND_API.G_TRUE;

8680: l_terr_values_tbl(k).qualifier_tbl_index := j;
8681:
8682: END LOOP; /* qval IN pqual */
8683:
8684: l_init_msg_list :=FND_API.G_TRUE;
8685:
8686: JTF_TERRITORY_PVT.create_territory (
8687: p_api_version_number => l_api_version_number,
8688: p_init_msg_list => l_init_msg_list,

Line 8690: p_validation_level => FND_API.g_valid_level_NONE,

8686: JTF_TERRITORY_PVT.create_territory (
8687: p_api_version_number => l_api_version_number,
8688: p_init_msg_list => l_init_msg_list,
8689: p_commit => l_commit,
8690: p_validation_level => FND_API.g_valid_level_NONE,
8691: x_return_status => x_return_status,
8692: x_msg_count => x_msg_count,
8693: x_msg_data => x_msg_data,
8694: p_terr_all_rec => l_terr_all_rec,

Line 8724: l_init_msg_list :=FND_API.G_TRUE;

8720: , NAMED_ACCOUNT_FLAG = 'Y'
8721: , TERR_GROUP_ACCOUNT_ID = naterr.terr_group_account_id
8722: WHERE terr_id = x_terr_id;
8723:
8724: l_init_msg_list :=FND_API.G_TRUE;
8725: i := 0;
8726: a := 0;
8727:
8728: FOR tran_type IN role_interest_nonpi(p_Terr_gROUP_ID(x)) LOOP

Line 8814: l_init_msg_list :=FND_API.G_TRUE;

8810: END LOOP; /* FOR rsc in resource_grp */
8811:
8812: END LOOP;/* FOR tran_type in role_interest_nonpi */
8813:
8814: l_init_msg_list :=FND_API.G_TRUE;
8815:
8816: Jtf_Territory_Resource_Pvt.create_terrresource (
8817: p_api_version_number => l_Api_Version_Number,
8818: p_init_msg_list => l_Init_Msg_List,

Line 8820: p_validation_level => FND_API.g_valid_level_NONE,

8816: Jtf_Territory_Resource_Pvt.create_terrresource (
8817: p_api_version_number => l_Api_Version_Number,
8818: p_init_msg_list => l_Init_Msg_List,
8819: p_commit => l_Commit,
8820: p_validation_level => FND_API.g_valid_level_NONE,
8821: x_return_status => x_Return_Status,
8822: x_msg_count => x_Msg_Count,
8823: x_msg_data => x_msg_data,
8824: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 8836: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);

8832: write_log(2,' Resource created for NA territory # ' ||x_terr_id);
8833: END IF;
8834: ELSE
8835: IF G_Debug THEN
8836: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);
8837: write_log(2,x_msg_data);
8838: write_log(2, ' Failed in resource creation for NA territory # ' || x_terr_id);
8839: END IF;
8840: END IF;

Line 8844: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);

8840: END IF;
8841:
8842: ELSE
8843: IF G_Debug THEN
8844: x_msg_data := SUBSTR(FND_MSG_PUB.get(1, FND_API.g_false),1,254);
8845: write_log(2,SUBSTR(x_msg_data,1,254));
8846: WRITE_LOG(2,'ERROR: NA TERRITORY CREATION FAILED ' || 'FOR NAMED_ACCOUNT_ID# ' || naterr.named_account_id );
8847: END IF;
8848: END IF; /* END: Successful Territory creation? */

Line 9056: l_init_msg_list :=FND_API.G_TRUE;

9052:
9053: END LOOP;/* csr_qual_val IN csr_get_qual_val */
9054: END LOOP; /* csr_qual IN csr_get_qual */
9055:
9056: l_init_msg_list :=FND_API.G_TRUE;
9057:
9058: JTF_TERRITORY_PVT.create_territory (
9059: p_api_version_number => l_api_version_number,
9060: p_init_msg_list => l_init_msg_list,

Line 9062: p_validation_level => FND_API.g_valid_level_NONE,

9058: JTF_TERRITORY_PVT.create_territory (
9059: p_api_version_number => l_api_version_number,
9060: p_init_msg_list => l_init_msg_list,
9061: p_commit => l_commit,
9062: p_validation_level => FND_API.g_valid_level_NONE,
9063: x_return_status => x_return_status,
9064: x_msg_count => x_msg_count,
9065: x_msg_data => x_msg_data,
9066: p_terr_all_rec => l_terr_all_rec,

Line 9255: l_init_msg_list :=FND_API.G_TRUE;

9251: l_terr_values_tbl(k).qualifier_tbl_index := j;
9252:
9253: END LOOP;
9254:
9255: l_init_msg_list :=FND_API.G_TRUE;
9256:
9257: JTF_TERRITORY_PVT.create_territory (
9258: p_api_version_number => l_api_version_number,
9259: p_init_msg_list => l_init_msg_list,

Line 9261: p_validation_level => FND_API.g_valid_level_NONE,

9257: JTF_TERRITORY_PVT.create_territory (
9258: p_api_version_number => l_api_version_number,
9259: p_init_msg_list => l_init_msg_list,
9260: p_commit => l_commit,
9261: p_validation_level => FND_API.g_valid_level_NONE,
9262: x_return_status => x_return_status,
9263: x_msg_count => x_msg_count,
9264: x_msg_data => x_msg_data,
9265: p_terr_all_rec => l_terr_all_rec,

Line 9524: l_init_msg_list :=FND_API.G_TRUE;

9520: END IF;
9521:
9522: END LOOP;
9523:
9524: l_init_msg_list :=FND_API.G_TRUE;
9525:
9526: JTF_TERRITORY_PVT.create_territory (
9527: p_api_version_number => l_api_version_number,
9528: p_init_msg_list => l_init_msg_list,

Line 9530: p_validation_level => FND_API.g_valid_level_NONE,

9526: JTF_TERRITORY_PVT.create_territory (
9527: p_api_version_number => l_api_version_number,
9528: p_init_msg_list => l_init_msg_list,
9529: p_commit => l_commit,
9530: p_validation_level => FND_API.g_valid_level_NONE,
9531: x_return_status => x_return_status,
9532: x_msg_count => x_msg_count,
9533: x_msg_data => x_msg_data,
9534: p_terr_all_rec => l_terr_all_rec,

Line 9565: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

9561: END IF;
9562:
9563: ELSE
9564: IF G_Debug THEN
9565: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
9566: write_log(2,x_msg_data);
9567: write_log(2, 'Failed in OVERLAY PI Territory Creation for TERR_GROUP_ACCOUNT_ID#'||
9568: overlayterr.terr_group_account_id);
9569: END IF;

Line 9661: l_init_msg_list :=FND_API.G_TRUE;

9657: l_TerrRsc_Access_Tbl(a).qualifier_tbl_index := i;
9658: END IF;
9659: END LOOP; /* rsc_acc in role_access */
9660:
9661: l_init_msg_list :=FND_API.G_TRUE;
9662:
9663: -- 07/08/03: JDOCHERT: bug#3023653
9664: Jtf_Territory_Resource_Pvt.create_terrresource (
9665: p_api_version_number => l_Api_Version_Number,

Line 9668: p_validation_level => FND_API.g_valid_level_NONE,

9664: Jtf_Territory_Resource_Pvt.create_terrresource (
9665: p_api_version_number => l_Api_Version_Number,
9666: p_init_msg_list => l_Init_Msg_List,
9667: p_commit => l_Commit,
9668: p_validation_level => FND_API.g_valid_level_NONE,
9669: x_return_status => x_Return_Status,
9670: x_msg_count => x_Msg_Count,
9671: x_msg_data => x_msg_data,
9672: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 9695: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

9691: END LOOP;
9692:
9693: ELSE
9694: IF G_Debug THEN
9695: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
9696: write_log(2,x_msg_data);
9697: write_log(2,'Failed in OVERLAY Territory Creation for Territory Group: ' ||
9698: p_terr_group_id(x) || ' : ' ||
9699: p_terr_group_name(x) );

Line 9851: l_init_msg_list :=FND_API.G_TRUE;

9847: l_terr_values_tbl(k).qualifier_tbl_index := j;
9848:
9849: END LOOP;
9850:
9851: l_init_msg_list :=FND_API.G_TRUE;
9852:
9853: JTF_TERRITORY_PVT.create_territory (
9854: p_api_version_number => l_api_version_number,
9855: p_init_msg_list => l_init_msg_list,

Line 9857: p_validation_level => FND_API.g_valid_level_NONE,

9853: JTF_TERRITORY_PVT.create_territory (
9854: p_api_version_number => l_api_version_number,
9855: p_init_msg_list => l_init_msg_list,
9856: p_commit => l_commit,
9857: p_validation_level => FND_API.g_valid_level_NONE,
9858: x_return_status => x_return_status,
9859: x_msg_count => x_msg_count,
9860: x_msg_data => x_msg_data,
9861: p_terr_all_rec => l_terr_all_rec,

Line 10108: l_init_msg_list :=FND_API.G_TRUE;

10104: END IF;
10105:
10106: END LOOP;
10107:
10108: l_init_msg_list :=FND_API.G_TRUE;
10109:
10110: JTF_TERRITORY_PVT.create_territory (
10111: p_api_version_number => l_api_version_number,
10112: p_init_msg_list => l_init_msg_list,

Line 10114: p_validation_level => FND_API.g_valid_level_NONE,

10110: JTF_TERRITORY_PVT.create_territory (
10111: p_api_version_number => l_api_version_number,
10112: p_init_msg_list => l_init_msg_list,
10113: p_commit => l_commit,
10114: p_validation_level => FND_API.g_valid_level_NONE,
10115: x_return_status => x_return_status,
10116: x_msg_count => x_msg_count,
10117: x_msg_data => x_msg_data,
10118: p_terr_all_rec => l_terr_all_rec,

Line 10147: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

10143: write_log(2,' OVERLAY CNR territory created:' || l_terr_all_rec.NAME);
10144: END IF;
10145:
10146: ELSE
10147: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
10148: IF G_Debug THEN
10149: write_log(2,x_msg_data);
10150: write_log(2,'Failed in OVERLAY CNR territory treation for ' || 'TERR_GROUP_ACCOUNT_ID = ' ||
10151: overlayterr.terr_group_account_id );

Line 10245: l_init_msg_list :=FND_API.G_TRUE;

10241: l_TerrRsc_Access_Tbl(a).qualifier_tbl_index := i;
10242: END IF;
10243: END LOOP; /* rsc_acc in role_access */
10244:
10245: l_init_msg_list :=FND_API.G_TRUE;
10246:
10247: -- 07/08/03: JDOCHERT: bug#3023653
10248: Jtf_Territory_Resource_Pvt.create_terrresource (
10249: p_api_version_number => l_Api_Version_Number,

Line 10252: p_validation_level => FND_API.g_valid_level_NONE,

10248: Jtf_Territory_Resource_Pvt.create_terrresource (
10249: p_api_version_number => l_Api_Version_Number,
10250: p_init_msg_list => l_Init_Msg_List,
10251: p_commit => l_Commit,
10252: p_validation_level => FND_API.g_valid_level_NONE,
10253: x_return_status => x_Return_Status,
10254: x_msg_count => x_Msg_Count,
10255: x_msg_data => x_msg_data,
10256: p_terrrsc_tbl => l_TerrRsc_tbl,

Line 10278: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);

10274: END LOOP;
10275:
10276: ELSE
10277: IF G_Debug THEN
10278: x_msg_data := FND_MSG_PUB.get(1, FND_API.g_false);
10279: write_log(2,x_msg_data);
10280: write_log(2,'Failed in OVERLAY Territory Creation for Territory Group: ' || p_terr_group_id(x) || ' : ' ||
10281: p_terr_group_name(x) );
10282: END IF;

Line 12839: grp_role_id NUMBER:=FND_API.G_MISS_NUM

12835: p_terr_group_id IN NUMBER)
12836: IS
12837:
12838: TYPE role_typ IS RECORD(
12839: grp_role_id NUMBER:=FND_API.G_MISS_NUM
12840: );
12841:
12842: TYPE grp_role_tbl_type IS TABLE OF role_typ
12843: INDEX BY BINARY_INTEGER;

Line 12943: l_init_msg_list :=FND_API.G_TRUE;

12939: -- Delete the Territory Resource records
12940: DELETE FROM JTF_TERR_RSC_ALL WHERE TERR_ID IN
12941: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id );
12942:
12943: l_init_msg_list :=FND_API.G_TRUE;
12944: i := 0;
12945: a := 0;
12946: l_user_id := fnd_global.user_id;
12947: l_login_id := fnd_global.login_id;

Line 13053: l_init_msg_list :=FND_API.G_TRUE;

13049: END LOOP; /* FOR rsc in resource_grp */
13050:
13051: END LOOP;/* FOR role_type in role_interest_nonpi */
13052:
13053: l_init_msg_list :=FND_API.G_TRUE;
13054:
13055: Jtf_Territory_Resource_Pvt.create_terrresource (
13056: p_api_version_number => l_Api_Version_Number,
13057: p_init_msg_list => l_Init_Msg_List,

Line 13059: p_validation_level => FND_API.g_valid_level_NONE,

13055: Jtf_Territory_Resource_Pvt.create_terrresource (
13056: p_api_version_number => l_Api_Version_Number,
13057: p_init_msg_list => l_Init_Msg_List,
13058: p_commit => l_Commit,
13059: p_validation_level => FND_API.g_valid_level_NONE,
13060: x_return_status => x_Return_Status,
13061: x_msg_count => x_Msg_Count,
13062: x_msg_data => x_msg_data,
13063: p_terrrsc_tbl => l_TerrRsc_tbl,