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_TEMPLATE_PVT dependencies on FND_LOG

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

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

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

92:
93: BEGIN
94:
95: -- start debug log
96: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
97: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
98: G_MODULE||l_api_name,
99: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
100: END IF;

Line 97: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

93: BEGIN
94:
95: -- start debug log
96: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
97: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
98: G_MODULE||l_api_name,
99: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
100: END IF;
101:

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

230: -- Standard call to get message count and if count is 1, get message info.
231: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
232:
233: -- end debug log
234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
236: G_MODULE||l_api_name,
237: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
238: END IF;

Line 235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

231: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
232:
233: -- end debug log
234: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
235: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
236: G_MODULE||l_api_name,
237: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
238: END IF;
239:

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

238: END IF;
239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
244: G_MODULE||l_api_name,
245: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
246: END IF;

Line 243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
244: G_MODULE||l_api_name,
245: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
246: END IF;
247:

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

293:
294: BEGIN
295:
296: -- start debug log
297: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
299: G_MODULE||l_api_name,
300: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
301: END IF;

Line 298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

294: BEGIN
295:
296: -- start debug log
297: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
299: G_MODULE||l_api_name,
300: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
301: END IF;
302:

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

670:
671:
672:
673: -- end debug log
674: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
676: G_MODULE||l_api_name,
677: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
678: END IF;

Line 675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

671:
672:
673: -- end debug log
674: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
676: G_MODULE||l_api_name,
677: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
678: END IF;
679:

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

678: END IF;
679:
680: EXCEPTION
681: WHEN OTHERS THEN
682: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
683: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
684: G_MODULE||l_api_name,
685: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
686: END IF;

Line 683: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

679:
680: EXCEPTION
681: WHEN OTHERS THEN
682: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
683: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
684: G_MODULE||l_api_name,
685: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
686: END IF;
687:

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

825:
826: BEGIN
827:
828: -- start debug log
829: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
830: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
831: G_MODULE||l_api_name,
832: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
833: END IF;

Line 830: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

826: BEGIN
827:
828: -- start debug log
829: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
830: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
831: G_MODULE||l_api_name,
832: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
833: END IF;
834:

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

1235: */
1236: IF l_feature_type = 0 THEN
1237:
1238: -- debug log
1239: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1240: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1241: G_MODULE||l_api_name,
1242: '500: Creating Options For Question Id '||l_question_id);
1243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1240: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1236: IF l_feature_type = 0 THEN
1237:
1238: -- debug log
1239: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1240: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1241: G_MODULE||l_api_name,
1242: '500: Creating Options For Question Id '||l_question_id);
1243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1244: G_MODULE||l_api_name,

Line 1243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1239: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1240: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1241: G_MODULE||l_api_name,
1242: '500: Creating Options For Question Id '||l_question_id);
1243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1244: G_MODULE||l_api_name,
1245: '500: Value Set Name '||l_value_set_name);
1246: END IF;
1247:

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

1268: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1269:
1270:
1271: -- end debug log
1272: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1273: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1274: G_MODULE||l_api_name,
1275: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1276: END IF;

Line 1273: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1269:
1270:
1271: -- end debug log
1272: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1273: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1274: G_MODULE||l_api_name,
1275: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1276: END IF;
1277:

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

1276: END IF;
1277:
1278: EXCEPTION
1279: WHEN OTHERS THEN
1280: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1282: G_MODULE||l_api_name,
1283: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1284: END IF;

Line 1281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1277:
1278: EXCEPTION
1279: WHEN OTHERS THEN
1280: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1282: G_MODULE||l_api_name,
1283: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1284: END IF;
1285:

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

1396:
1397: BEGIN
1398:
1399: -- start debug log
1400: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1401: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1402: G_MODULE||l_api_name,
1403: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1404: END IF;

Line 1401: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1397: BEGIN
1398:
1399: -- start debug log
1400: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1401: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1402: G_MODULE||l_api_name,
1403: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1404: END IF;
1405:

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

1409: OPEN csr_value_set_type;
1410: FETCH csr_value_set_type INTO l_valueset_type;
1411: CLOSE csr_value_set_type;
1412:
1413: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1414: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1415: G_MODULE||l_api_name,
1416: '101: ValueSet Id : '||p_value_set_id);
1417: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1414: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1410: FETCH csr_value_set_type INTO l_valueset_type;
1411: CLOSE csr_value_set_type;
1412:
1413: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1414: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1415: G_MODULE||l_api_name,
1416: '101: ValueSet Id : '||p_value_set_id);
1417: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1418: G_MODULE||l_api_name,

Line 1417: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1413: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1414: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1415: G_MODULE||l_api_name,
1416: '101: ValueSet Id : '||p_value_set_id);
1417: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1418: G_MODULE||l_api_name,
1419: '101: Valueset Type : '||l_valueset_type);
1420: END IF;
1421:

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

1434: l_additional_where_clause ;
1435:
1436: l_sequence_sql_stmt := 'SELECT rownum FROM ( '||l_sql_stmt||' )' ;
1437:
1438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1440: G_MODULE||l_api_name,
1441: '150: l_table_name '||l_table_name);
1442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1435:
1436: l_sequence_sql_stmt := 'SELECT rownum FROM ( '||l_sql_stmt||' )' ;
1437:
1438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1440: G_MODULE||l_api_name,
1441: '150: l_table_name '||l_table_name);
1442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1443: G_MODULE||l_api_name,

Line 1442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1440: G_MODULE||l_api_name,
1441: '150: l_table_name '||l_table_name);
1442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1443: G_MODULE||l_api_name,
1444: '150: l_name_col '||l_name_col);
1445: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1446: G_MODULE||l_api_name,

Line 1445: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1441: '150: l_table_name '||l_table_name);
1442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1443: G_MODULE||l_api_name,
1444: '150: l_name_col '||l_name_col);
1445: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1446: G_MODULE||l_api_name,
1447: '150: l_id_col '||l_id_col);
1448: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1449: G_MODULE||l_api_name,

Line 1448: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1444: '150: l_name_col '||l_name_col);
1445: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1446: G_MODULE||l_api_name,
1447: '150: l_id_col '||l_id_col);
1448: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1449: G_MODULE||l_api_name,
1450: '150: l_additional_where_clause '||l_additional_where_clause);
1451: END IF;
1452:

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

1483: l_error_message := FND_MESSAGE.get;
1484: -- Write to Concurrent Log File
1485: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1486: -- Write to Debug Log
1487: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1488: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1489: G_MODULE||l_api_name,
1490: '110: Error In Value Set Dynamic Sql for Question : '||l_question_name);
1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1488: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1484: -- Write to Concurrent Log File
1485: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1486: -- Write to Debug Log
1487: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1488: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1489: G_MODULE||l_api_name,
1490: '110: Error In Value Set Dynamic Sql for Question : '||l_question_name);
1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1492: G_MODULE||l_api_name,

Line 1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1487: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1488: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1489: G_MODULE||l_api_name,
1490: '110: Error In Value Set Dynamic Sql for Question : '||l_question_name);
1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1492: G_MODULE||l_api_name,
1493: '110: Error Message : ' ||l_error_message);
1494: END IF;
1495: -- Raise Error Exception

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

1528: l_error_message := FND_MESSAGE.get;
1529: -- Write to Concurrent Log File
1530: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1531: -- Write to Debug Log
1532: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1533: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1534: G_MODULE||l_api_name,
1535: '110: Error In ValueSet Sql for Question Sequence: '||l_question_name);
1536: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1533: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1529: -- Write to Concurrent Log File
1530: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1531: -- Write to Debug Log
1532: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1533: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1534: G_MODULE||l_api_name,
1535: '110: Error In ValueSet Sql for Question Sequence: '||l_question_name);
1536: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1537: G_MODULE||l_api_name,

Line 1536: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1532: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1533: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1534: G_MODULE||l_api_name,
1535: '110: Error In ValueSet Sql for Question Sequence: '||l_question_name);
1536: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1537: G_MODULE||l_api_name,
1538: '110: Error Message : ' ||l_error_message);
1539: END IF;
1540: -- Raise Error Exception

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

1561: l_error_message := FND_MESSAGE.get;
1562: -- Write to Concurrent Log File
1563: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1564: -- Write to 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: '110: No Values defined for ValueSet in Question : '||l_question_name);
1569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1562: -- Write to Concurrent Log File
1563: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1564: -- Write to 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: '110: No Values defined for ValueSet in Question : '||l_question_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: '110: No Values defined for ValueSet in Question : '||l_question_name);
1569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1570: G_MODULE||l_api_name,
1571: '110: Error Message : ' ||l_error_message);
1572: END IF;
1573: -- Raise Error Exception

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

1589: l_error_message := FND_MESSAGE.get;
1590: -- Write to Concurrent Log File
1591: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1592: -- Write to Debug Log
1593: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1594: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1595: G_MODULE||l_api_name,
1596: '110: No Values defined for ValueSet in Question : '||l_question_name);
1597: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1594: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1590: -- Write to Concurrent Log File
1591: fnd_file.put_line(FND_FILE.LOG,l_error_message);
1592: -- Write to Debug Log
1593: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1594: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1595: G_MODULE||l_api_name,
1596: '110: No Values defined for ValueSet in Question : '||l_question_name);
1597: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1598: G_MODULE||l_api_name,

Line 1597: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1593: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1594: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1595: G_MODULE||l_api_name,
1596: '110: No Values defined for ValueSet in Question : '||l_question_name);
1597: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1598: G_MODULE||l_api_name,
1599: '110: Error Message : ' ||l_error_message);
1600: END IF;
1601: -- Raise Error Exception

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

1898: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1899:
1900:
1901: -- end debug log
1902: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1903: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1904: G_MODULE||l_api_name,
1905: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1906: END IF;

Line 1903: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1899:
1900:
1901: -- end debug log
1902: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1903: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1904: G_MODULE||l_api_name,
1905: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1906: END IF;
1907:

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

1906: END IF;
1907:
1908: EXCEPTION
1909: WHEN FND_API.G_EXC_ERROR THEN
1910: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1911: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1912: G_MODULE||l_api_name,
1913: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1914: END IF;

Line 1911: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1907:
1908: EXCEPTION
1909: WHEN FND_API.G_EXC_ERROR THEN
1910: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1911: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1912: G_MODULE||l_api_name,
1913: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1914: END IF;
1915:

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

1916: x_return_status := G_RET_STS_ERROR ;
1917: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1918:
1919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1920: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1922: G_MODULE||l_api_name,
1923: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1924: END IF;

Line 1921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1917: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1918:
1919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1920: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1922: G_MODULE||l_api_name,
1923: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1924: END IF;
1925:

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

1926: x_return_status := G_RET_STS_UNEXP_ERROR ;
1927: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1928:
1929: WHEN OTHERS THEN
1930: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1931: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1932: G_MODULE||l_api_name,
1933: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1934: END IF;

Line 1931: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1927: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1928:
1929: WHEN OTHERS THEN
1930: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1931: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1932: G_MODULE||l_api_name,
1933: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1934: END IF;
1935:

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

1979:
1980: BEGIN
1981:
1982: -- start debug log
1983: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1984: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1985: G_MODULE||l_api_name,
1986: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1987: END IF;

Line 1984: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1980: BEGIN
1981:
1982: -- start debug log
1983: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1984: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1985: G_MODULE||l_api_name,
1986: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1987: END IF;
1988:

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

2364: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2365:
2366:
2367: -- end debug log
2368: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2369: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2370: G_MODULE||l_api_name,
2371: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2372: END IF;

Line 2369: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2365:
2366:
2367: -- end debug log
2368: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2369: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2370: G_MODULE||l_api_name,
2371: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2372: END IF;
2373:

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

2372: END IF;
2373:
2374: EXCEPTION
2375: WHEN OTHERS THEN
2376: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2377: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2378: G_MODULE||l_api_name,
2379: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2380: END IF;

Line 2377: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2373:
2374: EXCEPTION
2375: WHEN OTHERS THEN
2376: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2377: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2378: G_MODULE||l_api_name,
2379: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2380: END IF;
2381:

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

2476:
2477: BEGIN
2478:
2479: -- start debug log
2480: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2482: G_MODULE||l_api_name,
2483: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2477: BEGIN
2478:
2479: -- start debug log
2480: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2482: G_MODULE||l_api_name,
2483: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2485: G_MODULE||l_api_name,

Line 2484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2480: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2482: G_MODULE||l_api_name,
2483: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2485: G_MODULE||l_api_name,
2486: '100: Parameters ');
2487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2488: G_MODULE||l_api_name,

Line 2487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2483: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2485: G_MODULE||l_api_name,
2486: '100: Parameters ');
2487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2488: G_MODULE||l_api_name,
2489: '100: p_template_id '||p_template_id);
2490: END IF;
2491:

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

2511: l_org_id;
2512:
2513: IF csr_template_dtls%NOTFOUND THEN
2514: -- Log Error
2515: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2517: G_MODULE||l_api_name,
2518: '110: Invalid Template Id: '||p_template_id);
2519: END IF;

Line 2516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2512:
2513: IF csr_template_dtls%NOTFOUND THEN
2514: -- Log Error
2515: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2517: G_MODULE||l_api_name,
2518: '110: Invalid Template Id: '||p_template_id);
2519: END IF;
2520: FND_MESSAGE.set_name('OKC','OKC_XPRT_INVALID_TEMPLATE');

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

2536: last_updated_by = FND_GLOBAL.USER_ID
2537: WHERE template_id = p_template_id;
2538:
2539: -- debug log
2540: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2541: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2542: G_MODULE||l_api_name,
2543: '110: Calling populate_questions_order');
2544: END IF;

Line 2541: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2537: WHERE template_id = p_template_id;
2538:
2539: -- debug log
2540: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2541: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2542: G_MODULE||l_api_name,
2543: '110: Calling populate_questions_order');
2544: END IF;
2545:

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

2556: x_msg_count => x_msg_count
2557: );
2558:
2559: -- debug log
2560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2561: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2562: G_MODULE||l_api_name,
2563: '111: After Calling populate_questions_order x_return_status : '||x_return_status);
2564: END IF;

Line 2561: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2557: );
2558:
2559: -- debug log
2560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2561: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2562: G_MODULE||l_api_name,
2563: '111: After Calling populate_questions_order x_return_status : '||x_return_status);
2564: END IF;
2565:

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

2600: x_msg_count => x_msg_count,
2601: x_msg_data => x_msg_data);
2602:
2603: -- debug log
2604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2606: G_MODULE||l_api_name,
2607: '111: After Calling OKC_XPRT_CZ_INT_PVT.create_rp_folder x_return_status : '||x_return_status);
2608: END IF;

Line 2605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2601: x_msg_data => x_msg_data);
2602:
2603: -- debug log
2604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2606: G_MODULE||l_api_name,
2607: '111: After Calling OKC_XPRT_CZ_INT_PVT.create_rp_folder x_return_status : '||x_return_status);
2608: END IF;
2609:

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

2616:
2617: END IF; -- folder does not exists
2618: CLOSE csr_template_folder;
2619:
2620: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2621: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2622: G_MODULE||l_api_name,
2623: '120: Template Folder Id: '||l_template_folder_id);
2624: END IF;

Line 2621: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2617: END IF; -- folder does not exists
2618: CLOSE csr_template_folder;
2619:
2620: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2621: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2622: G_MODULE||l_api_name,
2623: '120: Template Folder Id: '||l_template_folder_id);
2624: END IF;
2625:

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

2645: FETCH csr_template_model_id INTO l_template_model_id;
2646: CLOSE csr_template_model_id;
2647:
2648: -- debug log
2649: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2651: G_MODULE||l_api_name,
2652: '150: Run Id :'||G_RUN_ID);
2653: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2646: CLOSE csr_template_model_id;
2647:
2648: -- debug log
2649: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2651: G_MODULE||l_api_name,
2652: '150: Run Id :'||G_RUN_ID);
2653: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2654: G_MODULE||l_api_name,

Line 2653: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2649: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2651: G_MODULE||l_api_name,
2652: '150: Run Id :'||G_RUN_ID);
2653: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2654: G_MODULE||l_api_name,
2655: '150: Template Name: '||l_template_name);
2656: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2657: G_MODULE||l_api_name,

Line 2656: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2652: '150: Run Id :'||G_RUN_ID);
2653: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2654: G_MODULE||l_api_name,
2655: '150: Template Name: '||l_template_name);
2656: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2657: G_MODULE||l_api_name,
2658: '150: Derived Template Id: '||l_template_id);
2659: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2660: G_MODULE||l_api_name,

Line 2659: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2655: '150: Template Name: '||l_template_name);
2656: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2657: G_MODULE||l_api_name,
2658: '150: Derived Template Id: '||l_template_id);
2659: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2660: G_MODULE||l_api_name,
2661: '150: Template Model Id :'||l_template_model_id);
2662: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2663: G_MODULE||l_api_name,

Line 2662: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2658: '150: Derived Template Id: '||l_template_id);
2659: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2660: G_MODULE||l_api_name,
2661: '150: Template Model Id :'||l_template_model_id);
2662: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2663: G_MODULE||l_api_name,
2664: '150: Intent :'||l_intent);
2665: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2666: G_MODULE||l_api_name,

Line 2665: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2661: '150: Template Model Id :'||l_template_model_id);
2662: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2663: G_MODULE||l_api_name,
2664: '150: Intent :'||l_intent);
2665: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2666: G_MODULE||l_api_name,
2667: '150: Organization Name :'||G_ORGANIZATION_NAME);
2668: END IF;
2669:

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

2680: x_msg_count => x_msg_count
2681: );
2682:
2683: -- debug log
2684: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2686: G_MODULE||l_api_name,
2687: '200: After Calling create_template_model x_return_status : '||x_return_status);
2688: END IF;

Line 2685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2681: );
2682:
2683: -- debug log
2684: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2686: G_MODULE||l_api_name,
2687: '200: After Calling create_template_model x_return_status : '||x_return_status);
2688: END IF;
2689:

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

2705: x_msg_count => x_msg_count
2706: );
2707:
2708: -- debug log
2709: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2710: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2711: G_MODULE||l_api_name,
2712: '300: After Calling create_template_component x_return_status : '||x_return_status);
2713: END IF;

Line 2710: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2706: );
2707:
2708: -- debug log
2709: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2710: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2711: G_MODULE||l_api_name,
2712: '300: After Calling create_template_component x_return_status : '||x_return_status);
2713: END IF;
2714:

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

2730: x_msg_count => x_msg_count
2731: );
2732:
2733: -- debug log
2734: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2735: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2736: G_MODULE||l_api_name,
2737: '400: After Calling create_clause_model_ref x_return_status : '||x_return_status);
2738: END IF;

Line 2735: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2731: );
2732:
2733: -- debug log
2734: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2735: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2736: G_MODULE||l_api_name,
2737: '400: After Calling create_clause_model_ref x_return_status : '||x_return_status);
2738: END IF;
2739:

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

2760: x_msg_count => x_msg_count
2761: );
2762:
2763: -- debug log
2764: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2765: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2766: G_MODULE||l_api_name,
2767: '400: After Calling create_template_feature x_return_status : '||x_return_status);
2768: END IF;

Line 2765: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2761: );
2762:
2763: -- debug log
2764: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2765: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2766: G_MODULE||l_api_name,
2767: '400: After Calling create_template_feature x_return_status : '||x_return_status);
2768: END IF;
2769:

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

2785: x_msg_data => x_msg_data,
2786: x_msg_count => x_msg_count
2787: );
2788: -- debug log
2789: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2790: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2791: G_MODULE||l_api_name,
2792: '700: After Calling OKC_XPRT_CZ_INT_PVT.import_generic x_return_status : '||
2793: l_import_status);

Line 2790: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2786: x_msg_count => x_msg_count
2787: );
2788: -- debug log
2789: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2790: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2791: G_MODULE||l_api_name,
2792: '700: After Calling OKC_XPRT_CZ_INT_PVT.import_generic x_return_status : '||
2793: l_import_status);
2794: END IF;

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

2804: x_msg_count => x_msg_count
2805: );
2806:
2807: -- debug log
2808: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2809: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2810: G_MODULE||l_api_name,
2811: '700: After Calling OKC_XPRT_UTIL_PVT.check_import_status x_return_status : '||
2812: x_return_status);

Line 2809: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2805: );
2806:
2807: -- debug log
2808: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2809: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2810: G_MODULE||l_api_name,
2811: '700: After Calling OKC_XPRT_UTIL_PVT.check_import_status x_return_status : '||
2812: x_return_status);
2813: END IF;

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

2848: -- Standard call to get message count and if count is 1, get message info.
2849: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2850:
2851: -- end debug log
2852: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2854: G_MODULE||l_api_name,
2855: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2856: END IF;

Line 2853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2849: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2850:
2851: -- end debug log
2852: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2853: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2854: G_MODULE||l_api_name,
2855: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2856: END IF;
2857:

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

2856: END IF;
2857:
2858: EXCEPTION
2859: WHEN FND_API.G_EXC_ERROR THEN
2860: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2862: G_MODULE||l_api_name,
2863: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2864: END IF;

Line 2861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2857:
2858: EXCEPTION
2859: WHEN FND_API.G_EXC_ERROR THEN
2860: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2861: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2862: G_MODULE||l_api_name,
2863: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2864: END IF;
2865:

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

2866: x_return_status := G_RET_STS_ERROR ;
2867: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2868:
2869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2870: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2871: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2872: G_MODULE||l_api_name,
2873: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2874: END IF;

Line 2871: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2867: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2868:
2869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2870: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2871: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2872: G_MODULE||l_api_name,
2873: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2874: END IF;
2875:

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

2876: x_return_status := G_RET_STS_UNEXP_ERROR ;
2877: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2878:
2879: WHEN OTHERS THEN
2880: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2882: G_MODULE||l_api_name,
2883: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2884: END IF;

Line 2881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2877: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2878:
2879: WHEN OTHERS THEN
2880: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2882: G_MODULE||l_api_name,
2883: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
2884: END IF;
2885:

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

2965: l_org_id okc_xprt_rule_hdrs_all.org_id%TYPE;
2966:
2967: BEGIN
2968: -- start debug log
2969: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2971: G_MODULE||l_api_name,
2972: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2973: END IF;

Line 2970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2966:
2967: BEGIN
2968: -- start debug log
2969: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2971: G_MODULE||l_api_name,
2972: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
2973: END IF;
2974:

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

2985: FETCH csr_rule_org_id INTO l_org_id;
2986: CLOSE csr_rule_org_id;
2987:
2988: -- debug log
2989: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2990: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2991: G_MODULE||l_api_name,
2992: '110: l_org_rules_yn '||l_org_rules_yn);
2993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 2990: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2986: CLOSE csr_rule_org_id;
2987:
2988: -- debug log
2989: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2990: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2991: G_MODULE||l_api_name,
2992: '110: l_org_rules_yn '||l_org_rules_yn);
2993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2994: G_MODULE||l_api_name,

Line 2993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

2989: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2990: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2991: G_MODULE||l_api_name,
2992: '110: l_org_rules_yn '||l_org_rules_yn);
2993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2994: G_MODULE||l_api_name,
2995: '110: l_org_id '||l_org_id);
2996: END IF;
2997:

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

3058: -- Standard call to get message count and if count is 1, get message info
3059: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3060:
3061: -- end debug log
3062: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3063: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3064: G_MODULE||l_api_name,
3065: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3066: END IF;

Line 3063: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3059: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3060:
3061: -- end debug log
3062: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3063: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3064: G_MODULE||l_api_name,
3065: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3066: END IF;
3067:

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

3066: END IF;
3067:
3068: EXCEPTION
3069: WHEN FND_API.G_EXC_ERROR THEN
3070: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3071: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3072: G_MODULE||l_api_name,
3073: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3074: END IF;

Line 3071: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3067:
3068: EXCEPTION
3069: WHEN FND_API.G_EXC_ERROR THEN
3070: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3071: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3072: G_MODULE||l_api_name,
3073: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3074: END IF;
3075:

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

3076: x_return_status := G_RET_STS_ERROR ;
3077: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3078:
3079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3080: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3081: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3082: G_MODULE||l_api_name,
3083: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3084: END IF;

Line 3081: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3077: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3078:
3079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3080: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3081: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3082: G_MODULE||l_api_name,
3083: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3084: END IF;
3085:

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

3086: x_return_status := G_RET_STS_UNEXP_ERROR ;
3087: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3088:
3089: WHEN OTHERS THEN
3090: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3091: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3092: G_MODULE||l_api_name,
3093: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3094: END IF;

Line 3091: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3087: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3088:
3089: WHEN OTHERS THEN
3090: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3091: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3092: G_MODULE||l_api_name,
3093: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3094: END IF;
3095:

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

3142:
3143:
3144: BEGIN
3145: -- start debug log
3146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3148: G_MODULE||l_api_name,
3149: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
3150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 3147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3143:
3144: BEGIN
3145: -- start debug log
3146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3148: G_MODULE||l_api_name,
3149: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
3150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3151: G_MODULE||l_api_name,

Line 3150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3148: G_MODULE||l_api_name,
3149: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
3150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3151: G_MODULE||l_api_name,
3152: '100: Parameters ');
3153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3154: G_MODULE||l_api_name,

Line 3153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3149: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
3150: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3151: G_MODULE||l_api_name,
3152: '100: Parameters ');
3153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3154: G_MODULE||l_api_name,
3155: '100: p_org_id '||p_org_id);
3156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3157: G_MODULE||l_api_name,

Line 3156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3152: '100: Parameters ');
3153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3154: G_MODULE||l_api_name,
3155: '100: p_org_id '||p_org_id);
3156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3157: G_MODULE||l_api_name,
3158: '100: p_intent '||p_intent);
3159: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3160: G_MODULE||l_api_name,

Line 3159: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3155: '100: p_org_id '||p_org_id);
3156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3157: G_MODULE||l_api_name,
3158: '100: p_intent '||p_intent);
3159: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3160: G_MODULE||l_api_name,
3161: '100: p_template_id '||p_template_id);
3162: END IF;
3163:

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

3195: -- Standard call to get message count and if count is 1, get message info
3196: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3197:
3198: -- end debug log
3199: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3200: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3201: G_MODULE||l_api_name,
3202: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3203: END IF;

Line 3200: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3196: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3197:
3198: -- end debug log
3199: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3200: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3201: G_MODULE||l_api_name,
3202: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3203: END IF;
3204:

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

3203: END IF;
3204:
3205: EXCEPTION
3206: WHEN FND_API.G_EXC_ERROR THEN
3207: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3209: G_MODULE||l_api_name,
3210: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3211: END IF;

Line 3208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3204:
3205: EXCEPTION
3206: WHEN FND_API.G_EXC_ERROR THEN
3207: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3208: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3209: G_MODULE||l_api_name,
3210: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3211: END IF;
3212:

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

3213: x_return_status := G_RET_STS_ERROR ;
3214: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3215:
3216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3217: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3218: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3219: G_MODULE||l_api_name,
3220: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3221: END IF;

Line 3218: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3214: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3215:
3216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3217: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3218: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3219: G_MODULE||l_api_name,
3220: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3221: END IF;
3222:

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

3223: x_return_status := G_RET_STS_UNEXP_ERROR ;
3224: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3225:
3226: WHEN OTHERS THEN
3227: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3229: G_MODULE||l_api_name,
3230: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3231: END IF;

Line 3228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

3224: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
3225:
3226: WHEN OTHERS THEN
3227: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
3229: G_MODULE||l_api_name,
3230: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
3231: END IF;
3232: