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.GCS_INTERCO_DYNAMIC_PKG dependencies on FND_MESSAGE

Line 153: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

149: giet.line_item_id;
150: g_no_rows := NVL(SQL%ROWCOUNT,0);
151:
152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
154: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
156:
157: FND_LOG.String (fnd_log.level_procedure,

Line 154: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));

150: g_no_rows := NVL(SQL%ROWCOUNT,0);
151:
152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
154: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
156:
157: FND_LOG.String (fnd_log.level_procedure,
158: g_pkg_name || '.' || l_api_name,

Line 155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

151:
152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
154: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
156:
157: FND_LOG.String (fnd_log.level_procedure,
158: g_pkg_name || '.' || l_api_name,
159: 'SHRD0117: '||FND_MESSAGE.get);

Line 159: 'SHRD0117: '||FND_MESSAGE.get);

155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
156:
157: FND_LOG.String (fnd_log.level_procedure,
158: g_pkg_name || '.' || l_api_name,
159: 'SHRD0117: '||FND_MESSAGE.get);
160: END IF;
161:
162: --****************************----
163: g_no_rows := 0;

Line 241: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

237: giet.line_item_id;
238: g_no_rows := NVL(SQL%ROWCOUNT,0);
239:
240: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
241: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
242: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
243: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
244:
245: FND_LOG.String (fnd_log.level_procedure,

Line 242: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));

238: g_no_rows := NVL(SQL%ROWCOUNT,0);
239:
240: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
241: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
242: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
243: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
244:
245: FND_LOG.String (fnd_log.level_procedure,
246: g_pkg_name || '.' || l_api_name,

Line 243: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

239:
240: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
241: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
242: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
243: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
244:
245: FND_LOG.String (fnd_log.level_procedure,
246: g_pkg_name || '.' || l_api_name,
247: 'SHRD0117: '||FND_MESSAGE.get);

Line 247: 'SHRD0117: '||FND_MESSAGE.get);

243: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
244:
245: FND_LOG.String (fnd_log.level_procedure,
246: g_pkg_name || '.' || l_api_name,
247: 'SHRD0117: '||FND_MESSAGE.get);
248: END IF;
249:
250:
251:

Line 336: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

332:
333: g_no_rows := NVL(SQL%ROWCOUNT,0);
334:
335: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
336: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
337: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
338: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
339:
340: FND_LOG.String (fnd_log.level_procedure,

Line 337: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));

333: g_no_rows := NVL(SQL%ROWCOUNT,0);
334:
335: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
336: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
337: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
338: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
339:
340: FND_LOG.String (fnd_log.level_procedure,
341: g_pkg_name || '.' || l_api_name,

Line 338: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

334:
335: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
336: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
337: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
338: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
339:
340: FND_LOG.String (fnd_log.level_procedure,
341: g_pkg_name || '.' || l_api_name,
342: 'SHRD0117: '||FND_MESSAGE.get);

Line 342: 'SHRD0117: '||FND_MESSAGE.get);

338: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
339:
340: FND_LOG.String (fnd_log.level_procedure,
341: g_pkg_name || '.' || l_api_name,
342: 'SHRD0117: '||FND_MESSAGE.get);
343: END IF;
344:
345:
346: g_no_rows := 0;

Line 427: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

423:
424: g_no_rows := NVL(SQL%ROWCOUNT,0);
425:
426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
428: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
429: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
430:
431: FND_LOG.String (fnd_log.level_procedure,

Line 428: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));

424: g_no_rows := NVL(SQL%ROWCOUNT,0);
425:
426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
428: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
429: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
430:
431: FND_LOG.String (fnd_log.level_procedure,
432: g_pkg_name || '.' || l_api_name,

Line 429: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

425:
426: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
428: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
429: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
430:
431: FND_LOG.String (fnd_log.level_procedure,
432: g_pkg_name || '.' || l_api_name,
433: 'SHRD0117: '||FND_MESSAGE.get);

Line 433: 'SHRD0117: '||FND_MESSAGE.get);

429: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
430:
431: FND_LOG.String (fnd_log.level_procedure,
432: g_pkg_name || '.' || l_api_name,
433: 'SHRD0117: '||FND_MESSAGE.get);
434: END IF;
435: END IF; -- End if for match by
436:
437: ELSIF (P_ELIM_MODE = 'IA') THEN

Line 524: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

520: giet.line_item_id;
521: g_no_rows := NVL(SQL%ROWCOUNT,0);
522:
523: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
525: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
526: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
527:
528: FND_LOG.String (fnd_log.level_procedure,

Line 525: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));

521: g_no_rows := NVL(SQL%ROWCOUNT,0);
522:
523: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
525: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
526: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
527:
528: FND_LOG.String (fnd_log.level_procedure,
529: g_pkg_name || '.' || l_api_name,

Line 526: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

522:
523: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
524: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
525: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
526: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
527:
528: FND_LOG.String (fnd_log.level_procedure,
529: g_pkg_name || '.' || l_api_name,
530: 'SHRD0117: '||FND_MESSAGE.get);

Line 530: 'SHRD0117: '||FND_MESSAGE.get);

526: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
527:
528: FND_LOG.String (fnd_log.level_procedure,
529: g_pkg_name || '.' || l_api_name,
530: 'SHRD0117: '||FND_MESSAGE.get);
531: END IF;
532:
533:
534:

Line 624: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

620:
621: g_no_rows := NVL(SQL%ROWCOUNT,0);
622:
623: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
624: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
625: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
626: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
627:
628: FND_LOG.String (fnd_log.level_procedure,

Line 625: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));

621: g_no_rows := NVL(SQL%ROWCOUNT,0);
622:
623: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
624: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
625: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
626: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
627:
628: FND_LOG.String (fnd_log.level_procedure,
629: g_pkg_name || '.' || l_api_name,

Line 626: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

622:
623: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
624: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
625: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
626: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
627:
628: FND_LOG.String (fnd_log.level_procedure,
629: g_pkg_name || '.' || l_api_name,
630: 'SHRD0117: '||FND_MESSAGE.get);

Line 630: 'SHRD0117: '||FND_MESSAGE.get);

626: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
627:
628: FND_LOG.String (fnd_log.level_procedure,
629: g_pkg_name || '.' || l_api_name,
630: 'SHRD0117: '||FND_MESSAGE.get);
631: END IF;
632: End If; -- End of matching rule code in intracompany
633:
634: END If; -- End of elimination mode.

Line 798: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

794:
795: g_no_rows := NVL(SQL%ROWCOUNT,0);
796:
797: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
798: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
799: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
800: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
801:
802: FND_LOG.String (fnd_log.level_procedure,

Line 799: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));

795: g_no_rows := NVL(SQL%ROWCOUNT,0);
796:
797: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
798: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
799: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
800: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
801:
802: FND_LOG.String (fnd_log.level_procedure,
803: g_pkg_name || '.' || l_api_name,

Line 800: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

796:
797: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
798: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
799: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
800: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
801:
802: FND_LOG.String (fnd_log.level_procedure,
803: g_pkg_name || '.' || l_api_name,
804: 'SHRD0117: '||FND_MESSAGE.get);

Line 804: 'SHRD0117: '||FND_MESSAGE.get);

800: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
801:
802: FND_LOG.String (fnd_log.level_procedure,
803: g_pkg_name || '.' || l_api_name,
804: 'SHRD0117: '||FND_MESSAGE.get);
805: END IF;
806:
807: ELSIF (p_match_rule_code = 'ORGANIZATION') THEN
808: -- In Intercompany option

Line 870: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

866:
867: g_no_rows := NVL(SQL%ROWCOUNT,0);
868:
869: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
870: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
871: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
872: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
873:
874: FND_LOG.String (fnd_log.level_procedure,

Line 871: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));

867: g_no_rows := NVL(SQL%ROWCOUNT,0);
868:
869: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
870: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
871: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
872: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
873:
874: FND_LOG.String (fnd_log.level_procedure,
875: g_pkg_name || '.' || l_api_name,

Line 872: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');

868:
869: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
870: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
871: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
872: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
873:
874: FND_LOG.String (fnd_log.level_procedure,
875: g_pkg_name || '.' || l_api_name,
876: 'SHRD0117: '||FND_MESSAGE.get);

Line 876: 'SHRD0117: '||FND_MESSAGE.get);

872: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES_GT');
873:
874: FND_LOG.String (fnd_log.level_procedure,
875: g_pkg_name || '.' || l_api_name,
876: 'SHRD0117: '||FND_MESSAGE.get);
877:
878: END IF;
879: END IF; -- Ends matching rule code in intercompany.
880: END IF; --Added to end the mode IF

Line 937: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

933:
934: g_no_rows := NVL(SQL%ROWCOUNT,0);
935:
936: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
937: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
938: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
939: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES');
940:
941: FND_LOG.String (fnd_log.level_procedure,

Line 938: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));

934: g_no_rows := NVL(SQL%ROWCOUNT,0);
935:
936: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
937: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
938: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
939: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES');
940:
941: FND_LOG.String (fnd_log.level_procedure,
942: g_pkg_name || '.' || l_api_name,

Line 939: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES');

935:
936: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
937: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
938: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
939: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES');
940:
941: FND_LOG.String (fnd_log.level_procedure,
942: g_pkg_name || '.' || l_api_name,
943: 'SHRD0117: '||FND_MESSAGE.get);

Line 943: 'SHRD0117: '||FND_MESSAGE.get);

939: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES');
940:
941: FND_LOG.String (fnd_log.level_procedure,
942: g_pkg_name || '.' || l_api_name,
943: 'SHRD0117: '||FND_MESSAGE.get);
944:
945: END IF;
946:
947:

Line 1302: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

1298:
1299: l_no_rows := NVL(SQL%ROWCOUNT,0);
1300:
1301: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1302: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1303: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1304: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1305:
1306: FND_LOG.String (fnd_log.level_procedure,

Line 1303: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));

1299: l_no_rows := NVL(SQL%ROWCOUNT,0);
1300:
1301: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1302: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1303: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1304: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1305:
1306: FND_LOG.String (fnd_log.level_procedure,
1307: g_pkg_name || '.' || l_api_name,

Line 1304: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');

1300:
1301: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1302: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1303: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1304: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1305:
1306: FND_LOG.String (fnd_log.level_procedure,
1307: g_pkg_name || '.' || l_api_name,
1308: 'SHRD0117: '||FND_MESSAGE.get);

Line 1308: 'SHRD0117: '||FND_MESSAGE.get);

1304: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1305:
1306: FND_LOG.String (fnd_log.level_procedure,
1307: g_pkg_name || '.' || l_api_name,
1308: 'SHRD0117: '||FND_MESSAGE.get);
1309: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1310: END IF;
1311:
1312: ELSE

Line 1309: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);

1305:
1306: FND_LOG.String (fnd_log.level_procedure,
1307: g_pkg_name || '.' || l_api_name,
1308: 'SHRD0117: '||FND_MESSAGE.get);
1309: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1310: END IF;
1311:
1312: ELSE
1313:

Line 1445: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

1441:
1442: l_no_rows := NVL(SQL%ROWCOUNT,0);
1443:
1444: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1445: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1446: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1447: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1448:
1449: FND_LOG.String (fnd_log.level_procedure,

Line 1446: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));

1442: l_no_rows := NVL(SQL%ROWCOUNT,0);
1443:
1444: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1445: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1446: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1447: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1448:
1449: FND_LOG.String (fnd_log.level_procedure,
1450: g_pkg_name || '.' || l_api_name,

Line 1447: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');

1443:
1444: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1445: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1446: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1447: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1448:
1449: FND_LOG.String (fnd_log.level_procedure,
1450: g_pkg_name || '.' || l_api_name,
1451: 'SHRD0117: '||FND_MESSAGE.get);

Line 1451: 'SHRD0117: '||FND_MESSAGE.get);

1447: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1448:
1449: FND_LOG.String (fnd_log.level_procedure,
1450: g_pkg_name || '.' || l_api_name,
1451: 'SHRD0117: '||FND_MESSAGE.get);
1452: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1453: END IF;
1454: END IF; -- end of x_intercompany_org_code if
1455:

Line 1452: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);

1448:
1449: FND_LOG.String (fnd_log.level_procedure,
1450: g_pkg_name || '.' || l_api_name,
1451: 'SHRD0117: '||FND_MESSAGE.get);
1452: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1453: END IF;
1454: END IF; -- end of x_intercompany_org_code if
1455:
1456: ELSE

Line 1536: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

1532:
1533: l_no_rows := NVL(SQL%ROWCOUNT,0);
1534:
1535: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1536: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1537: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1538: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1539:
1540: FND_LOG.String (fnd_log.level_procedure,

Line 1537: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));

1533: l_no_rows := NVL(SQL%ROWCOUNT,0);
1534:
1535: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1536: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1537: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1538: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1539:
1540: FND_LOG.String (fnd_log.level_procedure,
1541: g_pkg_name || '.' || l_api_name,

Line 1538: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');

1534:
1535: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1536: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1537: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1538: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1539:
1540: FND_LOG.String (fnd_log.level_procedure,
1541: g_pkg_name || '.' || l_api_name,
1542: 'SHRD0117: '||FND_MESSAGE.get);

Line 1542: 'SHRD0117: '||FND_MESSAGE.get);

1538: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1539:
1540: FND_LOG.String (fnd_log.level_procedure,
1541: g_pkg_name || '.' || l_api_name,
1542: 'SHRD0117: '||FND_MESSAGE.get);
1543: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1544: END IF;
1545:
1546: ELSE

Line 1543: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);

1539:
1540: FND_LOG.String (fnd_log.level_procedure,
1541: g_pkg_name || '.' || l_api_name,
1542: 'SHRD0117: '||FND_MESSAGE.get);
1543: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1544: END IF;
1545:
1546: ELSE
1547: l_no_rows := 0;

Line 1623: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

1619:
1620: l_no_rows := NVL(SQL%ROWCOUNT,0);
1621:
1622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1624: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1625: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1626:
1627: FND_LOG.String (fnd_log.level_procedure,

Line 1624: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));

1620: l_no_rows := NVL(SQL%ROWCOUNT,0);
1621:
1622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1624: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1625: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1626:
1627: FND_LOG.String (fnd_log.level_procedure,
1628: g_pkg_name || '.' || l_api_name,

Line 1625: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');

1621:
1622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1624: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1625: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1626:
1627: FND_LOG.String (fnd_log.level_procedure,
1628: g_pkg_name || '.' || l_api_name,
1629: 'SHRD0117: '||FND_MESSAGE.get);

Line 1629: 'SHRD0117: '||FND_MESSAGE.get);

1625: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1626:
1627: FND_LOG.String (fnd_log.level_procedure,
1628: g_pkg_name || '.' || l_api_name,
1629: 'SHRD0117: '||FND_MESSAGE.get);
1630: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1631: END IF;
1632: END IF; -- end of x_intercompany_org_code if
1633: END IF; -- End of LOB_REPORTING_ENABLED IF clause.

Line 1630: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);

1626:
1627: FND_LOG.String (fnd_log.level_procedure,
1628: g_pkg_name || '.' || l_api_name,
1629: 'SHRD0117: '||FND_MESSAGE.get);
1630: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1631: END IF;
1632: END IF; -- end of x_intercompany_org_code if
1633: END IF; -- End of LOB_REPORTING_ENABLED IF clause.
1634:

Line 1736: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

1732:
1733: l_no_rows := NVL(SQL%ROWCOUNT,0);
1734:
1735: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1736: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1737: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1738: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1739:
1740: FND_LOG.String (fnd_log.level_procedure,

Line 1737: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));

1733: l_no_rows := NVL(SQL%ROWCOUNT,0);
1734:
1735: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1736: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1737: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1738: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1739:
1740: FND_LOG.String (fnd_log.level_procedure,
1741: g_pkg_name || '.' || l_api_name,

Line 1738: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');

1734:
1735: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1736: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1737: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1738: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1739:
1740: FND_LOG.String (fnd_log.level_procedure,
1741: g_pkg_name || '.' || l_api_name,
1742: 'SHRD0117: '||FND_MESSAGE.get);

Line 1742: 'SHRD0117: '||FND_MESSAGE.get);

1738: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1739:
1740: FND_LOG.String (fnd_log.level_procedure,
1741: g_pkg_name || '.' || l_api_name,
1742: 'SHRD0117: '||FND_MESSAGE.get);
1743: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1744:
1745: END IF;
1746:

Line 1743: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);

1739:
1740: FND_LOG.String (fnd_log.level_procedure,
1741: g_pkg_name || '.' || l_api_name,
1742: 'SHRD0117: '||FND_MESSAGE.get);
1743: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1744:
1745: END IF;
1746:
1747:

Line 1849: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');

1845:
1846: l_no_rows := NVL(SQL%ROWCOUNT,0);
1847:
1848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1849: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1850: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1851: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1852:
1853: FND_LOG.String (fnd_log.level_procedure,

Line 1850: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));

1846: l_no_rows := NVL(SQL%ROWCOUNT,0);
1847:
1848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1849: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1850: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1851: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1852:
1853: FND_LOG.String (fnd_log.level_procedure,
1854: g_pkg_name || '.' || l_api_name,

Line 1851: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');

1847:
1848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1849: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1850: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1851: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1852:
1853: FND_LOG.String (fnd_log.level_procedure,
1854: g_pkg_name || '.' || l_api_name,
1855: 'SHRD0117: '||FND_MESSAGE.get);

Line 1855: 'SHRD0117: '||FND_MESSAGE.get);

1851: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1852:
1853: FND_LOG.String (fnd_log.level_procedure,
1854: g_pkg_name || '.' || l_api_name,
1855: 'SHRD0117: '||FND_MESSAGE.get);
1856: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1857:
1858: END IF;
1859: END IF; -- Ends Company if specific value..

Line 1856: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);

1852:
1853: FND_LOG.String (fnd_log.level_procedure,
1854: g_pkg_name || '.' || l_api_name,
1855: 'SHRD0117: '||FND_MESSAGE.get);
1856: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1857:
1858: END IF;
1859: END IF; -- Ends Company if specific value..
1860: END IF; -- Ends If matching by