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.OKC_XPRT_IMPORT_VARIABLES_PVT dependencies on FND_LOG

Line 15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

11: ------------------------------------------------------------------------------
12: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_XPRT_IMPORT_VARIABLES_PVT';
13: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
14:
15: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
16: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
17: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
18:
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

Line 75: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

71:
72: BEGIN
73:
74: -- start debug log
75: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
77: G_MODULE||l_api_name,
78: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
79: END IF;

Line 76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

72: BEGIN
73:
74: -- start debug log
75: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
77: G_MODULE||l_api_name,
78: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
79: END IF;
80:

Line 207: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

203: -- Standard call to get message count and if count is 1, get message info.
204: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
205:
206: -- end debug log
207: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
209: G_MODULE||l_api_name,
210: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
211: END IF;

Line 208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

204: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
205:
206: -- end debug log
207: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
209: G_MODULE||l_api_name,
210: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
211: END IF;
212:

Line 216: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

212:
213:
214: EXCEPTION
215: WHEN OTHERS THEN
216: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
217: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
218: G_MODULE||l_api_name,
219: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
220: END IF;

Line 217: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

213:
214: EXCEPTION
215: WHEN OTHERS THEN
216: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
217: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
218: G_MODULE||l_api_name,
219: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
220: END IF;
221:

Line 264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

260:
261: BEGIN
262:
263: -- start debug log
264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
266: G_MODULE||l_api_name,
267: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
268: END IF;

Line 265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

261: BEGIN
262:
263: -- start debug log
264: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
265: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
266: G_MODULE||l_api_name,
267: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
268: END IF;
269:

Line 632: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

628: -- Standard call to get message count and if count is 1, get message info.
629: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
630:
631: -- end debug log
632: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
633: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
634: G_MODULE||l_api_name,
635: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
636: END IF;

Line 633: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

629: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
630:
631: -- end debug log
632: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
633: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
634: G_MODULE||l_api_name,
635: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
636: END IF;
637:

Line 641: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

637:
638:
639: EXCEPTION
640: WHEN OTHERS THEN
641: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
642: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
643: G_MODULE||l_api_name,
644: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
645: END IF;

Line 642: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

638:
639: EXCEPTION
640: WHEN OTHERS THEN
641: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
642: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
643: G_MODULE||l_api_name,
644: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
645: END IF;
646:

Line 780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

776:
777: BEGIN
778:
779: -- start debug log
780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
782: G_MODULE||l_api_name,
783: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
784: END IF;

Line 781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

777: BEGIN
778:
779: -- start debug log
780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
782: G_MODULE||l_api_name,
783: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
784: END IF;
785:

Line 1094: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1090: -- Standard call to get message count and if count is 1, get message info.
1091: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1092:
1093: -- end debug log
1094: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1095: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1096: G_MODULE||l_api_name,
1097: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1098: END IF;

Line 1095: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1091: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1092:
1093: -- end debug log
1094: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1095: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1096: G_MODULE||l_api_name,
1097: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1098: END IF;
1099:

Line 1103: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1099:
1100:
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1105: G_MODULE||l_api_name,
1106: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1107: END IF;

Line 1104: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1100:
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1105: G_MODULE||l_api_name,
1106: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1107: END IF;
1108:

Line 1180: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1176:
1177: BEGIN
1178:
1179: -- start debug log
1180: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1182: G_MODULE||l_api_name,
1183: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1184: END IF;

Line 1181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1177: BEGIN
1178:
1179: -- start debug log
1180: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1182: G_MODULE||l_api_name,
1183: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1184: END IF;
1185:

Line 1481: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1477: -- Standard call to get message count and if count is 1, get message info.
1478: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1479:
1480: -- end debug log
1481: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1482: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1483: G_MODULE||l_api_name,
1484: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1485: END IF;

Line 1482: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1478: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1479:
1480: -- end debug log
1481: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1482: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1483: G_MODULE||l_api_name,
1484: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1485: END IF;
1486:

Line 1490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1486:
1487:
1488: EXCEPTION
1489: WHEN OTHERS THEN
1490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1492: G_MODULE||l_api_name,
1493: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1494: END IF;

Line 1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1487:
1488: EXCEPTION
1489: WHEN OTHERS THEN
1490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1492: G_MODULE||l_api_name,
1493: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1494: END IF;
1495:

Line 1565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1561:
1562: BEGIN
1563:
1564: -- start debug log
1565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1567: G_MODULE||l_api_name,
1568: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1562: BEGIN
1563:
1564: -- start debug log
1565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1567: G_MODULE||l_api_name,
1568: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1570: G_MODULE||l_api_name,

Line 1569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1567: G_MODULE||l_api_name,
1568: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1570: G_MODULE||l_api_name,
1571: '100: Parameters ');
1572: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1573: G_MODULE||l_api_name,

Line 1572: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1568: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1570: G_MODULE||l_api_name,
1571: '100: Parameters ');
1572: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1573: G_MODULE||l_api_name,
1574: '100: p_org_id '||p_org_id);
1575: END IF;
1576:

Line 1622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1618: FETCH csr_cz_run_id INTO G_RUN_ID;
1619: CLOSE csr_cz_run_id;
1620:
1621: -- debug log
1622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1624: G_MODULE||l_api_name,
1625: '150: Run Id :'||G_RUN_ID);
1626: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1619: CLOSE csr_cz_run_id;
1620:
1621: -- debug log
1622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1624: G_MODULE||l_api_name,
1625: '150: Run Id :'||G_RUN_ID);
1626: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1627: G_MODULE||l_api_name,

Line 1626: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1624: G_MODULE||l_api_name,
1625: '150: Run Id :'||G_RUN_ID);
1626: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1627: G_MODULE||l_api_name,
1628: '150: Variable Model Id :'||l_variable_model_id);
1629: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1630: G_MODULE||l_api_name,

Line 1629: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1625: '150: Run Id :'||G_RUN_ID);
1626: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1627: G_MODULE||l_api_name,
1628: '150: Variable Model Id :'||l_variable_model_id);
1629: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1630: G_MODULE||l_api_name,
1631: '150: Intent :'||l_intent);
1632: END IF;
1633:

Line 1644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1640: x_msg_count => x_msg_count
1641: );
1642:
1643: -- debug log
1644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1646: G_MODULE||l_api_name,
1647: '200: After Calling create_variable_model x_return_status : '||x_return_status);
1648: END IF;

Line 1645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1641: );
1642:
1643: -- debug log
1644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1646: G_MODULE||l_api_name,
1647: '200: After Calling create_variable_model x_return_status : '||x_return_status);
1648: END IF;
1649:

Line 1666: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1662: x_msg_count => x_msg_count
1663: );
1664:
1665: -- debug log
1666: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1667: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1668: G_MODULE||l_api_name,
1669: '300: After Calling create_variable_component x_return_status : '||x_return_status);
1670: END IF;

Line 1667: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1663: );
1664:
1665: -- debug log
1666: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1667: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1668: G_MODULE||l_api_name,
1669: '300: After Calling create_variable_component x_return_status : '||x_return_status);
1670: END IF;
1671:

Line 1688: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1684: x_msg_count => x_msg_count
1685: );
1686:
1687: -- debug log
1688: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1689: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1690: G_MODULE||l_api_name,
1691: '400: After Calling create_variable_feature x_return_status : '||x_return_status);
1692: END IF;

Line 1689: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1685: );
1686:
1687: -- debug log
1688: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1689: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1690: G_MODULE||l_api_name,
1691: '400: After Calling create_variable_feature x_return_status : '||x_return_status);
1692: END IF;
1693:

Line 1710: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1706: x_msg_count => x_msg_count
1707: );
1708:
1709: -- debug log
1710: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1712: G_MODULE||l_api_name,
1713: '500: After Calling create_variable_options x_return_status : '||x_return_status);
1714: END IF;

Line 1711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1707: );
1708:
1709: -- debug log
1710: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1711: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1712: G_MODULE||l_api_name,
1713: '500: After Calling create_variable_options x_return_status : '||x_return_status);
1714: END IF;
1715:

Line 1728: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1724: -- END LOOP;
1725: --CLOSE csr_intent;
1726:
1727: -- debug log
1728: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1729: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1730: G_MODULE||l_api_name,
1731: '550: Calling OKC_XPRT_CZ_INT_PVT.import_generic ');
1732: END IF;

Line 1729: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1725: --CLOSE csr_intent;
1726:
1727: -- debug log
1728: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1729: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1730: G_MODULE||l_api_name,
1731: '550: Calling OKC_XPRT_CZ_INT_PVT.import_generic ');
1732: END IF;
1733:

Line 1747: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1743: x_msg_count => x_msg_count
1744: );
1745:
1746: -- debug log
1747: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1748: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1749: G_MODULE||l_api_name,
1750: '600: After Calling OKC_XPRT_CZ_INT_PVT.import_generic x_return_status : '||
1751: l_import_status);

Line 1748: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1744: );
1745:
1746: -- debug log
1747: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1748: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1749: G_MODULE||l_api_name,
1750: '600: After Calling OKC_XPRT_CZ_INT_PVT.import_generic x_return_status : '||
1751: l_import_status);
1752: END IF;

Line 1766: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1762: x_msg_count => x_msg_count
1763: );
1764:
1765: -- debug log
1766: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1767: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1768: G_MODULE||l_api_name,
1769: '700: After Calling OKC_XPRT_UTIL_PVT.check_import_status x_return_status : '||
1770: x_return_status);

Line 1767: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1763: );
1764:
1765: -- debug log
1766: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1767: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1768: G_MODULE||l_api_name,
1769: '700: After Calling OKC_XPRT_UTIL_PVT.check_import_status x_return_status : '||
1770: x_return_status);
1771: END IF;

Line 1792: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1788: -- Standard call to get message count and if count is 1, get message info.
1789: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1790:
1791: -- end debug log
1792: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1794: G_MODULE||l_api_name,
1795: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1796: END IF;

Line 1793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1789: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1790:
1791: -- end debug log
1792: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1794: G_MODULE||l_api_name,
1795: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1796: END IF;
1797:

Line 1800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1796: END IF;
1797:
1798: EXCEPTION
1799: WHEN FND_API.G_EXC_ERROR THEN
1800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1801: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1802: G_MODULE||l_api_name,
1803: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1804: END IF;

Line 1801: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1797:
1798: EXCEPTION
1799: WHEN FND_API.G_EXC_ERROR THEN
1800: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1801: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1802: G_MODULE||l_api_name,
1803: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1804: END IF;
1805:

Line 1810: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1806: x_return_status := G_RET_STS_ERROR ;
1807: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1808:
1809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1810: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1811: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1812: G_MODULE||l_api_name,
1813: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1814: END IF;

Line 1811: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1807: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1808:
1809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1810: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1811: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1812: G_MODULE||l_api_name,
1813: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1814: END IF;
1815:

Line 1820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1816: x_return_status := G_RET_STS_UNEXP_ERROR ;
1817: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1818:
1819: WHEN OTHERS THEN
1820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1821: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1822: G_MODULE||l_api_name,
1823: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1824: END IF;

Line 1821: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1817: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1818:
1819: WHEN OTHERS THEN
1820: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1821: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1822: G_MODULE||l_api_name,
1823: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1824: END IF;
1825: