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 150: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

146: -- than one records from the above sql
147: --
148:
149: IF (g_fnd_debug = 'Y') THEN
150: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
151: FND_LOG.string( log_level => FND_LOG.level_statement,
152: module => g_module_prefix || l_api_name,
153: message => 'Got ORG_ID for negotiation with the parameters : p_document_id = ' || p_document_id|| ' as:'||l_org_id );
154: END IF;

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

147: --
148:
149: IF (g_fnd_debug = 'Y') THEN
150: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
151: FND_LOG.string( log_level => FND_LOG.level_statement,
152: module => g_module_prefix || l_api_name,
153: message => 'Got ORG_ID for negotiation with the parameters : p_document_id = ' || p_document_id|| ' as:'||l_org_id );
154: END IF;
155: END IF;

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

157: l_old_policy := mo_global.get_access_mode();
158: l_old_org_id := mo_global.get_current_org_id();
159:
160: IF (g_fnd_debug = 'Y') THEN
161: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
162: FND_LOG.string( log_level => FND_LOG.level_statement,
163: module => g_module_prefix || l_api_name,
164: message => 'BEGIN: Calling MO_GLOBAL.SET_POLICY_CONTEXT with the parameters : l_org_id = ' || l_org_id );
165: END IF;

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

158: l_old_org_id := mo_global.get_current_org_id();
159:
160: IF (g_fnd_debug = 'Y') THEN
161: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
162: FND_LOG.string( log_level => FND_LOG.level_statement,
163: module => g_module_prefix || l_api_name,
164: message => 'BEGIN: Calling MO_GLOBAL.SET_POLICY_CONTEXT with the parameters : l_org_id = ' || l_org_id );
165: END IF;
166: END IF;

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

170: --
171: mo_global.set_policy_context('S', l_org_id);
172:
173: IF (g_fnd_debug = 'Y') THEN
174: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
175: FND_LOG.string( log_level => FND_LOG.level_statement,
176: module => g_module_prefix || l_api_name,
177: message => 'BEGIN: Calling OKC Package with the parameters : p_document_type = ' || p_document_type ||
178: 'p_document_id = ' || p_document_id);

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

171: mo_global.set_policy_context('S', l_org_id);
172:
173: IF (g_fnd_debug = 'Y') THEN
174: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
175: FND_LOG.string( log_level => FND_LOG.level_statement,
176: module => g_module_prefix || l_api_name,
177: message => 'BEGIN: Calling OKC Package with the parameters : p_document_type = ' || p_document_type ||
178: 'p_document_id = ' || p_document_id);
179: END IF;

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

184: --
185: -- Set the org context back
186: --
187: IF (g_fnd_debug = 'Y') THEN
188: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
189: FND_LOG.string( log_level => FND_LOG.level_statement,
190: module => g_module_prefix || l_api_name,
191: message => 'BEGIN: Calling MO_GLOBAL.SET_POLICY_CONTEXT with the parameters : l_org_id = ' || l_old_org_id || ', l_old_policy:'|| l_old_policy );
192: END IF;

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

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

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

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

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

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

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

376: x_error_code := '20001';
377: x_error_message := 'ACTIVATE_FAILED';
378:
379: IF (g_fnd_debug = 'Y') THEN
380: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
381:
382: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
383: module => g_module_prefix || l_api_name,
384: message => l_msg_data);

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

378:
379: IF (g_fnd_debug = 'Y') THEN
380: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
381:
382: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
383: module => g_module_prefix || l_api_name,
384: message => l_msg_data);
385: END IF;
386: END IF;

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

404: x_error_message := 'ENABLE_NOTIF_FAILED';
405:
406: IF (g_fnd_debug = 'Y') THEN
407:
408: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
409:
410: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
411: module => g_module_prefix || l_api_name,
412: message => l_msg_data);

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

406: IF (g_fnd_debug = 'Y') THEN
407:
408: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
409:
410: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
411: module => g_module_prefix || l_api_name,
412: message => l_msg_data);
413: END IF;
414:

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

438: x_error_message := 'CANCEL_DELIV_FAILED';
439:
440: IF (g_fnd_debug = 'Y') THEN
441:
442: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
443:
444: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
445: module => g_module_prefix || l_api_name,
446: message => l_msg_data);

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

440: IF (g_fnd_debug = 'Y') THEN
441:
442: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
443:
444: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
445: module => g_module_prefix || l_api_name,
446: message => l_msg_data);
447: END IF;
448:

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

584: );
585:
586: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
587: IF (g_fnd_debug = 'Y') THEN
588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
589: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
590: module => g_module_prefix || l_api_name,
591: message => l_msg_data);
592: END IF;

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

585:
586: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
587: IF (g_fnd_debug = 'Y') THEN
588: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
589: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
590: module => g_module_prefix || l_api_name,
591: message => l_msg_data);
592: END IF;
593: END IF;

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

615: );
616:
617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
618: IF (g_fnd_debug = 'Y') THEN
619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
620: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
621: module => g_module_prefix || l_api_name,
622: message => l_msg_data);
623: END IF;

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

616:
617: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
618: IF (g_fnd_debug = 'Y') THEN
619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
620: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
621: module => g_module_prefix || l_api_name,
622: message => l_msg_data);
623: END IF;
624: END IF;

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

648: x_return_status => l_return_status
649: );
650: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
651: IF (g_fnd_debug = 'Y') THEN
652: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
653: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
654: module => g_module_prefix || l_api_name,
655: message => l_msg_data);
656: END IF;

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

649: );
650: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
651: IF (g_fnd_debug = 'Y') THEN
652: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
653: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
654: module => g_module_prefix || l_api_name,
655: message => l_msg_data);
656: END IF;
657: END IF;

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

764:
765:
766: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
767: IF (g_fnd_debug = 'Y') THEN
768: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
769: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
770: module => g_module_prefix || l_api_name,
771: message => l_msg_data);
772: END IF;

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

765:
766: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
767: IF (g_fnd_debug = 'Y') THEN
768: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
769: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
770: module => g_module_prefix || l_api_name,
771: message => l_msg_data);
772: END IF;
773: END IF;

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

787: );
788:
789: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
790: IF (g_fnd_debug = 'Y') THEN
791: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
792: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
793: module => g_module_prefix || l_api_name,
794: message => l_msg_data);
795: END IF;

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

788:
789: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
790: IF (g_fnd_debug = 'Y') THEN
791: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
792: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
793: module => g_module_prefix || l_api_name,
794: message => l_msg_data);
795: END IF;
796: END IF;

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

883: x_return_status => l_return_status
884: );
885: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
886: IF (g_fnd_debug = 'Y') THEN
887: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
888: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
889: module => g_module_prefix || l_api_name,
890: message => l_msg_data);
891: END IF;

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

884: );
885: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
886: IF (g_fnd_debug = 'Y') THEN
887: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
888: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
889: module => g_module_prefix || l_api_name,
890: message => l_msg_data);
891: END IF;
892: END IF;

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

1001: );
1002:
1003: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1004: IF (g_fnd_debug = 'Y') THEN
1005: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1006: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1007: module => g_module_prefix || l_api_name,
1008: message => l_msg_data);
1009: END IF;

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

1002:
1003: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1004: IF (g_fnd_debug = 'Y') THEN
1005: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1006: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1007: module => g_module_prefix || l_api_name,
1008: message => l_msg_data);
1009: END IF;
1010: END IF;

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

1242: x_return_status => l_return_status);
1243:
1244: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1245: IF (g_fnd_debug = 'Y') THEN
1246: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1247: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1248: module => g_module_prefix || l_api_name,
1249: message => l_msg_data);
1250: END IF;

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

1243:
1244: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1245: IF (g_fnd_debug = 'Y') THEN
1246: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1247: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1248: module => g_module_prefix || l_api_name,
1249: message => l_msg_data);
1250: END IF;
1251: END IF;

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

1343: x_return_status => l_return_status)
1344: ;
1345: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1346: IF (g_fnd_debug = 'Y') THEN
1347: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1348: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1349: module => g_module_prefix || l_api_name,
1350: message => l_msg_data);
1351: END IF;

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

1344: ;
1345: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1346: IF (g_fnd_debug = 'Y') THEN
1347: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1348: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1349: module => g_module_prefix || l_api_name,
1350: message => l_msg_data);
1351: END IF;
1352: END IF;

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

1397:
1398: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);
1399:
1400: if(l_return_status <> fnd_api.g_ret_sts_success) then
1401: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1402: fnd_log.string( fnd_log.level_statement,
1403: 'pon_conterms_utl_pvt',
1404: 'contract_terms_exist() failed for doc_id=' || p_doc_id || ', msg_data=' || l_msg_data
1405: );

Line 1402: fnd_log.string( fnd_log.level_statement,

1398: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);
1399:
1400: if(l_return_status <> fnd_api.g_ret_sts_success) then
1401: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1402: fnd_log.string( fnd_log.level_statement,
1403: 'pon_conterms_utl_pvt',
1404: 'contract_terms_exist() failed for doc_id=' || p_doc_id || ', msg_data=' || l_msg_data
1405: );
1406: end if;

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

1496:
1497: if (v_return_status <> fnd_api.g_ret_sts_success) then
1498: resultout := null;
1499:
1500: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1501: fnd_log.string(fnd_log.level_statement,
1502: 'pon_conterms_utl_pvt',
1503: 'is_article_exist() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1504: end if;

Line 1501: fnd_log.string(fnd_log.level_statement,

1497: if (v_return_status <> fnd_api.g_ret_sts_success) then
1498: resultout := null;
1499:
1500: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1501: fnd_log.string(fnd_log.level_statement,
1502: 'pon_conterms_utl_pvt',
1503: 'is_article_exist() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1504: end if;
1505: end if;

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

1570:
1571: if (v_return_status <> fnd_api.g_ret_sts_success) then
1572: resultout := null;
1573:
1574: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1575: fnd_log.string(fnd_log.level_statement,
1576: 'pon_conterms_utl_pvt',
1577: 'is_article_amended() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1578: end if;

Line 1575: fnd_log.string(fnd_log.level_statement,

1571: if (v_return_status <> fnd_api.g_ret_sts_success) then
1572: resultout := null;
1573:
1574: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1575: fnd_log.string(fnd_log.level_statement,
1576: 'pon_conterms_utl_pvt',
1577: 'is_article_amended() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1578: end if;
1579: end if;

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

1649:
1650: if (v_return_status <> fnd_api.g_ret_sts_success) then
1651: resultout := null;
1652:
1653: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1654: fnd_log.string(fnd_log.level_statement,
1655: 'pon_conterms_utl_pvt',
1656: 'is_deliverable_amended() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1657: end if;

Line 1654: fnd_log.string(fnd_log.level_statement,

1650: if (v_return_status <> fnd_api.g_ret_sts_success) then
1651: resultout := null;
1652:
1653: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1654: fnd_log.string(fnd_log.level_statement,
1655: 'pon_conterms_utl_pvt',
1656: 'is_deliverable_amended() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1657: end if;
1658: end if;

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

1724:
1725: if (v_return_status <> fnd_api.g_ret_sts_success) then
1726: resultout := null;
1727:
1728: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1729: fnd_log.string(fnd_log.level_statement,
1730: 'pon_conterms_utl_pvt',
1731: 'is_template_expired() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1732: end if;

Line 1729: fnd_log.string(fnd_log.level_statement,

1725: if (v_return_status <> fnd_api.g_ret_sts_success) then
1726: resultout := null;
1727:
1728: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1729: fnd_log.string(fnd_log.level_statement,
1730: 'pon_conterms_utl_pvt',
1731: 'is_template_expired() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1732: end if;
1733: end if;

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

1799:
1800: if (v_return_status <> fnd_api.g_ret_sts_success) then
1801: resultout := null;
1802:
1803: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1804: fnd_log.string(fnd_log.level_statement,
1805: 'pon_conterms_utl_pvt',
1806: 'is_standard_contract() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1807: end if;

Line 1804: fnd_log.string(fnd_log.level_statement,

1800: if (v_return_status <> fnd_api.g_ret_sts_success) then
1801: resultout := null;
1802:
1803: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1804: fnd_log.string(fnd_log.level_statement,
1805: 'pon_conterms_utl_pvt',
1806: 'is_standard_contract() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1807: end if;
1808: end if;

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

1874:
1875: if (v_return_status <> fnd_api.g_ret_sts_success) then
1876: resultout := null;
1877:
1878: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1879: fnd_log.string(fnd_log.level_statement,
1880: 'pon_conterms_utl_pvt',
1881: 'is_deliverable_attached() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1882: end if;

Line 1879: fnd_log.string(fnd_log.level_statement,

1875: if (v_return_status <> fnd_api.g_ret_sts_success) then
1876: resultout := null;
1877:
1878: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1879: fnd_log.string(fnd_log.level_statement,
1880: 'pon_conterms_utl_pvt',
1881: 'is_deliverable_attached() failed for doc_id=' || v_doc_id || ', msg_data=' || v_msg_data);
1882: end if;
1883: end if;

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

1949: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN --{
1950:
1951: IF (g_fnd_debug = 'Y') THEN --{
1952:
1953: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1954:
1955: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
1956: module => g_module_prefix || l_api_name,
1957: message => 'UPDATE_DELIV_ON_VENDOR_MERGE_FAILED: '

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

1951: IF (g_fnd_debug = 'Y') THEN --{
1952:
1953: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1954:
1955: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
1956: module => g_module_prefix || l_api_name,
1957: message => 'UPDATE_DELIV_ON_VENDOR_MERGE_FAILED: '
1958: || 'p_from_external_party_id = ' || p_from_vendor_id
1959: || ' p_from_external_party_site_id=' || p_from_site_id

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

2040: x_error_code := 'UPDATE_DELIV_AMEND_FAILED';
2041: x_error_message := 'Unable to update deliverables for auction ' || p_auction_header_id_orig;
2042:
2043: IF (g_fnd_debug = 'Y') THEN
2044: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2045: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2046: module => g_module_prefix || l_api_name,
2047: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2048: END IF;

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

2041: x_error_message := 'Unable to update deliverables for auction ' || p_auction_header_id_orig;
2042:
2043: IF (g_fnd_debug = 'Y') THEN
2044: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2045: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2046: module => g_module_prefix || l_api_name,
2047: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2048: END IF;
2049: END IF;

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

2065: x_error_code := 'DISABLE_DELIV_AMEND_FAILED';
2066: x_error_message := 'Unable to disable deliverables for auction ' || p_auction_header_id_prev;
2067:
2068: IF (g_fnd_debug = 'Y') THEN
2069: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2070: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2071: module => g_module_prefix || l_api_name,
2072: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2073: END IF;

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

2066: x_error_message := 'Unable to disable deliverables for auction ' || p_auction_header_id_prev;
2067:
2068: IF (g_fnd_debug = 'Y') THEN
2069: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2070: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2071: module => g_module_prefix || l_api_name,
2072: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2073: END IF;
2074: END IF;

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

2084: x_error_code := 'UPDATE_DELIV_AMEND_FAILED_COMPLETELY - ' || SQLCODE;
2085: x_error_message := 'Unable to do anything with deliverables for auction ' || p_auction_header_id_prev || ' ' || SUBSTR(SQLERRM, 1, 100);
2086:
2087: IF (g_fnd_debug = 'Y') THEN
2088: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2089: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2090: module => g_module_prefix || l_api_name,
2091: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2092: END IF;

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

2085: x_error_message := 'Unable to do anything with deliverables for auction ' || p_auction_header_id_prev || ' ' || SUBSTR(SQLERRM, 1, 100);
2086:
2087: IF (g_fnd_debug = 'Y') THEN
2088: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2089: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE ,
2090: module => g_module_prefix || l_api_name,
2091: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2092: END IF;
2093: END IF;

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

2137: --
2138: mo_global.set_policy_context('S', l_org_id);
2139:
2140: IF (g_fnd_debug = 'Y') THEN
2141: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2142: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2143: module => g_module_prefix || l_api_name,
2144: message => 'BEGIN: p_document_type = ' || p_document_type ||
2145: 'p_document_id = ' || p_document_id);

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

2138: mo_global.set_policy_context('S', l_org_id);
2139:
2140: IF (g_fnd_debug = 'Y') THEN
2141: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2142: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2143: module => g_module_prefix || l_api_name,
2144: message => 'BEGIN: p_document_type = ' || p_document_type ||
2145: 'p_document_id = ' || p_document_id);
2146: END IF;

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

2150: p_document_type => p_document_type,
2151: p_document_id => p_document_id);
2152:
2153: IF (g_fnd_debug = 'Y') THEN
2154: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2155: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2156: module => g_module_prefix || l_api_name,
2157: message => 'END: l_primary_terms_doc_file_id= ' || l_primary_terms_doc_file_id);
2158: END IF;

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

2151: p_document_id => p_document_id);
2152:
2153: IF (g_fnd_debug = 'Y') THEN
2154: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2155: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2156: module => g_module_prefix || l_api_name,
2157: message => 'END: l_primary_terms_doc_file_id= ' || l_primary_terms_doc_file_id);
2158: END IF;
2159: END IF;

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

2172: -- Set the org context back
2173: --
2174: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2175: IF (g_fnd_debug = 'Y') THEN
2176: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2177: FND_LOG.string( log_level => FND_LOG.level_exception,
2178: module => g_module_prefix || l_api_name,
2179: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.GET_PRIMARY_TERMS_DOC_FILE_ID function :'
2180: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );

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

2173: --
2174: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2175: IF (g_fnd_debug = 'Y') THEN
2176: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2177: FND_LOG.string( log_level => FND_LOG.level_exception,
2178: module => g_module_prefix || l_api_name,
2179: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.GET_PRIMARY_TERMS_DOC_FILE_ID function :'
2180: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
2181: END IF;

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

2224: --
2225: mo_global.set_policy_context('S', l_org_id);
2226:
2227: IF (g_fnd_debug = 'Y') THEN
2228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2229: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2230: module => g_module_prefix || l_api_name,
2231: message => 'BEGIN: p_document_type = ' || p_document_type ||
2232: 'p_document_id = ' || p_document_id);

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

2225: mo_global.set_policy_context('S', l_org_id);
2226:
2227: IF (g_fnd_debug = 'Y') THEN
2228: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2229: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2230: module => g_module_prefix || l_api_name,
2231: message => 'BEGIN: p_document_type = ' || p_document_type ||
2232: 'p_document_id = ' || p_document_id);
2233: END IF;

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

2237: p_document_type => p_document_type,
2238: p_document_id => p_document_id);
2239:
2240: IF (g_fnd_debug = 'Y') THEN
2241: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2242: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2243: module => g_module_prefix || l_api_name,
2244: message => 'END: l_is_prm_trm_doc_mergeable= ' || l_is_prm_trm_doc_mergeable);
2245: END IF;

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

2238: p_document_id => p_document_id);
2239:
2240: IF (g_fnd_debug = 'Y') THEN
2241: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2242: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2243: module => g_module_prefix || l_api_name,
2244: message => 'END: l_is_prm_trm_doc_mergeable= ' || l_is_prm_trm_doc_mergeable);
2245: END IF;
2246: END IF;

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

2260: --
2261: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2262:
2263: IF (g_fnd_debug = 'Y') THEN
2264: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2265: FND_LOG.string( log_level => FND_LOG.level_exception,
2266: module => g_module_prefix || l_api_name,
2267: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.IS_PRIMARY_TERMS_DOC_MERGEABLE function :'
2268: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );

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

2261: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2262:
2263: IF (g_fnd_debug = 'Y') THEN
2264: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2265: FND_LOG.string( log_level => FND_LOG.level_exception,
2266: module => g_module_prefix || l_api_name,
2267: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.IS_PRIMARY_TERMS_DOC_MERGEABLE function :'
2268: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
2269: END IF;

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

2312: --
2313: mo_global.set_policy_context('S', l_org_id);
2314:
2315: IF (g_fnd_debug = 'Y') THEN
2316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2317: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2318: module => g_module_prefix || l_api_name,
2319: message => 'BEGIN: p_document_type = ' || p_document_type ||
2320: 'p_document_id = ' || p_document_id);

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

2313: mo_global.set_policy_context('S', l_org_id);
2314:
2315: IF (g_fnd_debug = 'Y') THEN
2316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2317: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2318: module => g_module_prefix || l_api_name,
2319: message => 'BEGIN: p_document_type = ' || p_document_type ||
2320: 'p_document_id = ' || p_document_id);
2321: END IF;

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

2325: p_document_type => p_document_type,
2326: p_document_id => p_document_id);
2327:
2328: IF (g_fnd_debug = 'Y') THEN
2329: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2330: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2331: module => g_module_prefix || l_api_name,
2332: message => 'END: l_contract_source_code = ' || l_contract_source_code);
2333: END IF;

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

2326: p_document_id => p_document_id);
2327:
2328: IF (g_fnd_debug = 'Y') THEN
2329: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2330: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2331: module => g_module_prefix || l_api_name,
2332: message => 'END: l_contract_source_code = ' || l_contract_source_code);
2333: END IF;
2334: END IF;

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

2351: -- Set the org context back
2352: --
2353: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2354: IF (g_fnd_debug = 'Y') THEN
2355: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2356: FND_LOG.string( log_level => FND_LOG.level_exception,
2357: module => g_module_prefix || l_api_name,
2358: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.GET_CONTRACT_SOURCE_CODE function :'
2359: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );

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

2352: --
2353: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2354: IF (g_fnd_debug = 'Y') THEN
2355: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2356: FND_LOG.string( log_level => FND_LOG.level_exception,
2357: module => g_module_prefix || l_api_name,
2358: message => 'Exception occured while calling OKC_TERMS_UTIL_GRP.GET_CONTRACT_SOURCE_CODE function :'
2359: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
2360: END IF;

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

2379:
2380: BEGIN
2381:
2382: IF (g_fnd_debug = 'Y') THEN
2383: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2384: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2385: module => g_module_prefix || l_api_name,
2386: message => 'BEGIN: p_org_id = ' || p_org_id);
2387: END IF;

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

2380: BEGIN
2381:
2382: IF (g_fnd_debug = 'Y') THEN
2383: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2384: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2385: module => g_module_prefix || l_api_name,
2386: message => 'BEGIN: p_org_id = ' || p_org_id);
2387: END IF;
2388: END IF;

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

2390: l_legal_entity_id := xle_utilities_grp.get_defaultlegalcontext_ou(p_org_id);
2391:
2392:
2393: IF (g_fnd_debug = 'Y') THEN
2394: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2395: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2396: module => g_module_prefix || l_api_name,
2397: message => 'END: p_org_id = ' || p_org_id || ' l_legal_entity_id = ' || l_legal_entity_id);
2398: END IF;

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

2391:
2392:
2393: IF (g_fnd_debug = 'Y') THEN
2394: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
2395: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,
2396: module => g_module_prefix || l_api_name,
2397: message => 'END: p_org_id = ' || p_org_id || ' l_legal_entity_id = ' || l_legal_entity_id);
2398: END IF;
2399: END IF;

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

2402:
2403: EXCEPTION
2404: WHEN OTHERS THEN
2405: IF (g_fnd_debug = 'Y') THEN
2406: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2407: FND_LOG.string( log_level => FND_LOG.level_exception,
2408: module => g_module_prefix || l_api_name,
2409: message => 'Exception occured while calling xle_utilities_grp get_defaultlegalcontext_ou function with input org-id as :'
2410: || p_org_id

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

2403: EXCEPTION
2404: WHEN OTHERS THEN
2405: IF (g_fnd_debug = 'Y') THEN
2406: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
2407: FND_LOG.string( log_level => FND_LOG.level_exception,
2408: module => g_module_prefix || l_api_name,
2409: message => 'Exception occured while calling xle_utilities_grp get_defaultlegalcontext_ou function with input org-id as :'
2410: || p_org_id
2411: || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );