DBA Data[Home] [Help]

APPS.JTF_TTY_GEN_TERR_PVT dependencies on FND_MSG_PUB

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