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_MSG_PUB

Line 50: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

46: BEGIN
47:
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;

Line 54: FND_MSG_PUB.Add;

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:
58: /* build initial part of select clause */

Line 83: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

79: ' AND JTUA.SOURCE_ID = JSE.SOURCE_ID ';
80:
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;

Line 87: FND_MSG_PUB.Add;

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:
91: END gen_init_sql;

Line 102: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

98:
99: BEGIN
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;

Line 106: FND_MSG_PUB.Add;

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 */
110: dbms_sql.define_column(p_dsql_csr, 1, p_terr_header_rec.TERR_ID);

Line 121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

117: dbms_sql.define_column(p_dsql_csr, 8, p_terr_header_rec.PARENT_TERR_NAME, 2000);
118: dbms_sql.define_column(p_dsql_csr, 9, p_terr_header_rec.TERR_TYPE_NAME, 60);
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;

Line 125: FND_MSG_PUB.Add;

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

Line 139: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

135:
136: BEGIN
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;

Line 143: FND_MSG_PUB.Add;

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 */
147: dbms_sql.column_value(p_dsql_csr, 1, x_terr_header_rec.TERR_ID);

Line 159: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

155: dbms_sql.column_value(p_dsql_csr, 9, x_terr_header_rec.TERR_TYPE_NAME);
156:
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;

Line 163: FND_MSG_PUB.Add;

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

Line 195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

191: BEGIN
192:
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;

Line 199: FND_MSG_PUB.Add;

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);
203:

Line 503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

499:
500: x_where_clause := x_where_clause || l_where_clause;
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;

Line 507: FND_MSG_PUB.Add;

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

Line 522: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

518: l_proc_name VARCHAR2(30) := 'Gen_Bind: Terr_Rec_Type';
519: BEGIN
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;

Line 526: FND_MSG_PUB.Add;

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:
530: /* Hint: more search criteria can be added here to

Line 665: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

661:
662: END IF;
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;

Line 669: FND_MSG_PUB.Add;

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

Line 701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

697:
698: BEGIN
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;

Line 705: FND_MSG_PUB.Add;

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
709: (p_TERR_USGS_rec.TERR_USG_ID <> FND_API.G_MISS_NUM) ) THEN

Line 767: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

763:
764: x_where_clause := x_where_clause || l_where_clause;
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;

Line 771: FND_MSG_PUB.Add;

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

Line 787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

783:
784: BEGIN
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;

Line 791: FND_MSG_PUB.Add;

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
795: (p_TERR_USGS_rec.TERR_USG_ID <> FND_API.G_MISS_NUM) ) THEN

Line 827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

823:
824: END IF;
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;

Line 831: FND_MSG_PUB.Add;

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

Line 864: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

860:
861: BEGIN
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;

Line 868: FND_MSG_PUB.Add;

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
872: (p_TERR_TYPES_rec.TERR_TYPE_ID <> FND_API.G_MISS_NUM) ) THEN

Line 1005: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1001:
1002: x_where_clause := x_where_clause || l_where_clause;
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;

Line 1009: FND_MSG_PUB.Add;

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

Line 1025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1021:
1022: BEGIN
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;

Line 1029: FND_MSG_PUB.Add;

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
1033: (p_TERR_TYPES_rec.TERR_TYPE_ID <> FND_API.G_MISS_NUM) ) THEN

Line 1075: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1071:
1072: END IF;
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;

Line 1079: FND_MSG_PUB.Add;

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

Line 1112: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1108:
1109: BEGIN
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;

Line 1116: FND_MSG_PUB.Add;

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
1120: (p_TERR_QTYPE_USGS_REC.TERR_QTYPE_USG_ID <> FND_API.G_MISS_NUM) ) THEN

Line 1223: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1219:
1220: x_where_clause := x_where_clause || l_where_clause;
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;

Line 1227: FND_MSG_PUB.Add;

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

Line 1244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1240:
1241: BEGIN
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;

Line 1248: FND_MSG_PUB.Add;

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:
1252: IF ( (p_TERR_QTYPE_USGS_REC.TERR_QTYPE_USG_ID IS NOT NULL) AND

Line 1310: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1306: END IF;
1307:
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;

Line 1314: FND_MSG_PUB.Add;

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

Line 1346: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1342:
1343: BEGIN
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;

Line 1350: FND_MSG_PUB.Add;

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:
1354: IF ( (p_TERR_QUAL_rec.TERR_QUAL_ID IS NOT NULL) AND

Line 1597: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1593:
1594: x_where_clause := x_where_clause || l_where_clause;
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;

Line 1601: FND_MSG_PUB.Add;

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:
1605: END gen_where_clause;

Line 1618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1614: BEGIN
1615:
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;

Line 1622: FND_MSG_PUB.Add;

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
1626: (p_TERR_QUAL_rec.TERR_QUAL_ID <> FND_API.G_MISS_NUM) ) THEN

Line 1723: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1719:
1720: END IF;
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;

Line 1727: FND_MSG_PUB.Add;

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

Line 1761: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1757:
1758: BEGIN
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;

Line 1765: FND_MSG_PUB.Add;

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
1769: (p_TERR_VALUES_rec.TERR_VALUE_ID <> FND_API.G_MISS_NUM) ) THEN

Line 1969: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1965:
1966: x_where_clause := x_where_clause || l_where_clause;
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;

Line 1973: FND_MSG_PUB.Add;

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

Line 1991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1987:
1988: BEGIN
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;

Line 1995: FND_MSG_PUB.Add;

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
1999: (p_TERR_VALUES_rec.TERR_VALUE_ID <> FND_API.G_MISS_NUM) ) THEN

Line 2107: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

2103:
2104: END IF;
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;

Line 2111: FND_MSG_PUB.Add;

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

Line 2145: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

2141:
2142: BEGIN
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;

Line 2149: FND_MSG_PUB.Add;

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
2153: (p_TERR_RSC_rec.TERR_RSC_ID <> FND_API.G_MISS_NUM) ) THEN

Line 2320: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

2316:
2317: x_where_clause := x_where_clause || l_where_clause;
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;

Line 2324: FND_MSG_PUB.Add;

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:
2328: END gen_where_clause;

Line 2341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

2337:
2338: BEGIN
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;

Line 2345: FND_MSG_PUB.Add;

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
2349: (p_TERR_RSC_rec.TERR_RSC_ID <> FND_API.G_MISS_NUM) ) THEN

Line 2421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

2417:
2418: END IF;
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;

Line 2425: FND_MSG_PUB.Add;

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

Line 2453: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

2449:
2450: BEGIN
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;

Line 2457: FND_MSG_PUB.Add;

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
2461: -- Ex:

Line 2466: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

2462: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
2463: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
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;

Line 2469: FND_MSG_PUB.Add;

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:
2473: JTF_CTM_UTILITY_PVT.Translate_OrderBy (

Line 2490: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

2486: x_order_by_clause := NULL;
2487: END IF;
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;

Line 2494: FND_MSG_PUB.Add;

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

Line 2627: FND_MSG_PUB.initialize;

2623:
2624: /* Initialize message list if p_init_msg_list is set to TRUE */
2625: IF FND_API.to_Boolean( p_init_msg_list )
2626: THEN
2627: FND_MSG_PUB.initialize;
2628: END IF;
2629:
2630: /* Debug Message */
2631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 2631: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

2627: FND_MSG_PUB.initialize;
2628: END IF;
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;

Line 2635: FND_MSG_PUB.Add;

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: /**********************************************************************************************
2639: ** API BODY START

Line 2656: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

2652: ** Ignore condition when criteria is NULL
2653: */
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;

Line 2659: FND_MSG_PUB.Add;

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: /******************************/
2663: /* OPEN CURSOR for processing */

Line 2952: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

2948: ** API BODY END
2949: ***********************************************************************************************/
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;

Line 2956: FND_MSG_PUB.Add;

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. */
2960: FND_MSG_PUB.Count_And_Get

Line 2960: FND_MSG_PUB.Count_And_Get

2956: FND_MSG_PUB.Add;
2957: END IF;
2958:
2959: /* Standard call to get message count and if count is 1, get message info. */
2960: FND_MSG_PUB.Count_And_Get
2961: ( p_count => x_msg_count,
2962: p_data => x_msg_data
2963: );
2964:

Line 2970: FND_MSG_PUB.Count_And_Get

2966: WHEN FND_API.G_EXC_ERROR THEN
2967: x_return_status := FND_API.G_RET_STS_ERROR ;
2968: --dbms_output.put_line( 'FND_API.G_EXC_ERROR: return_status = '|| l_return_status );
2969:
2970: FND_MSG_PUB.Count_And_Get
2971: ( p_count => x_msg_count,
2972: p_data => x_msg_data
2973: );
2974:

Line 2980: FND_MSG_PUB.Count_And_Get

2976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2978: --dbms_output.put_line( 'FND_API.G_EXC_UNEXPECTED_ERROR: return_status = '|| l_return_status );
2979:
2980: FND_MSG_PUB.Count_And_Get
2981: ( p_count => x_msg_count,
2982: p_data => x_msg_data
2983: );
2984:

Line 2990: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

2986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2987:
2988: --dbms_output.put_line( 'OTHERS: return_status = '|| l_return_status );
2989:
2990: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2991: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2992: END IF;
2993:
2994: FND_MSG_PUB.Count_And_Get

Line 2991: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2987:
2988: --dbms_output.put_line( 'OTHERS: return_status = '|| l_return_status );
2989:
2990: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2991: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2992: END IF;
2993:
2994: FND_MSG_PUB.Count_And_Get
2995: ( p_count => x_msg_count,

Line 2994: FND_MSG_PUB.Count_And_Get

2990: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2991: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2992: END IF;
2993:
2994: FND_MSG_PUB.Count_And_Get
2995: ( p_count => x_msg_count,
2996: p_data => x_msg_data
2997: );
2998:

Line 3363: FND_MSG_PUB.initialize;

3359:
3360: /* Initialize message list if p_init_msg_list is set to TRUE */
3361: IF FND_API.to_Boolean( p_init_msg_list )
3362: THEN
3363: FND_MSG_PUB.initialize;
3364: END IF;
3365:
3366: /* Debug Message */
3367: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 3367: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

3363: FND_MSG_PUB.initialize;
3364: END IF;
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;

Line 3371: FND_MSG_PUB.Add;

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:
3375: /**********************************************************************************************

Line 3445: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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

Line 3447: FND_MSG_PUB.ADD;

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:
3451: CLOSE get_terr;

Line 3500: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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

Line 3502: FND_MSG_PUB.ADD;

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:
3506: CLOSE get_terr_type;

Line 3795: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

3791: ** API BODY END
3792: ***********************************************************************************************/
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;

Line 3799: FND_MSG_PUB.Add;

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. */
3803: FND_MSG_PUB.Count_And_Get

Line 3803: FND_MSG_PUB.Count_And_Get

3799: FND_MSG_PUB.Add;
3800: END IF;
3801:
3802: /* Standard call to get message count and if count is 1, get message info. */
3803: FND_MSG_PUB.Count_And_Get
3804: ( p_count => x_msg_count,
3805: p_data => x_msg_data
3806: );
3807:

Line 3813: FND_MSG_PUB.Count_And_Get

3809: WHEN FND_API.G_EXC_ERROR THEN
3810: x_return_status := FND_API.G_RET_STS_ERROR ;
3811: --dbms_output.put_line( 'FND_API.G_EXC_ERROR: return_status = '|| x_return_status );
3812:
3813: FND_MSG_PUB.Count_And_Get
3814: ( p_count => x_msg_count,
3815: p_data => x_msg_data
3816: );
3817:

Line 3823: FND_MSG_PUB.Count_And_Get

3819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3821: --dbms_output.put_line( 'FND_API.G_RET_STS_UNEXP_ERROR: return_status = '|| x_return_status );
3822:
3823: FND_MSG_PUB.Count_And_Get
3824: ( p_count => x_msg_count,
3825: p_data => x_msg_data
3826: );
3827:

Line 3831: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

3827:
3828: WHEN OTHERS THEN
3829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3830: --dbms_output.put_line( 'OTHERS: return_status = '|| x_return_status );
3831: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3832: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3833: END IF;
3834:
3835: FND_MSG_PUB.Count_And_Get

Line 3832: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

3828: WHEN OTHERS THEN
3829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3830: --dbms_output.put_line( 'OTHERS: return_status = '|| x_return_status );
3831: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3832: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3833: END IF;
3834:
3835: FND_MSG_PUB.Count_And_Get
3836: ( p_count => x_msg_count,

Line 3835: FND_MSG_PUB.Count_And_Get

3831: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
3832: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3833: END IF;
3834:
3835: FND_MSG_PUB.Count_And_Get
3836: ( p_count => x_msg_count,
3837: p_data => x_msg_data
3838: );
3839:

Line 3925: FND_MSG_PUB.initialize;

3921:
3922: /* Initialize message list if p_init_msg_list is set to TRUE */
3923: IF FND_API.to_Boolean( p_init_msg_list )
3924: THEN
3925: FND_MSG_PUB.initialize;
3926: END IF;
3927:
3928: /* Debug Message */
3929: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 3929: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

3925: FND_MSG_PUB.initialize;
3926: END IF;
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;

Line 3933: FND_MSG_PUB.Add;

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:
3937: /**********************************************************************************************

Line 3951: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

3947:
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:

Line 3953: FND_MSG_PUB.ADD;

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
3957:

Line 3979: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

3975: ** API BODY END
3976: ***********************************************************************************************/
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;

Line 3983: FND_MSG_PUB.Add;

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. */
3987: FND_MSG_PUB.Count_And_Get

Line 3987: FND_MSG_PUB.Count_And_Get

3983: FND_MSG_PUB.Add;
3984: END IF;
3985:
3986: /* Standard call to get message count and if count is 1, get message info. */
3987: FND_MSG_PUB.Count_And_Get
3988: ( p_count => x_msg_count,
3989: p_data => x_msg_data
3990: );
3991:

Line 3996: FND_MSG_PUB.Count_And_Get

3992: EXCEPTION
3993: WHEN FND_API.G_EXC_ERROR THEN
3994: x_return_status := FND_API.G_RET_STS_ERROR ;
3995:
3996: FND_MSG_PUB.Count_And_Get
3997: ( p_count => x_msg_count,
3998: p_data => x_msg_data
3999: );
4000:

Line 4005: FND_MSG_PUB.Count_And_Get

4001:
4002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4004:
4005: FND_MSG_PUB.Count_And_Get
4006: ( p_count => x_msg_count,
4007: p_data => x_msg_data
4008: );
4009:

Line 4013: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

4009:
4010: WHEN OTHERS THEN
4011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4012:
4013: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4014: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4015: END IF;
4016:
4017: FND_MSG_PUB.Count_And_Get

Line 4014: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4010: WHEN OTHERS THEN
4011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4012:
4013: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4014: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4015: END IF;
4016:
4017: FND_MSG_PUB.Count_And_Get
4018: ( p_count => x_msg_count,

Line 4017: FND_MSG_PUB.Count_And_Get

4013: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4014: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4015: END IF;
4016:
4017: FND_MSG_PUB.Count_And_Get
4018: ( p_count => x_msg_count,
4019: p_data => x_msg_data
4020: );
4021:

Line 4103: FND_MSG_PUB.initialize;

4099:
4100: /* Initialize message list if p_init_msg_list is set to TRUE */
4101: IF FND_API.to_Boolean( p_init_msg_list )
4102: THEN
4103: FND_MSG_PUB.initialize;
4104: END IF;
4105:
4106: /* Debug Message */
4107: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 4107: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

4103: FND_MSG_PUB.initialize;
4104: END IF;
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;

Line 4111: FND_MSG_PUB.Add;

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: /**********************************************************************************************
4115: ** API BODY START

Line 4128: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

4124:
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:

Line 4130: FND_MSG_PUB.ADD;

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
4134:

Line 4156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

4152: ** API BODY END
4153: ***********************************************************************************************/
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;

Line 4160: FND_MSG_PUB.Add;

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. */
4164: FND_MSG_PUB.Count_And_Get

Line 4164: FND_MSG_PUB.Count_And_Get

4160: FND_MSG_PUB.Add;
4161: END IF;
4162:
4163: /* Standard call to get message count and if count is 1, get message info. */
4164: FND_MSG_PUB.Count_And_Get
4165: ( p_count => x_msg_count,
4166: p_data => x_msg_data
4167: );
4168:

Line 4173: FND_MSG_PUB.Count_And_Get

4169: EXCEPTION
4170: WHEN FND_API.G_EXC_ERROR THEN
4171: x_return_status := FND_API.G_RET_STS_ERROR ;
4172:
4173: FND_MSG_PUB.Count_And_Get
4174: ( p_count => x_msg_count,
4175: p_data => x_msg_data
4176: );
4177:

Line 4182: FND_MSG_PUB.Count_And_Get

4178:
4179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4181:
4182: FND_MSG_PUB.Count_And_Get
4183: ( p_count => x_msg_count,
4184: p_data => x_msg_data
4185: );
4186:

Line 4190: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

4186:
4187: WHEN OTHERS THEN
4188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4189:
4190: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4191: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4192: END IF;
4193:
4194: FND_MSG_PUB.Count_And_Get

Line 4191: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4187: WHEN OTHERS THEN
4188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4189:
4190: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4191: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4192: END IF;
4193:
4194: FND_MSG_PUB.Count_And_Get
4195: ( p_count => x_msg_count,

Line 4194: FND_MSG_PUB.Count_And_Get

4190: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4191: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4192: END IF;
4193:
4194: FND_MSG_PUB.Count_And_Get
4195: ( p_count => x_msg_count,
4196: p_data => x_msg_data
4197: );
4198:

Line 4304: FND_MSG_PUB.initialize;

4300:
4301: -- Initialize message list if p_init_msg_list is set to TRUE.
4302: IF FND_API.to_Boolean( p_init_msg_list )
4303: THEN
4304: FND_MSG_PUB.initialize;
4305: END IF;
4306:
4307: /* Debug Message */
4308: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 4308: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

4304: FND_MSG_PUB.initialize;
4305: END IF;
4306:
4307: /* Debug Message */
4308: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4309: THEN
4310: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
4311: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
4312: FND_MSG_PUB.Add;

Line 4312: FND_MSG_PUB.Add;

4308: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4309: THEN
4310: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_START_MSG');
4311: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
4312: FND_MSG_PUB.Add;
4313: END IF;
4314: --
4315: -- API body
4316: --

Line 4340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

4336: --dbms_output.put_line('No records returned');
4337: End If;
4338: --
4339: /* Debug Message */
4340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4341: THEN
4342: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
4343: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
4344: FND_MSG_PUB.Add;

Line 4344: FND_MSG_PUB.Add;

4340: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4341: THEN
4342: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_END_MSG');
4343: FND_MESSAGE.Set_Token('PROC_NAME', l_api_name);
4344: FND_MSG_PUB.Add;
4345: END IF;
4346:
4347: -- Standard call to get message count and if count is 1, get message info.
4348: FND_MSG_PUB.Count_And_Get

Line 4348: FND_MSG_PUB.Count_And_Get

4344: FND_MSG_PUB.Add;
4345: END IF;
4346:
4347: -- Standard call to get message count and if count is 1, get message info.
4348: FND_MSG_PUB.Count_And_Get
4349: ( p_count => x_msg_count,
4350: p_data => x_msg_data
4351: );
4352: --dbms_output.put_line('Get_Escalation_TerrMembers: Exiting the API');

Line 4357: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

4353: EXCEPTION
4354: --
4355: WHEN OTHERS THEN
4356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4357: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4359: END IF;
4360: FND_MSG_PUB.Count_And_Get
4361: ( p_count => x_msg_count,

Line 4358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

4354: --
4355: WHEN OTHERS THEN
4356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4357: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4359: END IF;
4360: FND_MSG_PUB.Count_And_Get
4361: ( p_count => x_msg_count,
4362: p_data => x_msg_data

Line 4360: FND_MSG_PUB.Count_And_Get

4356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4357: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
4358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4359: END IF;
4360: FND_MSG_PUB.Count_And_Get
4361: ( p_count => x_msg_count,
4362: p_data => x_msg_data
4363: );
4364: --