DBA Data[Home] [Help]

APPS.PON_CLO_RENUMBER_PKG dependencies on FND_LOG

Line 1025: IF (l_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1021: -- Dbms_Output.put_line(l_nextNum);
1022:
1023: EXCEPTION
1024: WHEN OTHERS THEN
1025: IF (l_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1026: l_message := 'Exception in new slin number logic: document '||P_Document_ID||
1027: SUBSTR(SQLERRM, 1, 50) || ' ' || SQLCODE ;
1028: FND_LOG.string(log_level => FND_LOG.level_statement,
1029: module => l_module_prefix || l_module,

Line 1028: FND_LOG.string(log_level => FND_LOG.level_statement,

1024: WHEN OTHERS THEN
1025: IF (l_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1026: l_message := 'Exception in new slin number logic: document '||P_Document_ID||
1027: SUBSTR(SQLERRM, 1, 50) || ' ' || SQLCODE ;
1028: FND_LOG.string(log_level => FND_LOG.level_statement,
1029: module => l_module_prefix || l_module,
1030: message => l_message);
1031: END IF;
1032:

Line 1073: IF (l_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1069: -- Dbms_Output.put_line(l_nextNum);
1070:
1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: IF (l_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1074: l_message := 'Exception in new slin number logic: document '||P_Document_ID||
1075: SUBSTR(SQLERRM, 1, 50) || ' ' || SQLCODE ;
1076: FND_LOG.string(log_level => FND_LOG.level_statement,
1077: module => l_module_prefix || l_module,

Line 1076: FND_LOG.string(log_level => FND_LOG.level_statement,

1072: WHEN OTHERS THEN
1073: IF (l_fnd_debug = 'Y' and FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1074: l_message := 'Exception in new slin number logic: document '||P_Document_ID||
1075: SUBSTR(SQLERRM, 1, 50) || ' ' || SQLCODE ;
1076: FND_LOG.string(log_level => FND_LOG.level_statement,
1077: module => l_module_prefix || l_module,
1078: message => l_message);
1079: END IF;
1080:

Line 1321: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1317: FROM PO_LINES_INTERFACE
1318: WHERE INTERFACE_HEADER_ID = p_interface_header_id AND
1319: LINE_NUM_DISPLAY = p_clinnumber;
1320:
1321: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1322: FND_LOG.string(log_level => FND_LOG.level_statement,
1323: module => 'pon.plsql.pon_clo_renumber_pkg',
1324: message => substr('l_group_line_id : '||l_group_line_id, 0, 4000));
1325: END IF;

Line 1322: FND_LOG.string(log_level => FND_LOG.level_statement,

1318: WHERE INTERFACE_HEADER_ID = p_interface_header_id AND
1319: LINE_NUM_DISPLAY = p_clinnumber;
1320:
1321: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1322: FND_LOG.string(log_level => FND_LOG.level_statement,
1323: module => 'pon.plsql.pon_clo_renumber_pkg',
1324: message => substr('l_group_line_id : '||l_group_line_id, 0, 4000));
1325: END IF;
1326:

Line 1341: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1337: ' ORDER BY INTERFACE_LINE_ID';
1338: OPEN all_slins FOR l_slin_query;
1339: LOOP
1340: FETCH all_slins INTO slnLineId, slnInfoFlg;
1341: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1342: FND_LOG.string(log_level => FND_LOG.level_statement,
1343: module => 'pon.plsql.pon_clo_renumber_pkg',
1344: message => substr('slnLineId : '||slnLineId, 0, 4000));
1345: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 1342: FND_LOG.string(log_level => FND_LOG.level_statement,

1338: OPEN all_slins FOR l_slin_query;
1339: LOOP
1340: FETCH all_slins INTO slnLineId, slnInfoFlg;
1341: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1342: FND_LOG.string(log_level => FND_LOG.level_statement,
1343: module => 'pon.plsql.pon_clo_renumber_pkg',
1344: message => substr('slnLineId : '||slnLineId, 0, 4000));
1345: FND_LOG.string(log_level => FND_LOG.level_statement,
1346: module => 'pon.plsql.pon_clo_renumber_pkg',

Line 1345: FND_LOG.string(log_level => FND_LOG.level_statement,

1341: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1342: FND_LOG.string(log_level => FND_LOG.level_statement,
1343: module => 'pon.plsql.pon_clo_renumber_pkg',
1344: message => substr('slnLineId : '||slnLineId, 0, 4000));
1345: FND_LOG.string(log_level => FND_LOG.level_statement,
1346: module => 'pon.plsql.pon_clo_renumber_pkg',
1347: message => substr('slnInfoFlg : '||slnInfoFlg, 0, 4000));
1348: END IF;
1349:

Line 1366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1362: EXCEPTION WHEN OTHERS THEN
1363: NULL;
1364: END;
1365: lastPricedSlin := INCREMENT_PRICED_SLIN_NUMBER(lastPricedSlin);
1366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1367: FND_LOG.string(log_level => FND_LOG.level_statement,
1368: module => 'pon.plsql.pon_clo_renumber_pkg',
1369: message => substr('lastPricedSlin : '||lastPricedSlin, 0, 4000));
1370: END IF;

Line 1367: FND_LOG.string(log_level => FND_LOG.level_statement,

1363: NULL;
1364: END;
1365: lastPricedSlin := INCREMENT_PRICED_SLIN_NUMBER(lastPricedSlin);
1366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1367: FND_LOG.string(log_level => FND_LOG.level_statement,
1368: module => 'pon.plsql.pon_clo_renumber_pkg',
1369: message => substr('lastPricedSlin : '||lastPricedSlin, 0, 4000));
1370: END IF;
1371: ELSE

Line 1382: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1378: EXCEPTION WHEN OTHERS THEN
1379: NULL;
1380: END;
1381: lastInfoSlin := INCREMENT_INFO_SLIN_NUMBER(lastInfoSlin);
1382: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1383: FND_LOG.string(log_level => FND_LOG.level_statement,
1384: module => 'pon.plsql.pon_clo_renumber_pkg',
1385: message => substr('lastInfoSlin : '||lastInfoSlin, 0, 4000));
1386: END IF;

Line 1383: FND_LOG.string(log_level => FND_LOG.level_statement,

1379: NULL;
1380: END;
1381: lastInfoSlin := INCREMENT_INFO_SLIN_NUMBER(lastInfoSlin);
1382: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1383: FND_LOG.string(log_level => FND_LOG.level_statement,
1384: module => 'pon.plsql.pon_clo_renumber_pkg',
1385: message => substr('lastInfoSlin : '||lastInfoSlin, 0, 4000));
1386: END IF;
1387: END IF;