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

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

152: -- than one records from the above sql
153: --
154:
155: IF (g_fnd_debug = 'Y') THEN
156: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
157: FND_LOG.string( log_level => FND_LOG.level_statement,
158: module => g_module_prefix || l_api_name,
159: message => 'Got ORG_ID for negotiation with the parameters : p_document_id = ' || p_document_id|| ' as:'||l_org_id );
160: END IF;

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

153: --
154:
155: IF (g_fnd_debug = 'Y') THEN
156: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
157: FND_LOG.string( log_level => FND_LOG.level_statement,
158: module => g_module_prefix || l_api_name,
159: message => 'Got ORG_ID for negotiation with the parameters : p_document_id = ' || p_document_id|| ' as:'||l_org_id );
160: END IF;
161: END IF;

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

163: l_old_policy := mo_global.get_access_mode();
164: l_old_org_id := mo_global.get_current_org_id();
165:
166: IF (g_fnd_debug = 'Y') THEN
167: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
168: FND_LOG.string( log_level => FND_LOG.level_statement,
169: module => g_module_prefix || l_api_name,
170: message => 'BEGIN: Calling MO_GLOBAL.SET_POLICY_CONTEXT with the parameters : l_org_id = ' || l_org_id );
171: END IF;

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

164: l_old_org_id := mo_global.get_current_org_id();
165:
166: IF (g_fnd_debug = 'Y') THEN
167: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
168: FND_LOG.string( log_level => FND_LOG.level_statement,
169: module => g_module_prefix || l_api_name,
170: message => 'BEGIN: Calling MO_GLOBAL.SET_POLICY_CONTEXT with the parameters : l_org_id = ' || l_org_id );
171: END IF;
172: END IF;

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

176: --
177: mo_global.set_policy_context('S', l_org_id);
178:
179: IF (g_fnd_debug = 'Y') THEN
180: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
181: FND_LOG.string( log_level => FND_LOG.level_statement,
182: module => g_module_prefix || l_api_name,
183: message => 'BEGIN: Calling OKC Package with the parameters : p_document_type = ' || p_document_type ||
184: 'p_document_id = ' || p_document_id);

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

177: mo_global.set_policy_context('S', l_org_id);
178:
179: IF (g_fnd_debug = 'Y') THEN
180: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
181: FND_LOG.string( log_level => FND_LOG.level_statement,
182: module => g_module_prefix || l_api_name,
183: message => 'BEGIN: Calling OKC Package with the parameters : p_document_type = ' || p_document_type ||
184: 'p_document_id = ' || p_document_id);
185: END IF;

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

190: --
191: -- Set the org context back
192: --
193: IF (g_fnd_debug = 'Y') THEN
194: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
195: FND_LOG.string( log_level => FND_LOG.level_statement,
196: module => g_module_prefix || l_api_name,
197: message => 'BEGIN: Calling MO_GLOBAL.SET_POLICY_CONTEXT with the parameters : l_org_id = ' || l_old_org_id || ', l_old_policy:'|| l_old_policy );
198: END IF;

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

191: -- Set the org context back
192: --
193: IF (g_fnd_debug = 'Y') THEN
194: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
195: FND_LOG.string( log_level => FND_LOG.level_statement,
196: module => g_module_prefix || l_api_name,
197: message => 'BEGIN: Calling MO_GLOBAL.SET_POLICY_CONTEXT with the parameters : l_org_id = ' || l_old_org_id || ', l_old_policy:'|| l_old_policy );
198: END IF;
199: END IF;

Line 208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

204:
205: EXCEPTION
206: WHEN OTHERS THEN
207: IF (g_fnd_debug = 'Y') THEN
208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
209: FND_LOG.string( log_level => FND_LOG.level_procedure,
210: module => g_module_prefix || l_api_name,
211: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.is_deviations_enabled function :'
212: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );

Line 209: FND_LOG.string( log_level => FND_LOG.level_procedure,

205: EXCEPTION
206: WHEN OTHERS THEN
207: IF (g_fnd_debug = 'Y') THEN
208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
209: FND_LOG.string( log_level => FND_LOG.level_procedure,
210: module => g_module_prefix || l_api_name,
211: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.is_deviations_enabled function :'
212: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
213: END IF;

Line 386: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

382: x_error_code := '20001';
383: x_error_message := 'ACTIVATE_FAILED';
384:
385: IF (g_fnd_debug = 'Y') THEN
386: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
387:
388: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
389: module => g_module_prefix || l_api_name,
390: message => l_msg_data);

Line 388: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,

384:
385: IF (g_fnd_debug = 'Y') THEN
386: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
387:
388: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
389: module => g_module_prefix || l_api_name,
390: message => l_msg_data);
391: END IF;
392: END IF;

Line 414: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

410: x_error_message := 'ENABLE_NOTIF_FAILED';
411:
412: IF (g_fnd_debug = 'Y') THEN
413:
414: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
415:
416: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
417: module => g_module_prefix || l_api_name,
418: message => l_msg_data);

Line 416: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,

412: IF (g_fnd_debug = 'Y') THEN
413:
414: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
415:
416: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
417: module => g_module_prefix || l_api_name,
418: message => l_msg_data);
419: END IF;
420:

Line 448: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

444: x_error_message := 'CANCEL_DELIV_FAILED';
445:
446: IF (g_fnd_debug = 'Y') THEN
447:
448: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
449:
450: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
451: module => g_module_prefix || l_api_name,
452: message => l_msg_data);

Line 450: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,

446: IF (g_fnd_debug = 'Y') THEN
447:
448: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
449:
450: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
451: module => g_module_prefix || l_api_name,
452: message => l_msg_data);
453: END IF;
454:

Line 594: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

590: );
591:
592: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
593: IF (g_fnd_debug = 'Y') THEN
594: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
595: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
596: module => g_module_prefix || l_api_name,
597: message => l_msg_data);
598: END IF;

Line 595: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,

591:
592: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
593: IF (g_fnd_debug = 'Y') THEN
594: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
595: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
596: module => g_module_prefix || l_api_name,
597: message => l_msg_data);
598: END IF;
599: END IF;

Line 625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

621: );
622:
623: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
624: IF (g_fnd_debug = 'Y') THEN
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
626: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
627: module => g_module_prefix || l_api_name,
628: message => l_msg_data);
629: END IF;

Line 626: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,

622:
623: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
624: IF (g_fnd_debug = 'Y') THEN
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
626: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
627: module => g_module_prefix || l_api_name,
628: message => l_msg_data);
629: END IF;
630: END IF;

Line 658: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

654: x_return_status => l_return_status
655: );
656: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
657: IF (g_fnd_debug = 'Y') THEN
658: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
659: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
660: module => g_module_prefix || l_api_name,
661: message => l_msg_data);
662: END IF;

Line 659: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,

655: );
656: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
657: IF (g_fnd_debug = 'Y') THEN
658: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
659: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
660: module => g_module_prefix || l_api_name,
661: message => l_msg_data);
662: END IF;
663: END IF;

Line 774: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

770:
771:
772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
773: IF (g_fnd_debug = 'Y') THEN
774: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
775: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
776: module => g_module_prefix || l_api_name,
777: message => l_msg_data);
778: END IF;

Line 775: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,

771:
772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
773: IF (g_fnd_debug = 'Y') THEN
774: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
775: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
776: module => g_module_prefix || l_api_name,
777: message => l_msg_data);
778: END IF;
779: END IF;

Line 797: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

793: );
794:
795: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
796: IF (g_fnd_debug = 'Y') THEN
797: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
798: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
799: module => g_module_prefix || l_api_name,
800: message => l_msg_data);
801: END IF;

Line 798: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,

794:
795: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
796: IF (g_fnd_debug = 'Y') THEN
797: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
798: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
799: module => g_module_prefix || l_api_name,
800: message => l_msg_data);
801: END IF;
802: END IF;

Line 893: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

889: x_return_status => l_return_status
890: );
891: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
892: IF (g_fnd_debug = 'Y') THEN
893: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
894: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
895: module => g_module_prefix || l_api_name,
896: message => l_msg_data);
897: END IF;

Line 894: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,

890: );
891: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
892: IF (g_fnd_debug = 'Y') THEN
893: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
894: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
895: module => g_module_prefix || l_api_name,
896: message => l_msg_data);
897: END IF;
898: END IF;

Line 1011: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

1007: );
1008:
1009: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1010: IF (g_fnd_debug = 'Y') THEN
1011: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1012: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1013: module => g_module_prefix || l_api_name,
1014: message => l_msg_data);
1015: END IF;

Line 1012: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,

1008:
1009: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1010: IF (g_fnd_debug = 'Y') THEN
1011: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1012: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1013: module => g_module_prefix || l_api_name,
1014: message => l_msg_data);
1015: END IF;
1016: END IF;

Line 1252: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

1248: x_return_status => l_return_status);
1249:
1250: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1251: IF (g_fnd_debug = 'Y') THEN
1252: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1253: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1254: module => g_module_prefix || l_api_name,
1255: message => l_msg_data);
1256: END IF;

Line 1253: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,

1249:
1250: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1251: IF (g_fnd_debug = 'Y') THEN
1252: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1253: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1254: module => g_module_prefix || l_api_name,
1255: message => l_msg_data);
1256: END IF;
1257: END IF;

Line 1353: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

1349: x_return_status => l_return_status)
1350: ;
1351: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1352: IF (g_fnd_debug = 'Y') THEN
1353: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1354: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1355: module => g_module_prefix || l_api_name,
1356: message => l_msg_data);
1357: END IF;

Line 1354: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,

1350: ;
1351: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1352: IF (g_fnd_debug = 'Y') THEN
1353: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1354: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1355: module => g_module_prefix || l_api_name,
1356: message => l_msg_data);
1357: END IF;
1358: END IF;

Line 1410: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1406:
1407: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);
1408:
1409: if(l_return_status <> fnd_api.g_ret_sts_success) then
1410: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1411: fnd_log.string( fnd_log.level_statement,
1412: 'pon_conterms_utl_pvt',
1413: 'contract_terms_exist() failed for doc_id=' || p_doc_id || ', msg_data=' || l_msg_data
1414: );

Line 1411: fnd_log.string( fnd_log.level_statement,

1407: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);
1408:
1409: if(l_return_status <> fnd_api.g_ret_sts_success) then
1410: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1411: fnd_log.string( fnd_log.level_statement,
1412: 'pon_conterms_utl_pvt',
1413: 'contract_terms_exist() failed for doc_id=' || p_doc_id || ', msg_data=' || l_msg_data
1414: );
1415: end if;

Line 1474: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1470:
1471: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);
1472:
1473: if(l_return_status <> fnd_api.g_ret_sts_success) then
1474: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1475: fnd_log.string( fnd_log.level_statement,
1476: 'pon_conterms_utl_pvt',
1477: 'contract_deliverables_exist() failed for doc_id=' || p_doc_id || ', msg_data=' || l_msg_data
1478: );

Line 1475: fnd_log.string( fnd_log.level_statement,

1471: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);
1472:
1473: if(l_return_status <> fnd_api.g_ret_sts_success) then
1474: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1475: fnd_log.string( fnd_log.level_statement,
1476: 'pon_conterms_utl_pvt',
1477: 'contract_deliverables_exist() failed for doc_id=' || p_doc_id || ', msg_data=' || l_msg_data
1478: );
1479: end if;

Line 1515: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1511:
1512: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);
1513:
1514: if(l_return_status <> fnd_api.g_ret_sts_success) then
1515: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1516: fnd_log.string( fnd_log.level_statement,
1517: 'pon_conterms_utl_pvt',
1518: 'contract_terms_or_del_exist() failed for doc_id=' || p_doc_id || ', msg_data=' || l_msg_data
1519: );

Line 1516: fnd_log.string( fnd_log.level_statement,

1512: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);
1513:
1514: if(l_return_status <> fnd_api.g_ret_sts_success) then
1515: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1516: fnd_log.string( fnd_log.level_statement,
1517: 'pon_conterms_utl_pvt',
1518: 'contract_terms_or_del_exist() failed for doc_id=' || p_doc_id || ', msg_data=' || l_msg_data
1519: );
1520: end if;

Line 1602: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1598:
1599: if (v_return_status <> fnd_api.g_ret_sts_success) then
1600: resultout := null;
1601:
1602: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1603: fnd_log.string(fnd_log.level_statement,
1604: 'pon_conterms_utl_pvt',
1605: 'is_article_exist() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1606: end if;

Line 1603: fnd_log.string(fnd_log.level_statement,

1599: if (v_return_status <> fnd_api.g_ret_sts_success) then
1600: resultout := null;
1601:
1602: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1603: fnd_log.string(fnd_log.level_statement,
1604: 'pon_conterms_utl_pvt',
1605: 'is_article_exist() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1606: end if;
1607: end if;

Line 1676: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1672:
1673: if (v_return_status <> fnd_api.g_ret_sts_success) then
1674: resultout := null;
1675:
1676: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1677: fnd_log.string(fnd_log.level_statement,
1678: 'pon_conterms_utl_pvt',
1679: 'is_article_amended() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1680: end if;

Line 1677: fnd_log.string(fnd_log.level_statement,

1673: if (v_return_status <> fnd_api.g_ret_sts_success) then
1674: resultout := null;
1675:
1676: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1677: fnd_log.string(fnd_log.level_statement,
1678: 'pon_conterms_utl_pvt',
1679: 'is_article_amended() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1680: end if;
1681: end if;

Line 1755: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1751:
1752: if (v_return_status <> fnd_api.g_ret_sts_success) then
1753: resultout := null;
1754:
1755: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1756: fnd_log.string(fnd_log.level_statement,
1757: 'pon_conterms_utl_pvt',
1758: 'is_deliverable_amended() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1759: end if;

Line 1756: fnd_log.string(fnd_log.level_statement,

1752: if (v_return_status <> fnd_api.g_ret_sts_success) then
1753: resultout := null;
1754:
1755: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1756: fnd_log.string(fnd_log.level_statement,
1757: 'pon_conterms_utl_pvt',
1758: 'is_deliverable_amended() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1759: end if;
1760: end if;

Line 1830: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1826:
1827: if (v_return_status <> fnd_api.g_ret_sts_success) then
1828: resultout := null;
1829:
1830: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1831: fnd_log.string(fnd_log.level_statement,
1832: 'pon_conterms_utl_pvt',
1833: 'is_template_expired() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1834: end if;

Line 1831: fnd_log.string(fnd_log.level_statement,

1827: if (v_return_status <> fnd_api.g_ret_sts_success) then
1828: resultout := null;
1829:
1830: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1831: fnd_log.string(fnd_log.level_statement,
1832: 'pon_conterms_utl_pvt',
1833: 'is_template_expired() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1834: end if;
1835: end if;

Line 1905: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1901:
1902: if (v_return_status <> fnd_api.g_ret_sts_success) then
1903: resultout := null;
1904:
1905: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1906: fnd_log.string(fnd_log.level_statement,
1907: 'pon_conterms_utl_pvt',
1908: 'is_standard_contract() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1909: end if;

Line 1906: fnd_log.string(fnd_log.level_statement,

1902: if (v_return_status <> fnd_api.g_ret_sts_success) then
1903: resultout := null;
1904:
1905: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1906: fnd_log.string(fnd_log.level_statement,
1907: 'pon_conterms_utl_pvt',
1908: 'is_standard_contract() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1909: end if;
1910: end if;

Line 1980: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then

1976:
1977: if (v_return_status <> fnd_api.g_ret_sts_success) then
1978: resultout := null;
1979:
1980: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1981: fnd_log.string(fnd_log.level_statement,
1982: 'pon_conterms_utl_pvt',
1983: 'is_deliverable_attached() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1984: end if;

Line 1981: fnd_log.string(fnd_log.level_statement,

1977: if (v_return_status <> fnd_api.g_ret_sts_success) then
1978: resultout := null;
1979:
1980: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1981: fnd_log.string(fnd_log.level_statement,
1982: 'pon_conterms_utl_pvt',
1983: 'is_deliverable_attached() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1984: end if;
1985: end if;

Line 2055: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2051: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN --{
2052:
2053: IF (g_fnd_debug = 'Y') THEN --{
2054:
2055: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2056:
2057: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2058: module => g_module_prefix || l_api_name,
2059: message => 'UPDATE_DELIV_ON_VENDOR_MERGE_FAILED: '

Line 2057: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,

2053: IF (g_fnd_debug = 'Y') THEN --{
2054:
2055: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2056:
2057: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2058: module => g_module_prefix || l_api_name,
2059: message => 'UPDATE_DELIV_ON_VENDOR_MERGE_FAILED: '
2060: || 'p_from_external_party_id = ' || p_from_vendor_id
2061: || ' p_from_external_party_site_id=' || p_from_site_id

Line 2146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2142: x_error_code := 'UPDATE_DELIV_AMEND_FAILED';
2143: x_error_message := 'Unable to update deliverables for auction ' || p_auction_header_id_orig;
2144:
2145: IF (g_fnd_debug = 'Y') THEN
2146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2147: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2148: module => g_module_prefix || l_api_name,
2149: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2150: END IF;

Line 2147: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,

2143: x_error_message := 'Unable to update deliverables for auction ' || p_auction_header_id_orig;
2144:
2145: IF (g_fnd_debug = 'Y') THEN
2146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2147: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2148: module => g_module_prefix || l_api_name,
2149: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2150: END IF;
2151: END IF;

Line 2171: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2167: x_error_code := 'DISABLE_DELIV_AMEND_FAILED';
2168: x_error_message := 'Unable to disable deliverables for auction ' || p_auction_header_id_prev;
2169:
2170: IF (g_fnd_debug = 'Y') THEN
2171: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2172: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2173: module => g_module_prefix || l_api_name,
2174: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2175: END IF;

Line 2172: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,

2168: x_error_message := 'Unable to disable deliverables for auction ' || p_auction_header_id_prev;
2169:
2170: IF (g_fnd_debug = 'Y') THEN
2171: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2172: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2173: module => g_module_prefix || l_api_name,
2174: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2175: END IF;
2176: END IF;

Line 2190: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2186: x_error_code := 'UPDATE_DELIV_AMEND_FAILED_COMPLETELY - ' || SQLCODE;
2187: x_error_message := 'Unable to do anything with deliverables for auction ' || p_auction_header_id_prev || ' ' || SUBSTR(SQLERRM, 1, 100);
2188:
2189: IF (g_fnd_debug = 'Y') THEN
2190: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2191: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2192: module => g_module_prefix || l_api_name,
2193: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2194: END IF;

Line 2191: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,

2187: x_error_message := 'Unable to do anything with deliverables for auction ' || p_auction_header_id_prev || ' ' || SUBSTR(SQLERRM, 1, 100);
2188:
2189: IF (g_fnd_debug = 'Y') THEN
2190: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2191: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2192: module => g_module_prefix || l_api_name,
2193: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2194: END IF;
2195: END IF;

Line 2243: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2239: --
2240: mo_global.set_policy_context('S', l_org_id);
2241:
2242: IF (g_fnd_debug = 'Y') THEN
2243: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2244: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2245: module => g_module_prefix || l_api_name,
2246: message => 'BEGIN: p_document_type = ' || p_document_type ||
2247: 'p_document_id = ' || p_document_id);

Line 2244: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

2240: mo_global.set_policy_context('S', l_org_id);
2241:
2242: IF (g_fnd_debug = 'Y') THEN
2243: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2244: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2245: module => g_module_prefix || l_api_name,
2246: message => 'BEGIN: p_document_type = ' || p_document_type ||
2247: 'p_document_id = ' || p_document_id);
2248: END IF;

Line 2256: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2252: p_document_type => p_document_type,
2253: p_document_id => p_document_id);
2254:
2255: IF (g_fnd_debug = 'Y') THEN
2256: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2257: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2258: module => g_module_prefix || l_api_name,
2259: message => 'END: l_primary_terms_doc_file_id= ' || l_primary_terms_doc_file_id);
2260: END IF;

Line 2257: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

2253: p_document_id => p_document_id);
2254:
2255: IF (g_fnd_debug = 'Y') THEN
2256: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2257: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2258: module => g_module_prefix || l_api_name,
2259: message => 'END: l_primary_terms_doc_file_id= ' || l_primary_terms_doc_file_id);
2260: END IF;
2261: END IF;

Line 2278: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

2274: -- Set the org context back
2275: --
2276: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2277: IF (g_fnd_debug = 'Y') THEN
2278: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2279: FND_LOG.string( log_level => FND_LOG.level_exception,
2280: module => g_module_prefix || l_api_name,
2281: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.GET_PRIMARY_TERMS_DOC_FILE_ID function :'
2282: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );

Line 2279: FND_LOG.string( log_level => FND_LOG.level_exception,

2275: --
2276: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2277: IF (g_fnd_debug = 'Y') THEN
2278: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2279: FND_LOG.string( log_level => FND_LOG.level_exception,
2280: module => g_module_prefix || l_api_name,
2281: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.GET_PRIMARY_TERMS_DOC_FILE_ID function :'
2282: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
2283: END IF;

Line 2330: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2326: --
2327: mo_global.set_policy_context('S', l_org_id);
2328:
2329: IF (g_fnd_debug = 'Y') THEN
2330: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2331: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2332: module => g_module_prefix || l_api_name,
2333: message => 'BEGIN: p_document_type = ' || p_document_type ||
2334: 'p_document_id = ' || p_document_id);

Line 2331: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

2327: mo_global.set_policy_context('S', l_org_id);
2328:
2329: IF (g_fnd_debug = 'Y') THEN
2330: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2331: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2332: module => g_module_prefix || l_api_name,
2333: message => 'BEGIN: p_document_type = ' || p_document_type ||
2334: 'p_document_id = ' || p_document_id);
2335: END IF;

Line 2343: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2339: p_document_type => p_document_type,
2340: p_document_id => p_document_id);
2341:
2342: IF (g_fnd_debug = 'Y') THEN
2343: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2344: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2345: module => g_module_prefix || l_api_name,
2346: message => 'END: l_is_prm_trm_doc_mergeable= ' || l_is_prm_trm_doc_mergeable);
2347: END IF;

Line 2344: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

2340: p_document_id => p_document_id);
2341:
2342: IF (g_fnd_debug = 'Y') THEN
2343: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2344: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2345: module => g_module_prefix || l_api_name,
2346: message => 'END: l_is_prm_trm_doc_mergeable= ' || l_is_prm_trm_doc_mergeable);
2347: END IF;
2348: END IF;

Line 2366: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

2362: --
2363: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2364:
2365: IF (g_fnd_debug = 'Y') THEN
2366: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2367: FND_LOG.string( log_level => FND_LOG.level_exception,
2368: module => g_module_prefix || l_api_name,
2369: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.IS_PRIMARY_TERMS_DOC_MERGEABLE function :'
2370: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );

Line 2367: FND_LOG.string( log_level => FND_LOG.level_exception,

2363: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2364:
2365: IF (g_fnd_debug = 'Y') THEN
2366: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2367: FND_LOG.string( log_level => FND_LOG.level_exception,
2368: module => g_module_prefix || l_api_name,
2369: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.IS_PRIMARY_TERMS_DOC_MERGEABLE function :'
2370: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
2371: END IF;

Line 2418: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2414: --
2415: mo_global.set_policy_context('S', l_org_id);
2416:
2417: IF (g_fnd_debug = 'Y') THEN
2418: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2419: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2420: module => g_module_prefix || l_api_name,
2421: message => 'BEGIN: p_document_type = ' || p_document_type ||
2422: 'p_document_id = ' || p_document_id);

Line 2419: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

2415: mo_global.set_policy_context('S', l_org_id);
2416:
2417: IF (g_fnd_debug = 'Y') THEN
2418: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2419: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2420: module => g_module_prefix || l_api_name,
2421: message => 'BEGIN: p_document_type = ' || p_document_type ||
2422: 'p_document_id = ' || p_document_id);
2423: END IF;

Line 2431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2427: p_document_type => p_document_type,
2428: p_document_id => p_document_id);
2429:
2430: IF (g_fnd_debug = 'Y') THEN
2431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2432: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2433: module => g_module_prefix || l_api_name,
2434: message => 'END: l_contract_source_code = ' || l_contract_source_code);
2435: END IF;

Line 2432: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

2428: p_document_id => p_document_id);
2429:
2430: IF (g_fnd_debug = 'Y') THEN
2431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2432: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2433: module => g_module_prefix || l_api_name,
2434: message => 'END: l_contract_source_code = ' || l_contract_source_code);
2435: END IF;
2436: END IF;

Line 2457: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

2453: -- Set the org context back
2454: --
2455: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2456: IF (g_fnd_debug = 'Y') THEN
2457: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2458: FND_LOG.string( log_level => FND_LOG.level_exception,
2459: module => g_module_prefix || l_api_name,
2460: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.GET_CONTRACT_SOURCE_CODE function :'
2461: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );

Line 2458: FND_LOG.string( log_level => FND_LOG.level_exception,

2454: --
2455: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2456: IF (g_fnd_debug = 'Y') THEN
2457: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2458: FND_LOG.string( log_level => FND_LOG.level_exception,
2459: module => g_module_prefix || l_api_name,
2460: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.GET_CONTRACT_SOURCE_CODE function :'
2461: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
2462: END IF;

Line 2485: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2481:
2482: BEGIN
2483:
2484: IF (g_fnd_debug = 'Y') THEN
2485: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2486: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2487: module => g_module_prefix || l_api_name,
2488: message => 'BEGIN: p_org_id = ' || p_org_id);
2489: END IF;

Line 2486: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

2482: BEGIN
2483:
2484: IF (g_fnd_debug = 'Y') THEN
2485: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2486: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2487: module => g_module_prefix || l_api_name,
2488: message => 'BEGIN: p_org_id = ' || p_org_id);
2489: END IF;
2490: END IF;

Line 2496: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2492: l_legal_entity_id := xle_utilities_grp.get_defaultlegalcontext_ou(p_org_id);
2493:
2494:
2495: IF (g_fnd_debug = 'Y') THEN
2496: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2497: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2498: module => g_module_prefix || l_api_name,
2499: message => 'END: p_org_id = ' || p_org_id || ' l_legal_entity_id = ' || l_legal_entity_id);
2500: END IF;

Line 2497: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

2493:
2494:
2495: IF (g_fnd_debug = 'Y') THEN
2496: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2497: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2498: module => g_module_prefix || l_api_name,
2499: message => 'END: p_org_id = ' || p_org_id || ' l_legal_entity_id = ' || l_legal_entity_id);
2500: END IF;
2501: END IF;

Line 2508: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

2504:
2505: EXCEPTION
2506: WHEN OTHERS THEN
2507: IF (g_fnd_debug = 'Y') THEN
2508: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2509: FND_LOG.string( log_level => FND_LOG.level_exception,
2510: module => g_module_prefix || l_api_name,
2511: message => 'Exception occured while calling xle_utilities_grp get_defaultlegalcontext_ou function with input org-id as :'
2512: || p_org_id

Line 2509: FND_LOG.string( log_level => FND_LOG.level_exception,

2505: EXCEPTION
2506: WHEN OTHERS THEN
2507: IF (g_fnd_debug = 'Y') THEN
2508: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2509: FND_LOG.string( log_level => FND_LOG.level_exception,
2510: module => g_module_prefix || l_api_name,
2511: message => 'Exception occured while calling xle_utilities_grp get_defaultlegalcontext_ou function with input org-id as :'
2512: || p_org_id
2513: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );

Line 2542: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

2538:
2539: BEGIN
2540:
2541: IF (g_fnd_debug = 'Y') THEN
2542: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2543: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2544: module => g_module_prefix || l_api_name,
2545: message => 'BEGIN: p_org_id = ' || p_org_id);
2546: END IF;

Line 2543: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

2539: BEGIN
2540:
2541: IF (g_fnd_debug = 'Y') THEN
2542: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2543: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2544: module => g_module_prefix || l_api_name,
2545: message => 'BEGIN: p_org_id = ' || p_org_id);
2546: END IF;
2547: END IF;

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

2556:
2557: l_legal_entity_name := LegalEntity_Rec.NAME;
2558:
2559: IF (g_fnd_debug = 'Y') THEN
2560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2561: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2562: module => g_module_prefix || l_api_name,
2563: message => 'END: p_org_id = ' || p_org_id || ' legal_entity_name = ' || l_legal_entity_name);
2564: END IF;

Line 2561: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

2557: l_legal_entity_name := LegalEntity_Rec.NAME;
2558:
2559: IF (g_fnd_debug = 'Y') THEN
2560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2561: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2562: module => g_module_prefix || l_api_name,
2563: message => 'END: p_org_id = ' || p_org_id || ' legal_entity_name = ' || l_legal_entity_name);
2564: END IF;
2565: END IF;

Line 2572: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN

2568:
2569: EXCEPTION
2570: WHEN OTHERS THEN
2571: IF (g_fnd_debug = 'Y') THEN
2572: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2573: FND_LOG.string( log_level => FND_LOG.level_exception,
2574: module => g_module_prefix || l_api_name,
2575: message => 'Exception occured while calling xle_utilities_grp get_defaultlegalcontext_ou function with input org-id as :'
2576: || p_org_id

Line 2573: FND_LOG.string( log_level => FND_LOG.level_exception,

2569: EXCEPTION
2570: WHEN OTHERS THEN
2571: IF (g_fnd_debug = 'Y') THEN
2572: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2573: FND_LOG.string( log_level => FND_LOG.level_exception,
2574: module => g_module_prefix || l_api_name,
2575: message => 'Exception occured while calling xle_utilities_grp get_defaultlegalcontext_ou function with input org-id as :'
2576: || p_org_id
2577: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );