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_TERRITORY_GET_PUB dependencies on FND_MESSAGE

Line 52: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

48: /* Debug Message */
49:
50: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
51: THEN
52: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
53: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
54: FND_MSG_PUB.Add;
55: END IF;
56:

Line 53: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

49:
50: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
51: THEN
52: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
53: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
54: FND_MSG_PUB.Add;
55: END IF;
56:
57:

Line 85: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

81: /* Debug Message */
82:
83: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
84: THEN
85: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
86: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
87: FND_MSG_PUB.Add;
88: END IF;
89:

Line 86: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

82:
83: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
84: THEN
85: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
86: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
87: FND_MSG_PUB.Add;
88: END IF;
89:
90:

Line 104: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

100:
101: /* Debug Message */
102: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
103: THEN
104: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
105: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
106: FND_MSG_PUB.Add;
107: END IF;
108:

Line 105: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

101: /* Debug Message */
102: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
103: THEN
104: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
105: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
106: FND_MSG_PUB.Add;
107: END IF;
108:
109: /* define all columns */

Line 123: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

119:
120: /* Debug Message */
121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
122: THEN
123: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
124: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
125: FND_MSG_PUB.Add;
126: END IF;
127:

Line 124: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

120: /* Debug Message */
121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
122: THEN
123: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
124: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
125: FND_MSG_PUB.Add;
126: END IF;
127:
128: END define_dsql_columns;

Line 141: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

137:
138: /* Debug Message */
139: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
140: THEN
141: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
142: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
143: FND_MSG_PUB.Add;
144: END IF;
145:

Line 142: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

138: /* Debug Message */
139: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
140: THEN
141: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
142: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
143: FND_MSG_PUB.Add;
144: END IF;
145:
146: /* get all columns */

Line 161: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

157:
158: /* Debug Message */
159: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
160: THEN
161: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
162: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
163: FND_MSG_PUB.Add;
164: END IF;
165:

Line 162: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

158: /* Debug Message */
159: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
160: THEN
161: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
162: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
163: FND_MSG_PUB.Add;
164: END IF;
165:
166: END get_dsql_column_values;

Line 197: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

193:
194: /* Debug Message */
195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
196: THEN
197: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
198: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
199: FND_MSG_PUB.Add;
200: END IF;
201:

Line 198: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

194: /* Debug Message */
195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
196: THEN
197: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
198: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
199: FND_MSG_PUB.Add;
200: END IF;
201:
202: --dbms_output.put_line('Value of p_TERR_rec.TERR_ID = '|| p_TERR_rec.terr_id);

Line 505: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

501:
502: /* Debug Message */
503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
504: THEN
505: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
506: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
507: FND_MSG_PUB.Add;
508: END IF;
509:

Line 506: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

502: /* Debug Message */
503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
504: THEN
505: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
506: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
507: FND_MSG_PUB.Add;
508: END IF;
509:
510: END gen_where_clause;

Line 524: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

520:
521: /* Debug Message */
522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
523: THEN
524: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
525: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
526: FND_MSG_PUB.Add;
527: END IF;
528:

Line 525: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

521: /* Debug Message */
522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
523: THEN
524: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
525: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
526: FND_MSG_PUB.Add;
527: END IF;
528:
529:

Line 667: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

663:
664: /* Debug Message */
665: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
666: THEN
667: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
668: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
669: FND_MSG_PUB.Add;
670: END IF;
671:

Line 668: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

664: /* Debug Message */
665: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
666: THEN
667: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
668: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
669: FND_MSG_PUB.Add;
670: END IF;
671:
672: END gen_bind;

Line 703: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

699:
700: /* Debug Message */
701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
702: THEN
703: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
704: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
705: FND_MSG_PUB.Add;
706: END IF;
707:

Line 704: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

700: /* Debug Message */
701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
702: THEN
703: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
704: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
705: FND_MSG_PUB.Add;
706: END IF;
707:
708: IF ( (p_TERR_USGS_rec.TERR_USG_ID IS NOT NULL) AND

Line 769: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

765:
766: /* Debug Message */
767: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
768: THEN
769: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
770: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
771: FND_MSG_PUB.Add;
772: END IF;
773:

Line 770: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

766: /* Debug Message */
767: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
768: THEN
769: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
770: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
771: FND_MSG_PUB.Add;
772: END IF;
773:
774: END gen_where_clause;

Line 789: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

785:
786: /* Debug Message */
787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
788: THEN
789: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
790: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
791: FND_MSG_PUB.Add;
792: END IF;
793:

Line 790: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

786: /* Debug Message */
787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
788: THEN
789: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
790: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
791: FND_MSG_PUB.Add;
792: END IF;
793:
794: IF ( (p_TERR_USGS_rec.TERR_USG_ID IS NOT NULL) AND

Line 829: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

825:
826: /* Debug Message */
827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
828: THEN
829: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
830: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
831: FND_MSG_PUB.Add;
832: END IF;
833:

Line 830: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

826: /* Debug Message */
827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
828: THEN
829: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
830: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
831: FND_MSG_PUB.Add;
832: END IF;
833:
834: END gen_bind;

Line 866: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

862:
863: /* Debug Message */
864: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
865: THEN
866: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
867: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
868: FND_MSG_PUB.Add;
869: END IF;
870:

Line 867: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

863: /* Debug Message */
864: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
865: THEN
866: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
867: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
868: FND_MSG_PUB.Add;
869: END IF;
870:
871: IF ( (p_TERR_TYPES_rec.TERR_TYPE_ID IS NOT NULL) AND

Line 1007: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

1003:
1004: /* Debug Message */
1005: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1006: THEN
1007: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1008: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1009: FND_MSG_PUB.Add;
1010: END IF;
1011:

Line 1008: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1004: /* Debug Message */
1005: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1006: THEN
1007: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1008: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1009: FND_MSG_PUB.Add;
1010: END IF;
1011:
1012: END gen_where_clause;

Line 1027: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

1023:
1024: /* Debug Message */
1025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1026: THEN
1027: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1028: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1029: FND_MSG_PUB.Add;
1030: END IF;
1031:

Line 1028: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1024: /* Debug Message */
1025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1026: THEN
1027: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1028: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1029: FND_MSG_PUB.Add;
1030: END IF;
1031:
1032: IF ( (p_TERR_TYPES_rec.TERR_TYPE_ID IS NOT NULL) AND

Line 1077: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

1073:
1074: /* Debug Message */
1075: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1076: THEN
1077: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1078: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1079: FND_MSG_PUB.Add;
1080: END IF;
1081:

Line 1078: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1074: /* Debug Message */
1075: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1076: THEN
1077: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1078: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1079: FND_MSG_PUB.Add;
1080: END IF;
1081:
1082: END gen_bind;

Line 1114: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

1110:
1111: /* Debug Message */
1112: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1113: THEN
1114: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1115: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1116: FND_MSG_PUB.Add;
1117: END IF;
1118:

Line 1115: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1111: /* Debug Message */
1112: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1113: THEN
1114: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1115: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1116: FND_MSG_PUB.Add;
1117: END IF;
1118:
1119: IF ( (p_TERR_QTYPE_USGS_REC.TERR_QTYPE_USG_ID IS NOT NULL) AND

Line 1225: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

1221:
1222: /* Debug Message */
1223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1224: THEN
1225: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1226: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1227: FND_MSG_PUB.Add;
1228: END IF;
1229:

Line 1226: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1222: /* Debug Message */
1223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1224: THEN
1225: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1226: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1227: FND_MSG_PUB.Add;
1228: END IF;
1229:
1230: END gen_where_clause;

Line 1246: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

1242:
1243: /* Debug Message */
1244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1245: THEN
1246: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1247: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1248: FND_MSG_PUB.Add;
1249: END IF;
1250:

Line 1247: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1243: /* Debug Message */
1244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1245: THEN
1246: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1247: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1248: FND_MSG_PUB.Add;
1249: END IF;
1250:
1251:

Line 1312: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

1308:
1309: /* Debug Message */
1310: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1311: THEN
1312: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1313: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1314: FND_MSG_PUB.Add;
1315: END IF;
1316:

Line 1313: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1309: /* Debug Message */
1310: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1311: THEN
1312: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1313: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1314: FND_MSG_PUB.Add;
1315: END IF;
1316:
1317: END gen_bind;

Line 1348: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

1344:
1345: /* Debug Message */
1346: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1347: THEN
1348: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1349: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1350: FND_MSG_PUB.Add;
1351: END IF;
1352:

Line 1349: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1345: /* Debug Message */
1346: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1347: THEN
1348: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1349: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1350: FND_MSG_PUB.Add;
1351: END IF;
1352:
1353:

Line 1599: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

1595:
1596: /* Debug Message */
1597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1598: THEN
1599: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1600: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1601: FND_MSG_PUB.Add;
1602: END IF;
1603:

Line 1600: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1596: /* Debug Message */
1597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1598: THEN
1599: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1600: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1601: FND_MSG_PUB.Add;
1602: END IF;
1603:
1604:

Line 1620: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

1616:
1617: /* Debug Message */
1618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1619: THEN
1620: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1621: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1622: FND_MSG_PUB.Add;
1623: END IF;
1624:

Line 1621: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1617: /* Debug Message */
1618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1619: THEN
1620: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1621: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1622: FND_MSG_PUB.Add;
1623: END IF;
1624:
1625: IF ( (p_TERR_QUAL_rec.TERR_QUAL_ID IS NOT NULL) AND

Line 1725: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

1721:
1722: /* Debug Message */
1723: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1724: THEN
1725: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1726: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1727: FND_MSG_PUB.Add;
1728: END IF;
1729:

Line 1726: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1722: /* Debug Message */
1723: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1724: THEN
1725: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1726: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1727: FND_MSG_PUB.Add;
1728: END IF;
1729:
1730: END gen_bind;

Line 1763: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

1759:
1760: /* Debug Message */
1761: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1762: THEN
1763: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1764: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1765: FND_MSG_PUB.Add;
1766: END IF;
1767:

Line 1764: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1760: /* Debug Message */
1761: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1762: THEN
1763: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1764: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1765: FND_MSG_PUB.Add;
1766: END IF;
1767:
1768: IF ( (p_TERR_VALUES_rec.TERR_VALUE_ID IS NOT NULL) AND

Line 1971: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

1967:
1968: /* Debug Message */
1969: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1970: THEN
1971: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1972: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1973: FND_MSG_PUB.Add;
1974: END IF;
1975:

Line 1972: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1968: /* Debug Message */
1969: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1970: THEN
1971: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
1972: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1973: FND_MSG_PUB.Add;
1974: END IF;
1975:
1976: END gen_where_clause;

Line 1993: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

1989:
1990: /* Debug Message */
1991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1992: THEN
1993: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1994: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1995: FND_MSG_PUB.Add;
1996: END IF;
1997:

Line 1994: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

1990: /* Debug Message */
1991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1992: THEN
1993: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
1994: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
1995: FND_MSG_PUB.Add;
1996: END IF;
1997:
1998: IF ( (p_TERR_VALUES_rec.TERR_VALUE_ID IS NOT NULL) AND

Line 2109: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

2105:
2106: /* Debug Message */
2107: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2108: THEN
2109: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
2110: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2111: FND_MSG_PUB.Add;
2112: END IF;
2113:

Line 2110: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

2106: /* Debug Message */
2107: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2108: THEN
2109: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
2110: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2111: FND_MSG_PUB.Add;
2112: END IF;
2113:
2114: END gen_bind;

Line 2147: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

2143:
2144: /* Debug Message */
2145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2146: THEN
2147: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
2148: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2149: FND_MSG_PUB.Add;
2150: END IF;
2151:

Line 2148: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

2144: /* Debug Message */
2145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2146: THEN
2147: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
2148: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2149: FND_MSG_PUB.Add;
2150: END IF;
2151:
2152: IF ( (p_TERR_RSC_rec.TERR_RSC_ID IS NOT NULL) AND

Line 2322: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

2318:
2319: /* Debug Message */
2320: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2321: THEN
2322: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
2323: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2324: FND_MSG_PUB.Add;
2325: END IF;
2326:

Line 2323: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

2319: /* Debug Message */
2320: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2321: THEN
2322: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
2323: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2324: FND_MSG_PUB.Add;
2325: END IF;
2326:
2327:

Line 2343: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

2339:
2340: /* Debug Message */
2341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2342: THEN
2343: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
2344: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2345: FND_MSG_PUB.Add;
2346: END IF;
2347:

Line 2344: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

2340: /* Debug Message */
2341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2342: THEN
2343: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
2344: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2345: FND_MSG_PUB.Add;
2346: END IF;
2347:
2348: IF ( (p_TERR_RSC_rec.TERR_RSC_ID IS NOT NULL) AND

Line 2423: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

2419:
2420: /* Debug Message */
2421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2422: THEN
2423: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
2424: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2425: FND_MSG_PUB.Add;
2426: END IF;
2427:

Line 2424: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

2420: /* Debug Message */
2421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2422: THEN
2423: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
2424: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2425: FND_MSG_PUB.Add;
2426: END IF;
2427:
2428: END gen_bind;

Line 2455: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

2451:
2452: /* Debug Message */
2453: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2454: THEN
2455: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
2456: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2457: FND_MSG_PUB.Add;
2458: END IF;
2459:

Line 2456: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

2452: /* Debug Message */
2453: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2454: THEN
2455: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
2456: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2457: FND_MSG_PUB.Add;
2458: END IF;
2459:
2460: -- Hint: Developer should add more statements according to sort_rec_type

Line 2468: FND_MESSAGE.Set_Name('JTF', 'Invoke Translate_OrderBy');

2464:
2465: /* Debug Message */
2466: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2467: THEN
2468: FND_MESSAGE.Set_Name('JTF', 'Invoke Translate_OrderBy');
2469: FND_MSG_PUB.Add;
2470: END IF;
2471:
2472:

Line 2492: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

2488:
2489: /* Debug Message */
2490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2491: THEN
2492: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
2493: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2494: FND_MSG_PUB.Add;
2495: END IF;
2496:

Line 2493: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);

2489: /* Debug Message */
2490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2491: THEN
2492: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
2493: FND_MESSAGE.Set_Token('PROC_NAME', l_proc_name);
2494: FND_MSG_PUB.Add;
2495: END IF;
2496:
2497: END gen_order_by_clause;

Line 2633: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

2629:
2630: /* Debug Message */
2631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2632: THEN
2633: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
2634: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
2635: FND_MSG_PUB.Add;
2636: END IF;
2637:

Line 2634: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);

2630: /* Debug Message */
2631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2632: THEN
2633: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
2634: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
2635: FND_MSG_PUB.Add;
2636: END IF;
2637:
2638: /**********************************************************************************************

Line 2658: FND_MESSAGE.Set_Name('JTF', 'Open Cursor for Dynamic SQL');

2654:
2655: /* Debug Message */
2656: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2657: THEN
2658: FND_MESSAGE.Set_Name('JTF', 'Open Cursor for Dynamic SQL');
2659: FND_MSG_PUB.Add;
2660: END IF;
2661:
2662: /******************************/

Line 2954: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

2950:
2951: /* Debug Message */
2952: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2953: THEN
2954: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
2955: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
2956: FND_MSG_PUB.Add;
2957: END IF;
2958:

Line 2955: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);

2951: /* Debug Message */
2952: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2953: THEN
2954: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
2955: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
2956: FND_MSG_PUB.Add;
2957: END IF;
2958:
2959: /* Standard call to get message count and if count is 1, get message info. */

Line 3369: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

3365:
3366: /* Debug Message */
3367: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
3368: THEN
3369: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
3370: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
3371: FND_MSG_PUB.Add;
3372: END IF;
3373:

Line 3370: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);

3366: /* Debug Message */
3367: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
3368: THEN
3369: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
3370: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
3371: FND_MSG_PUB.Add;
3372: END IF;
3373:
3374:

Line 3446: FND_MESSAGE.Set_Name ('JTF', G_PKG_NAME || ': Territory record not found');

3442: l_return_status := FND_API.G_RET_STS_ERROR;
3443:
3444: /* Debug message */
3445: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3446: FND_MESSAGE.Set_Name ('JTF', G_PKG_NAME || ': Territory record not found');
3447: FND_MSG_PUB.ADD;
3448: END IF;
3449: END IF;
3450:

Line 3501: FND_MESSAGE.Set_Name ('JTF', G_PKG_NAME || ': Terr Type record not found');

3497: IF get_terr_type%NOTFOUND THEN
3498:
3499: /* Debug message */
3500: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3501: FND_MESSAGE.Set_Name ('JTF', G_PKG_NAME || ': Terr Type record not found');
3502: FND_MSG_PUB.ADD;
3503: END IF;
3504: END IF;
3505:

Line 3797: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

3793:
3794: /* Debug Message */
3795: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
3796: THEN
3797: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
3798: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
3799: FND_MSG_PUB.Add;
3800: END IF;
3801:

Line 3798: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);

3794: /* Debug Message */
3795: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
3796: THEN
3797: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
3798: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
3799: FND_MSG_PUB.Add;
3800: END IF;
3801:
3802: /* Standard call to get message count and if count is 1, get message info. */

Line 3931: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

3927:
3928: /* Debug Message */
3929: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
3930: THEN
3931: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
3932: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
3933: FND_MSG_PUB.Add;
3934: END IF;
3935:

Line 3932: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);

3928: /* Debug Message */
3929: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
3930: THEN
3931: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
3932: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
3933: FND_MSG_PUB.Add;
3934: END IF;
3935:
3936:

Line 3952: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_ESC_TERR_NOT_FOUND');

3948: l_return_status := FND_API.G_RET_STS_ERROR;
3949:
3950: -- Debug message
3951: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3952: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_ESC_TERR_NOT_FOUND');
3953: FND_MSG_PUB.ADD;
3954: END IF;
3955:
3956: ELSE

Line 3981: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

3977:
3978: /* Debug Message */
3979: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
3980: THEN
3981: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
3982: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
3983: FND_MSG_PUB.Add;
3984: END IF;
3985:

Line 3982: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);

3978: /* Debug Message */
3979: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
3980: THEN
3981: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
3982: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
3983: FND_MSG_PUB.Add;
3984: END IF;
3985:
3986: /* Standard call to get message count and if count is 1, get message info. */

Line 4109: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

4105:
4106: /* Debug Message */
4107: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4108: THEN
4109: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
4110: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
4111: FND_MSG_PUB.Add;
4112: END IF;
4113:

Line 4110: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);

4106: /* Debug Message */
4107: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4108: THEN
4109: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
4110: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
4111: FND_MSG_PUB.Add;
4112: END IF;
4113:
4114: /**********************************************************************************************

Line 4129: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_PARENT_NOT_FOUND');

4125: l_return_status := FND_API.G_RET_STS_ERROR;
4126:
4127: -- Debug message
4128: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4129: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_PARENT_NOT_FOUND');
4130: FND_MSG_PUB.ADD;
4131: END IF;
4132:
4133: ELSE

Line 4158: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

4154:
4155: /* Debug Message */
4156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4157: THEN
4158: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
4159: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
4160: FND_MSG_PUB.Add;
4161: END IF;
4162:

Line 4159: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);

4155: /* Debug Message */
4156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4157: THEN
4158: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
4159: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
4160: FND_MSG_PUB.Add;
4161: END IF;
4162:
4163: /* Standard call to get message count and if count is 1, get message info. */

Line 4304: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');

4300:
4301: /* Debug Message */
4302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4303: THEN
4304: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
4305: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
4306: FND_MSG_PUB.Add;
4307: END IF;
4308: --

Line 4305: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);

4301: /* Debug Message */
4302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4303: THEN
4304: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
4305: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
4306: FND_MSG_PUB.Add;
4307: END IF;
4308: --
4309: -- API body

Line 4336: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');

4332: --
4333: /* Debug Message */
4334: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4335: THEN
4336: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
4337: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
4338: FND_MSG_PUB.Add;
4339: END IF;
4340:

Line 4337: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);

4333: /* Debug Message */
4334: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4335: THEN
4336: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
4337: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
4338: FND_MSG_PUB.Add;
4339: END IF;
4340:
4341: -- Standard call to get message count and if count is 1, get message info.