APPS.GCS_INTERCO_PROCESSING_PKG dependencies on FND_MESSAGE

Line 751: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');

747:
748: g_no_rows := NVL(SQL%ROWCOUNT,0);
749:
750: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
751: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');
752: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
753: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES');
754:
755:

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

748: g_no_rows := NVL(SQL%ROWCOUNT,0);
749:
750: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
751: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');
752: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
753: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES');
754:
755:
756: FND_LOG.String (fnd_log.level_procedure,

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

749:
750: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
751: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');
752: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
753: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_LINES');
754:
755:
756: FND_LOG.String (fnd_log.level_procedure,
757: g_pkg_name || '.' || l_api_name,

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

754:
755:
756: FND_LOG.String (fnd_log.level_procedure,
757: g_pkg_name || '.' || l_api_name,
758: 'SHRD0117: '||FND_MESSAGE.get);
759: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0118: '||FND_MESSAGE.get);
760: END IF;
761:
762:

Line 759: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0118: '||FND_MESSAGE.get);

755:
756: FND_LOG.String (fnd_log.level_procedure,
757: g_pkg_name || '.' || l_api_name,
758: 'SHRD0117: '||FND_MESSAGE.get);
759: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0118: '||FND_MESSAGE.get);
760: END IF;
761:
762:
763:

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

1242: g_no_rows := NVL(SQL%ROWCOUNT,0);
1243:
1244:
1245: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1246: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1247: FND_MESSAGE.Set_Token('NUM',TO_CHAR(NVL(SQL%ROWCOUNT,0)));
1248: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1249:
1250:

Line 1247: FND_MESSAGE.Set_Token('NUM',TO_CHAR(NVL(SQL%ROWCOUNT,0)));

1243:
1244:
1245: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1246: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1247: FND_MESSAGE.Set_Token('NUM',TO_CHAR(NVL(SQL%ROWCOUNT,0)));
1248: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1249:
1250:
1251:

Line 1248: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');

1244:
1245: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1246: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1247: FND_MESSAGE.Set_Token('NUM',TO_CHAR(NVL(SQL%ROWCOUNT,0)));
1248: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1249:
1250:
1251:
1252: FND_LOG.String (fnd_log.level_procedure,

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

1250:
1251:
1252: FND_LOG.String (fnd_log.level_procedure,
1253: g_pkg_name || '.' || l_api_name,
1254: 'SHRD0117: '||FND_MESSAGE.get);
1255: END IF;
1256:
1257: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1258: fnd_log.STRING (fnd_log.level_procedure,

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

1377: g_no_rows := NVL(SQL%ROWCOUNT,0);
1378: END IF;
1379:
1380: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1382: FND_MESSAGE.Set_Token('NUM',TO_CHAR(NVL(SQL%ROWCOUNT,0)));
1383: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1384:
1385:

Line 1382: FND_MESSAGE.Set_Token('NUM',TO_CHAR(NVL(SQL%ROWCOUNT,0)));

1378: END IF;
1379:
1380: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1382: FND_MESSAGE.Set_Token('NUM',TO_CHAR(NVL(SQL%ROWCOUNT,0)));
1383: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1384:
1385:
1386:

Line 1383: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');

1379:
1380: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1382: FND_MESSAGE.Set_Token('NUM',TO_CHAR(NVL(SQL%ROWCOUNT,0)));
1383: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1384:
1385:
1386:
1387: FND_LOG.String (fnd_log.level_procedure,

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

1385:
1386:
1387: FND_LOG.String (fnd_log.level_procedure,
1388: g_pkg_name || '.' || l_api_name,
1389: 'SHRD0117: '||FND_MESSAGE.get);
1390: END IF;
1391: -- Start Bugfix 5974635
1392:
1393: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1416: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');

1412:
1413: l_no_rows := NVL(SQL%ROWCOUNT,0);
1414:
1415: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1416: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');
1417: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1418: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1419:
1420:

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

1413: l_no_rows := NVL(SQL%ROWCOUNT,0);
1414:
1415: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1416: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');
1417: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1418: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1419:
1420:
1421: FND_LOG.String (fnd_log.level_procedure,

Line 1418: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');

1414:
1415: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1416: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');
1417: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1418: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1419:
1420:
1421: FND_LOG.String (fnd_log.level_procedure,
1422: g_pkg_name || '.' || l_api_name,

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

1419:
1420:
1421: FND_LOG.String (fnd_log.level_procedure,
1422: g_pkg_name || '.' || l_api_name,
1423: 'SHRD0117: '||FND_MESSAGE.get);
1424:
1425: END IF;
1426:
1427: -- End Bugfix 5974635

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

1502:
1503: g_no_rows := NVL(SQL%ROWCOUNT,0);
1504:
1505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1506: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1507: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1508: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1509:
1510:

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

1503: g_no_rows := NVL(SQL%ROWCOUNT,0);
1504:
1505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1506: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1507: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1508: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1509:
1510:
1511: FND_LOG.String (fnd_log.level_procedure,

Line 1508: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');

1504:
1505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1506: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1507: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1508: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1509:
1510:
1511: FND_LOG.String (fnd_log.level_procedure,
1512: g_pkg_name || '.' || l_api_name,

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

1509:
1510:
1511: FND_LOG.String (fnd_log.level_procedure,
1512: g_pkg_name || '.' || l_api_name,
1513: 'SHRD0117: '||FND_MESSAGE.get);
1514: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1515: END IF;
1516:
1517: END IF; -- End of Intercompany or intra company modes.

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

1510:
1511: FND_LOG.String (fnd_log.level_procedure,
1512: g_pkg_name || '.' || l_api_name,
1513: 'SHRD0117: '||FND_MESSAGE.get);
1514: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1515: END IF;
1516:
1517: END IF; -- End of Intercompany or intra company modes.
1518:

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

1557:
1558: g_no_rows := NVL(SQL%ROWCOUNT,0);
1559:
1560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1561: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1562: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1563: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1564:
1565: FND_LOG.String (fnd_log.level_procedure,

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

1558: g_no_rows := NVL(SQL%ROWCOUNT,0);
1559:
1560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1561: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1562: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1563: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1564:
1565: FND_LOG.String (fnd_log.level_procedure,
1566: g_pkg_name || '.' || l_api_name,

Line 1563: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');

1559:
1560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1561: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1562: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1563: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1564:
1565: FND_LOG.String (fnd_log.level_procedure,
1566: g_pkg_name || '.' || l_api_name,
1567: 'SHRD0117: '||FND_MESSAGE.get);

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

1563: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1564:
1565: FND_LOG.String (fnd_log.level_procedure,
1566: g_pkg_name || '.' || l_api_name,
1567: 'SHRD0117: '||FND_MESSAGE.get);
1568: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1569: END IF;
1570:
1571: /* ------------------------------------------------------------------------+

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

1564:
1565: FND_LOG.String (fnd_log.level_procedure,
1566: g_pkg_name || '.' || l_api_name,
1567: 'SHRD0117: '||FND_MESSAGE.get);
1568: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1569: END IF;
1570:
1571: /* ------------------------------------------------------------------------+
1572:

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

1615:
1616: g_no_rows := NVL(SQL%ROWCOUNT,0);
1617:
1618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1619: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1620: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1621: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1622:
1623: FND_LOG.String (fnd_log.level_procedure,

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

1616: g_no_rows := NVL(SQL%ROWCOUNT,0);
1617:
1618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1619: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1620: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1621: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1622:
1623: FND_LOG.String (fnd_log.level_procedure,
1624: g_pkg_name || '.' || l_api_name,

Line 1621: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');

1617:
1618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1619: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1620: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1621: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1622:
1623: FND_LOG.String (fnd_log.level_procedure,
1624: g_pkg_name || '.' || l_api_name,
1625: 'SHRD0117: '||FND_MESSAGE.get);

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

1621: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1622:
1623: FND_LOG.String (fnd_log.level_procedure,
1624: g_pkg_name || '.' || l_api_name,
1625: 'SHRD0117: '||FND_MESSAGE.get);
1626: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1627: END IF;
1628:
1629: */

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

1622:
1623: FND_LOG.String (fnd_log.level_procedure,
1624: g_pkg_name || '.' || l_api_name,
1625: 'SHRD0117: '||FND_MESSAGE.get);
1626: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1627: END IF;
1628:
1629: */
1630: -- In case of an error, we will roll back to this point in time.

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

1714:
1715: g_no_rows := NVL(SQL%ROWCOUNT,0);
1716:
1717: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1718: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1719: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1720: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1721:
1722: FND_LOG.String (fnd_log.level_procedure,

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

1715: g_no_rows := NVL(SQL%ROWCOUNT,0);
1716:
1717: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1718: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1719: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1720: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1721:
1722: FND_LOG.String (fnd_log.level_procedure,
1723: g_pkg_name || '.' || l_api_name,

Line 1720: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');

1716:
1717: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1718: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1719: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1720: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1721:
1722: FND_LOG.String (fnd_log.level_procedure,
1723: g_pkg_name || '.' || l_api_name,
1724: 'SHRD0117: '||FND_MESSAGE.get);

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

1720: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1721:
1722: FND_LOG.String (fnd_log.level_procedure,
1723: g_pkg_name || '.' || l_api_name,
1724: 'SHRD0117: '||FND_MESSAGE.get);
1725: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1726: END IF;
1727:
1728:

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

1721:
1722: FND_LOG.String (fnd_log.level_procedure,
1723: g_pkg_name || '.' || l_api_name,
1724: 'SHRD0117: '||FND_MESSAGE.get);
1725: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1726: END IF;
1727:
1728:
1729:

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

1930:
1931: g_no_rows := SQL%ROWCOUNT;
1932:
1933: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1934: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1935: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1936: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
1937:
1938:

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

1931: g_no_rows := SQL%ROWCOUNT;
1932:
1933: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1934: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1935: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1936: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
1937:
1938:
1939: FND_LOG.String (fnd_log.level_procedure,

Line 1936: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');

1932:
1933: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1934: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1935: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1936: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
1937:
1938:
1939: FND_LOG.String (fnd_log.level_procedure,
1940: g_pkg_name || '.' || l_api_name,

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

1937:
1938:
1939: FND_LOG.String (fnd_log.level_procedure,
1940: g_pkg_name || '.' || l_api_name,
1941: 'SHRD0117: '||FND_MESSAGE.get);
1942: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1943: END IF;
1944:
1945: ELSIF (x_corp_rate = 1) THEN

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

1938:
1939: FND_LOG.String (fnd_log.level_procedure,
1940: g_pkg_name || '.' || l_api_name,
1941: 'SHRD0117: '||FND_MESSAGE.get);
1942: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
1943: END IF;
1944:
1945: ELSIF (x_corp_rate = 1) THEN
1946: -- If the conversion rate is not available then there is no need to

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

1995:
1996: g_no_rows := SQL%ROWCOUNT;
1997:
1998: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1999: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2000: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2001: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2002:
2003:

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

1996: g_no_rows := SQL%ROWCOUNT;
1997:
1998: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1999: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2000: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2001: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2002:
2003:
2004: FND_LOG.String (fnd_log.level_procedure,

Line 2001: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');

1997:
1998: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1999: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2000: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2001: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2002:
2003:
2004: FND_LOG.String (fnd_log.level_procedure,
2005: g_pkg_name || '.' || l_api_name,

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

2002:
2003:
2004: FND_LOG.String (fnd_log.level_procedure,
2005: g_pkg_name || '.' || l_api_name,
2006: 'SHRD0117: '||FND_MESSAGE.get);
2007: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
2008: END IF;
2009:
2010:

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

2003:
2004: FND_LOG.String (fnd_log.level_procedure,
2005: g_pkg_name || '.' || l_api_name,
2006: 'SHRD0117: '||FND_MESSAGE.get);
2007: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
2008: END IF;
2009:
2010:
2011: END IF;

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

2070:
2071: g_no_rows := SQL%ROWCOUNT;
2072:
2073: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2074: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2075: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2076: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2077:
2078:

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

2071: g_no_rows := SQL%ROWCOUNT;
2072:
2073: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2074: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2075: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2076: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2077:
2078:
2079: FND_LOG.String (fnd_log.level_procedure,

Line 2076: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');

2072:
2073: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2074: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2075: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2076: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2077:
2078:
2079: FND_LOG.String (fnd_log.level_procedure,
2080: g_pkg_name || '.' || l_api_name,

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

2077:
2078:
2079: FND_LOG.String (fnd_log.level_procedure,
2080: g_pkg_name || '.' || l_api_name,
2081: 'SHRD0117: '||FND_MESSAGE.get);
2082: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
2083: END IF;
2084:
2085:

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

2078:
2079: FND_LOG.String (fnd_log.level_procedure,
2080: g_pkg_name || '.' || l_api_name,
2081: 'SHRD0117: '||FND_MESSAGE.get);
2082: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
2083: END IF;
2084:
2085:
2086: END;

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

2149:
2150: g_no_rows := SQL%ROWCOUNT;
2151:
2152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2153: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2154: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2156:
2157:

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

2150: g_no_rows := SQL%ROWCOUNT;
2151:
2152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2153: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2154: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2156:
2157:
2158: FND_LOG.String (fnd_log.level_procedure,

Line 2155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');

2151:
2152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2153: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2154: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2156:
2157:
2158: FND_LOG.String (fnd_log.level_procedure,
2159: g_pkg_name || '.' || l_api_name,

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

2156:
2157:
2158: FND_LOG.String (fnd_log.level_procedure,
2159: g_pkg_name || '.' || l_api_name,
2160: 'SHRD0117: '||FND_MESSAGE.get);
2161: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
2162: END IF;
2163:
2164:

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

2157:
2158: FND_LOG.String (fnd_log.level_procedure,
2159: g_pkg_name || '.' || l_api_name,
2160: 'SHRD0117: '||FND_MESSAGE.get);
2161: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
2162: END IF;
2163:
2164:
2165: -- Insert elimination entry headers into GCS_ENTRY_HEADERS.

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

2212:
2213: g_no_rows := SQL%ROWCOUNT;
2214:
2215: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2216: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2217: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2218: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2219:
2220:

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

2213: g_no_rows := SQL%ROWCOUNT;
2214:
2215: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2216: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2217: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2218: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2219:
2220:
2221: FND_LOG.String (fnd_log.level_procedure,

Line 2218: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');

2214:
2215: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2216: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2217: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2218: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2219:
2220:
2221: FND_LOG.String (fnd_log.level_procedure,
2222: g_pkg_name || '.' || l_api_name,

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

2219:
2220:
2221: FND_LOG.String (fnd_log.level_procedure,
2222: g_pkg_name || '.' || l_api_name,
2223: 'SHRD0117: '||FND_MESSAGE.get);
2224: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
2225: END IF;
2226:
2227: -- Fix Bug #3682104

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

2220:
2221: FND_LOG.String (fnd_log.level_procedure,
2222: g_pkg_name || '.' || l_api_name,
2223: 'SHRD0117: '||FND_MESSAGE.get);
2224: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
2225: END IF;
2226:
2227: -- Fix Bug #3682104
2228:

Line 2252: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');

2248:
2249: g_no_rows := NVL(SQL%ROWCOUNT,0);
2250:
2251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2252: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');
2253: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2254: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2255:
2256:

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

2249: g_no_rows := NVL(SQL%ROWCOUNT,0);
2250:
2251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2252: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');
2253: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2254: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2255:
2256:
2257: FND_LOG.String (fnd_log.level_procedure,

Line 2254: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');

2250:
2251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2252: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');
2253: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2254: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2255:
2256:
2257: FND_LOG.String (fnd_log.level_procedure,
2258: g_pkg_name || '.' || l_api_name,

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

2255:
2256:
2257: FND_LOG.String (fnd_log.level_procedure,
2258: g_pkg_name || '.' || l_api_name,
2259: 'SHRD0117: '||FND_MESSAGE.get);
2260: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0119: '||FND_MESSAGE.get);
2261: END IF;
2262:
2263:

Line 2260: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0119: '||FND_MESSAGE.get);

2256:
2257: FND_LOG.String (fnd_log.level_procedure,
2258: g_pkg_name || '.' || l_api_name,
2259: 'SHRD0117: '||FND_MESSAGE.get);
2260: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0119: '||FND_MESSAGE.get);
2261: END IF;
2262:
2263:
2264:

Line 2290: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');

2286:
2287: g_no_rows := NVL(SQL%ROWCOUNT,0);
2288:
2289: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2290: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');
2291: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2292: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
2293:
2294:

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

2287: g_no_rows := NVL(SQL%ROWCOUNT,0);
2288:
2289: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2290: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');
2291: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2292: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
2293:
2294:
2295: FND_LOG.String (fnd_log.level_procedure,

Line 2292: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');

2288:
2289: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2290: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');
2291: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2292: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
2293:
2294:
2295: FND_LOG.String (fnd_log.level_procedure,
2296: g_pkg_name || '.' || l_api_name,

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

2293:
2294:
2295: FND_LOG.String (fnd_log.level_procedure,
2296: g_pkg_name || '.' || l_api_name,
2297: 'SHRD0117: '||FND_MESSAGE.get);
2298: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0119: '||FND_MESSAGE.get);
2299: END IF;
2300:
2301:

Line 2298: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0119: '||FND_MESSAGE.get);

2294:
2295: FND_LOG.String (fnd_log.level_procedure,
2296: g_pkg_name || '.' || l_api_name,
2297: 'SHRD0117: '||FND_MESSAGE.get);
2298: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0119: '||FND_MESSAGE.get);
2299: END IF;
2300:
2301:
2302: g_no_rows := 0;

Line 2365: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');

2361:
2362: g_no_rows := NVL(SQL%ROWCOUNT,0);
2363:
2364: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2365: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');
2366: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2367: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
2368:
2369:

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

2362: g_no_rows := NVL(SQL%ROWCOUNT,0);
2363:
2364: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2365: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');
2366: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2367: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
2368:
2369:
2370: FND_LOG.String (fnd_log.level_procedure,

Line 2367: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');

2363:
2364: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2365: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');
2366: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2367: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
2368:
2369:
2370: FND_LOG.String (fnd_log.level_procedure,
2371: g_pkg_name || '.' || l_api_name,

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

2368:
2369:
2370: FND_LOG.String (fnd_log.level_procedure,
2371: g_pkg_name || '.' || l_api_name,
2372: 'SHRD0117: '||FND_MESSAGE.get);
2373: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0118: '||FND_MESSAGE.get);
2374: END IF;
2375:
2376: -----##########-----

Line 2373: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0118: '||FND_MESSAGE.get);

2369:
2370: FND_LOG.String (fnd_log.level_procedure,
2371: g_pkg_name || '.' || l_api_name,
2372: 'SHRD0117: '||FND_MESSAGE.get);
2373: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0118: '||FND_MESSAGE.get);
2374: END IF;
2375:
2376: -----##########-----
2377:

Line 2418: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');

2414:
2415: g_no_rows := NVL(SQL%ROWCOUNT,0);
2416:
2417: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2418: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');
2419: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2420: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
2421:
2422:

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

2415: g_no_rows := NVL(SQL%ROWCOUNT,0);
2416:
2417: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2418: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');
2419: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2420: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
2421:
2422:
2423: FND_LOG.String (fnd_log.level_procedure,

Line 2420: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');

2416:
2417: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2418: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');
2419: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2420: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
2421:
2422:
2423: FND_LOG.String (fnd_log.level_procedure,
2424: g_pkg_name || '.' || l_api_name,

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

2421:
2422:
2423: FND_LOG.String (fnd_log.level_procedure,
2424: g_pkg_name || '.' || l_api_name,
2425: 'SHRD0117: '||FND_MESSAGE.get);
2426: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0118: '||FND_MESSAGE.get);
2427: END IF;
2428:
2429:

Line 2426: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0118: '||FND_MESSAGE.get);

2422:
2423: FND_LOG.String (fnd_log.level_procedure,
2424: g_pkg_name || '.' || l_api_name,
2425: 'SHRD0117: '||FND_MESSAGE.get);
2426: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0118: '||FND_MESSAGE.get);
2427: END IF;
2428:
2429:
2430: -- Consolidation engine requires x_errbuf being returnrd as 'WARNING'