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

Line 171: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

167: l_archive_end_date PO_HEADERS_ALL.END_DATE%TYPE;
168:
169: BEGIN
170: IF g_fnd_debug = 'Y' then
171: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
172: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
173: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
174: MESSAGE =>'10: Start: Get_DELIVERABLE_EVENTS');
175: END IF;

Line 172: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

168:
169: BEGIN
170: IF g_fnd_debug = 'Y' then
171: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
172: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
173: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
174: MESSAGE =>'10: Start: Get_DELIVERABLE_EVENTS');
175: END IF;
176: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 176: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

172: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
173: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
174: MESSAGE =>'10: Start: Get_DELIVERABLE_EVENTS');
175: END IF;
176: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
177: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
178: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
179: MESSAGE =>'15: Action Code: Doc subtype'||p_action_code||': '||p_doc_subtype);
180: END IF;

Line 177: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

173: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
174: MESSAGE =>'10: Start: Get_DELIVERABLE_EVENTS');
175: END IF;
176: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
177: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
178: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
179: MESSAGE =>'15: Action Code: Doc subtype'||p_action_code||': '||p_doc_subtype);
180: END IF;
181: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 181: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

177: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
178: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
179: MESSAGE =>'15: Action Code: Doc subtype'||p_action_code||': '||p_doc_subtype);
180: END IF;
181: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
182: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
183: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
184: MESSAGE =>'20: Count in Event table'||x_event_tbl.count);
185: END IF;

Line 182: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

178: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
179: MESSAGE =>'15: Action Code: Doc subtype'||p_action_code||': '||p_doc_subtype);
180: END IF;
181: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
182: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
183: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
184: MESSAGE =>'20: Count in Event table'||x_event_tbl.count);
185: END IF;
186:

Line 208: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

204: FROM po_headers_all
205: WHERE po_header_id = p_po_header_id;
206:
207: IF g_fnd_debug = 'Y' then
208: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
209: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
210: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
211: MESSAGE =>'30: After Select.po found');
212: END IF;

Line 209: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

205: WHERE po_header_id = p_po_header_id;
206:
207: IF g_fnd_debug = 'Y' then
208: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
209: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
210: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
211: MESSAGE =>'30: After Select.po found');
212: END IF;
213:

Line 258: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

254: END IF;--action_code=A or U
255: END IF;--doc subtype code
256:
257: IF g_fnd_debug = 'Y' then
258: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
259: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
260: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
261: MESSAGE =>'90: Count in Event table'||x_event_tbl.count);
262: END IF;

Line 259: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

255: END IF;--doc subtype code
256:
257: IF g_fnd_debug = 'Y' then
258: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
259: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
260: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
261: MESSAGE =>'90: Count in Event table'||x_event_tbl.count);
262: END IF;
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

259: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
260: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
261: MESSAGE =>'90: Count in Event table'||x_event_tbl.count);
262: END IF;
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
264: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
265: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
266: MESSAGE =>'100: End Get_DELIVERABLE_EVENTS');
267: END IF;

Line 264: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

260: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
261: MESSAGE =>'90: Count in Event table'||x_event_tbl.count);
262: END IF;
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
264: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
265: MODULE =>g_module_prefix||'Get_DELIVERABLE_EVENTS',
266: MESSAGE =>'100: End Get_DELIVERABLE_EVENTS');
267: END IF;
268:

Line 593: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

589:
590: l_Contracts_call_exception EXCEPTION;
591: BEGIN
592: IF g_fnd_debug = 'Y' then
593: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
594: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
595: MODULE =>g_module_prefix||l_api_name,
596: MESSAGE =>'10: Start UPDATE_CONTERMS_DATES');
597: END IF;

Line 594: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

590: l_Contracts_call_exception EXCEPTION;
591: BEGIN
592: IF g_fnd_debug = 'Y' then
593: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
594: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
595: MODULE =>g_module_prefix||l_api_name,
596: MESSAGE =>'10: Start UPDATE_CONTERMS_DATES');
597: END IF;
598: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 598: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

594: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
595: MODULE =>g_module_prefix||l_api_name,
596: MESSAGE =>'10: Start UPDATE_CONTERMS_DATES');
597: END IF;
598: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
599: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
600: MODULE =>g_module_prefix||l_api_name,
601: MESSAGE =>'15: p_conterms_exist_flag'||p_conterms_exist_flag);
602: END IF;

Line 599: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

595: MODULE =>g_module_prefix||l_api_name,
596: MESSAGE =>'10: Start UPDATE_CONTERMS_DATES');
597: END IF;
598: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
599: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
600: MODULE =>g_module_prefix||l_api_name,
601: MESSAGE =>'15: p_conterms_exist_flag'||p_conterms_exist_flag);
602: END IF;
603: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 603: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

599: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
600: MODULE =>g_module_prefix||l_api_name,
601: MESSAGE =>'15: p_conterms_exist_flag'||p_conterms_exist_flag);
602: END IF;
603: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
604: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
605: MODULE =>g_module_prefix||l_api_name,
606: MESSAGE =>'18: p_po_doc_type '||p_po_doc_type );
607: END IF;

Line 604: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

600: MODULE =>g_module_prefix||l_api_name,
601: MESSAGE =>'15: p_conterms_exist_flag'||p_conterms_exist_flag);
602: END IF;
603: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
604: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
605: MODULE =>g_module_prefix||l_api_name,
606: MESSAGE =>'18: p_po_doc_type '||p_po_doc_type );
607: END IF;
608: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 608: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

604: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
605: MODULE =>g_module_prefix||l_api_name,
606: MESSAGE =>'18: p_po_doc_type '||p_po_doc_type );
607: END IF;
608: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
609: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
610: MODULE =>g_module_prefix||l_api_name,
611: MESSAGE =>'20: p_po_doc_subtype'||p_po_doc_subtype);
612: END IF;

Line 609: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

605: MODULE =>g_module_prefix||l_api_name,
606: MESSAGE =>'18: p_po_doc_type '||p_po_doc_type );
607: END IF;
608: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
609: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
610: MODULE =>g_module_prefix||l_api_name,
611: MESSAGE =>'20: p_po_doc_subtype'||p_po_doc_subtype);
612: END IF;
613: End if;

Line 616: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

612: END IF;
613: End if;
614: IF p_conterms_exist_flag = 'Y' then
615: IF g_fnd_debug = 'Y' then
616: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
617: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
618: MODULE =>g_module_prefix||l_api_name,
619: MESSAGE =>'50: It is a procurement Contract');
620: END IF;

Line 617: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

613: End if;
614: IF p_conterms_exist_flag = 'Y' then
615: IF g_fnd_debug = 'Y' then
616: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
617: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
618: MODULE =>g_module_prefix||l_api_name,
619: MESSAGE =>'50: It is a procurement Contract');
620: END IF;
621: End if;

Line 624: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

620: END IF;
621: End if;
622: l_k_api_name:='OKC_TERMS_UTIl_GRP.Get_Last_Update_Date';
623: IF g_fnd_debug = 'Y' then
624: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
625: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
626: MODULE =>g_module_prefix||l_api_name,
627: MESSAGE =>'70: Before call to OKC_TERMS_UTIl_GRP.Get_Last_Update_Date');
628: END IF;

Line 625: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

621: End if;
622: l_k_api_name:='OKC_TERMS_UTIl_GRP.Get_Last_Update_Date';
623: IF g_fnd_debug = 'Y' then
624: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
625: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
626: MODULE =>g_module_prefix||l_api_name,
627: MESSAGE =>'70: Before call to OKC_TERMS_UTIl_GRP.Get_Last_Update_Date');
628: END IF;
629: End if;

Line 640: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

636: x_return_status => x_return_status,
637: x_msg_data => x_msg_data,
638: x_msg_count => x_msg_count);
639: IF g_fnd_debug = 'Y' then
640: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
641: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
642: MODULE =>g_module_prefix||l_api_name,
643: MESSAGE =>'80: After call to OKC_...Get_Last_Update_Date. Status'||x_return_status);
644: END IF;

Line 641: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

637: x_msg_data => x_msg_data,
638: x_msg_count => x_msg_count);
639: IF g_fnd_debug = 'Y' then
640: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
641: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
642: MODULE =>g_module_prefix||l_api_name,
643: MESSAGE =>'80: After call to OKC_...Get_Last_Update_Date. Status'||x_return_status);
644: END IF;
645: End if;

Line 658: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

654: l_deliv_upd_date := null;
655: END IF;
656:
657: IF g_fnd_debug = 'Y' then
658: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
659: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
660: MODULE =>g_module_prefix||l_api_name,
661: MESSAGE =>'100: Articles Upd Date'||l_articles_upd_date);
662: END IF;

Line 659: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

655: END IF;
656:
657: IF g_fnd_debug = 'Y' then
658: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
659: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
660: MODULE =>g_module_prefix||l_api_name,
661: MESSAGE =>'100: Articles Upd Date'||l_articles_upd_date);
662: END IF;
663: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 663: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

659: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
660: MODULE =>g_module_prefix||l_api_name,
661: MESSAGE =>'100: Articles Upd Date'||l_articles_upd_date);
662: END IF;
663: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
664: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
665: MODULE =>g_module_prefix||l_api_name,
666: MESSAGE =>'100: Deliverables Upd Date'||l_deliv_upd_date);
667: END IF;

Line 664: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

660: MODULE =>g_module_prefix||l_api_name,
661: MESSAGE =>'100: Articles Upd Date'||l_articles_upd_date);
662: END IF;
663: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
664: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
665: MODULE =>g_module_prefix||l_api_name,
666: MESSAGE =>'100: Deliverables Upd Date'||l_deliv_upd_date);
667: END IF;
668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

664: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
665: MODULE =>g_module_prefix||l_api_name,
666: MESSAGE =>'100: Deliverables Upd Date'||l_deliv_upd_date);
667: END IF;
668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
669: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
670: MODULE =>g_module_prefix||l_api_name,
671: MESSAGE =>'120: Before update of dates in po headers'||l_deliv_upd_date);
672: END IF;

Line 669: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

665: MODULE =>g_module_prefix||l_api_name,
666: MESSAGE =>'100: Deliverables Upd Date'||l_deliv_upd_date);
667: END IF;
668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
669: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
670: MODULE =>g_module_prefix||l_api_name,
671: MESSAGE =>'120: Before update of dates in po headers'||l_deliv_upd_date);
672: END IF;
673: END IF;

Line 685: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

681: last_update_login = FND_GLOBAL.login_id,
682: last_update_date = sysdate
683: WHERE po_header_id = p_po_header_id;
684: IF g_fnd_debug = 'Y' then
685: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
686: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
687: MODULE =>g_module_prefix||l_api_name,
688: MESSAGE =>'200: End: UPDATE_CONTERMS_DATES');
689: END IF;

Line 686: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

682: last_update_date = sysdate
683: WHERE po_header_id = p_po_header_id;
684: IF g_fnd_debug = 'Y' then
685: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
686: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
687: MODULE =>g_module_prefix||l_api_name,
688: MESSAGE =>'200: End: UPDATE_CONTERMS_DATES');
689: END IF;
690:

Line 697: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

693:
694: EXCEPTION
695: WHEN l_Contracts_call_exception then
696: IF g_fnd_debug = 'Y' then
697: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
698: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
699: MODULE =>g_module_prefix||l_api_name,
700: MESSAGE =>'300: End Update_conTerms_dates.In Exception l_Contracts_call_exception');
701: END IF;

Line 698: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

694: EXCEPTION
695: WHEN l_Contracts_call_exception then
696: IF g_fnd_debug = 'Y' then
697: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
698: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
699: MODULE =>g_module_prefix||l_api_name,
700: MESSAGE =>'300: End Update_conTerms_dates.In Exception l_Contracts_call_exception');
701: END IF;
702:

Line 719: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

715:
716: END IF;
717: IF g_fnd_debug = 'Y' then
718: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
719: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
720: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
721: MODULE =>g_module_prefix||l_api_name,
722: MESSAGE =>':Errors in stack-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
723: END IF;

Line 720: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

716: END IF;
717: IF g_fnd_debug = 'Y' then
718: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
719: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
720: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
721: MODULE =>g_module_prefix||l_api_name,
722: MESSAGE =>':Errors in stack-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
723: END IF;
724: END LOOP;

Line 729: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

725:
726: END IF;
727: WHEN OTHERS THEN
728: IF g_fnd_debug = 'Y' then
729: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
730: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
731: MODULE =>g_module_prefix||l_api_name,
732: MESSAGE =>'400: End Update_conTerms_dates.In Exception OTHERS');
733: END IF;

Line 730: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

726: END IF;
727: WHEN OTHERS THEN
728: IF g_fnd_debug = 'Y' then
729: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
730: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
731: MODULE =>g_module_prefix||l_api_name,
732: MESSAGE =>'400: End Update_conTerms_dates.In Exception OTHERS');
733: END IF;
734:

Line 756: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

752: x_msg_data := SQLCODE||':'||SQLERRM;
753: END IF;
754: END IF;
755: IF g_fnd_debug = 'Y' then
756: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
757: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
758: MODULE =>g_module_prefix||l_api_name,
759: MESSAGE =>'410: x_msg_data:'||x_msg_data);
760: END IF;

Line 757: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

753: END IF;
754: END IF;
755: IF g_fnd_debug = 'Y' then
756: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
757: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
758: MODULE =>g_module_prefix||l_api_name,
759: MESSAGE =>'410: x_msg_data:'||x_msg_data);
760: END IF;
761: END IF;

Line 821: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

817: l_signed_records VARCHAR2(1);
818: -- Bug 3652222 END
819: BEGIN
820: IF g_fnd_debug = 'Y' then
821: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
822: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
823: MODULE =>g_module_prefix||l_api_name,
824: MESSAGE =>'10: Start: UPDATE_CONTRACT_TERMS');
825: END IF;

Line 822: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

818: -- Bug 3652222 END
819: BEGIN
820: IF g_fnd_debug = 'Y' then
821: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
822: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
823: MODULE =>g_module_prefix||l_api_name,
824: MESSAGE =>'10: Start: UPDATE_CONTRACT_TERMS');
825: END IF;
826:

Line 846: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

842: FROM po_headers_all
843: WHERE po_header_id = p_po_header_id;
844:
845: IF g_fnd_debug = 'Y' then
846: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
847: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
848: MODULE =>g_module_prefix||l_api_name,
849: MESSAGE =>'30: After Select. Conterms Exist'||l_conterms_exist_flag);
850: END IF;

Line 847: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

843: WHERE po_header_id = p_po_header_id;
844:
845: IF g_fnd_debug = 'Y' then
846: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
847: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
848: MODULE =>g_module_prefix||l_api_name,
849: MESSAGE =>'30: After Select. Conterms Exist'||l_conterms_exist_flag);
850: END IF;
851:

Line 856: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

852: END IF;
853: IF l_conterms_exist_flag = 'Y' then
854:
855: IF g_fnd_debug = 'Y' then
856: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
857: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
858: MODULE =>g_module_prefix||l_api_name,
859: MESSAGE =>'50: Doc type'||l_po_doc_subtype);
860: END IF;

Line 857: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

853: IF l_conterms_exist_flag = 'Y' then
854:
855: IF g_fnd_debug = 'Y' then
856: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
857: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
858: MODULE =>g_module_prefix||l_api_name,
859: MESSAGE =>'50: Doc type'||l_po_doc_subtype);
860: END IF;
861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

857: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
858: MODULE =>g_module_prefix||l_api_name,
859: MESSAGE =>'50: Doc type'||l_po_doc_subtype);
860: END IF;
861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
862: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
863: MODULE =>g_module_prefix||l_api_name,
864: MESSAGE =>'51: po headerid'||p_po_header_id);
865: END IF;

Line 862: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

858: MODULE =>g_module_prefix||l_api_name,
859: MESSAGE =>'50: Doc type'||l_po_doc_subtype);
860: END IF;
861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
862: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
863: MODULE =>g_module_prefix||l_api_name,
864: MESSAGE =>'51: po headerid'||p_po_header_id);
865: END IF;
866: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 866: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

862: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
863: MODULE =>g_module_prefix||l_api_name,
864: MESSAGE =>'51: po headerid'||p_po_header_id);
865: END IF;
866: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
867: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
868: MODULE =>g_module_prefix||l_api_name,
869: MESSAGE =>'54: p_po_revision_num'||l_po_revision_num);
870: END IF;

Line 867: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

863: MODULE =>g_module_prefix||l_api_name,
864: MESSAGE =>'51: po headerid'||p_po_header_id);
865: END IF;
866: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
867: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
868: MODULE =>g_module_prefix||l_api_name,
869: MESSAGE =>'54: p_po_revision_num'||l_po_revision_num);
870: END IF;
871: END IF;

Line 880: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

876: p_doc_subtype => l_po_doc_subtype,
877: x_event_tbl => l_event_tbl);
878: l_k_api_name:='OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables';
879: IF g_fnd_debug = 'Y' then
880: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
881: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
882: MODULE =>g_module_prefix||l_api_name,
883: MESSAGE =>'60: event codes passed for OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
884: END IF;

Line 881: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

877: x_event_tbl => l_event_tbl);
878: l_k_api_name:='OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables';
879: IF g_fnd_debug = 'Y' then
880: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
881: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
882: MODULE =>g_module_prefix||l_api_name,
883: MESSAGE =>'60: event codes passed for OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
884: END IF;
885: IF (l_event_tbl.count>0) THEN

Line 887: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

883: MESSAGE =>'60: event codes passed for OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
884: END IF;
885: IF (l_event_tbl.count>0) THEN
886: FOR l_event in l_event_tbl.FIRST..l_event_tbl.LAST LOOP
887: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
888: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
889: MODULE =>g_module_prefix||l_api_name,
890: MESSAGE =>'event_code'||l_event||' '||l_event_tbl(l_event).event_code
891: ||l_event_tbl(l_event).event_date);

Line 888: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

884: END IF;
885: IF (l_event_tbl.count>0) THEN
886: FOR l_event in l_event_tbl.FIRST..l_event_tbl.LAST LOOP
887: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
888: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
889: MODULE =>g_module_prefix||l_api_name,
890: MESSAGE =>'event_code'||l_event||' '||l_event_tbl(l_event).event_code
891: ||l_event_tbl(l_event).event_date);
892: END IF;

Line 896: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

892: END IF;
893:
894: END LOOP;
895: END IF;--(l_event_tbl.count>0)
896: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
897: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
898: MODULE =>g_module_prefix||l_api_name,
899: MESSAGE =>'70: Before call to OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
900: END IF;

Line 897: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

893:
894: END LOOP;
895: END IF;--(l_event_tbl.count>0)
896: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
897: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
898: MODULE =>g_module_prefix||l_api_name,
899: MESSAGE =>'70: Before call to OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
900: END IF;
901:

Line 916: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

912: x_msg_data => x_msg_data,
913: x_msg_count => x_msg_count,
914: x_return_status => x_return_status);
915: IF g_fnd_debug = 'Y' then
916: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
917: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
918: MODULE =>g_module_prefix||l_api_name,
919: MESSAGE =>'80: After call to OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
920: END IF;

Line 917: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

913: x_msg_count => x_msg_count,
914: x_return_status => x_return_status);
915: IF g_fnd_debug = 'Y' then
916: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
917: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
918: MODULE =>g_module_prefix||l_api_name,
919: MESSAGE =>'80: After call to OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
920: END IF;
921: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 921: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

917: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
918: MODULE =>g_module_prefix||l_api_name,
919: MESSAGE =>'80: After call to OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
920: END IF;
921: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
922: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
923: MODULE =>g_module_prefix||l_api_name,
924: MESSAGE =>'90: return status'||x_return_status);
925: END IF;

Line 922: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

918: MODULE =>g_module_prefix||l_api_name,
919: MESSAGE =>'80: After call to OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables');
920: END IF;
921: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
922: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
923: MODULE =>g_module_prefix||l_api_name,
924: MESSAGE =>'90: return status'||x_return_status);
925: END IF;
926:

Line 942: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

938: p_doc_subtype => l_po_doc_subtype,
939: x_event_tbl => l_event_tbl);
940: l_k_api_name:='OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables';
941: IF g_fnd_debug = 'Y' then
942: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
943: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
944: MODULE =>g_module_prefix||l_api_name,
945: MESSAGE =>'100:Count-event codes passed for OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables:'||l_event_tbl.count);
946: END IF;

Line 943: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

939: x_event_tbl => l_event_tbl);
940: l_k_api_name:='OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables';
941: IF g_fnd_debug = 'Y' then
942: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
943: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
944: MODULE =>g_module_prefix||l_api_name,
945: MESSAGE =>'100:Count-event codes passed for OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables:'||l_event_tbl.count);
946: END IF;
947: END IF;

Line 951: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

947: END IF;
948: IF (l_event_tbl.count>0) THEN
949: IF g_fnd_debug = 'Y' then
950: FOR l_event in l_event_tbl.FIRST..l_event_tbl.LAST LOOP
951: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
952: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
953: MODULE =>g_module_prefix||l_api_name,
954: MESSAGE =>'event_code'||l_event||' '||l_event_tbl(l_event).event_code
955: ||l_event_tbl(l_event).event_date);

Line 952: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

948: IF (l_event_tbl.count>0) THEN
949: IF g_fnd_debug = 'Y' then
950: FOR l_event in l_event_tbl.FIRST..l_event_tbl.LAST LOOP
951: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
952: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
953: MODULE =>g_module_prefix||l_api_name,
954: MESSAGE =>'event_code'||l_event||' '||l_event_tbl(l_event).event_code
955: ||l_event_tbl(l_event).event_date);
956: END IF;

Line 959: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

955: ||l_event_tbl(l_event).event_date);
956: END IF;
957:
958: END LOOP;
959: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
960: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
961: MODULE =>g_module_prefix||l_api_name,
962: MESSAGE =>'110: Before call to OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
963: END IF;

Line 960: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

956: END IF;
957:
958: END LOOP;
959: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
960: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
961: MODULE =>g_module_prefix||l_api_name,
962: MESSAGE =>'110: Before call to OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
963: END IF;
964:

Line 976: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

972: x_msg_data => x_msg_data,
973: x_msg_count => x_msg_count,
974: x_return_status => x_return_status);
975: IF g_fnd_debug = 'Y' then
976: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
977: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
978: MODULE =>g_module_prefix||l_api_name,
979: MESSAGE =>'120: After call to OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
980: END IF;

Line 977: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

973: x_msg_count => x_msg_count,
974: x_return_status => x_return_status);
975: IF g_fnd_debug = 'Y' then
976: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
977: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
978: MODULE =>g_module_prefix||l_api_name,
979: MESSAGE =>'120: After call to OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
980: END IF;
981: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 981: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

977: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
978: MODULE =>g_module_prefix||l_api_name,
979: MESSAGE =>'120: After call to OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
980: END IF;
981: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
982: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
983: MODULE =>g_module_prefix||l_api_name,
984: MESSAGE =>'130: Return Status'|| x_return_status);
985: END IF;

Line 982: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

978: MODULE =>g_module_prefix||l_api_name,
979: MESSAGE =>'120: After call to OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
980: END IF;
981: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
982: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
983: MODULE =>g_module_prefix||l_api_name,
984: MESSAGE =>'130: Return Status'|| x_return_status);
985: END IF;
986:

Line 1025: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1021: -- Bug 3652222 END
1022:
1023: -- Disable the deliverables attached to previous revision of PO
1024: IF g_fnd_debug = 'Y' then
1025: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1026: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1027: MODULE =>g_module_prefix||l_api_name,
1028: MESSAGE =>'140: Before call to OKC_MANAGE_DELIVERABLES_GRP.DisableDeliverables');
1029: END IF;

Line 1026: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1022:
1023: -- Disable the deliverables attached to previous revision of PO
1024: IF g_fnd_debug = 'Y' then
1025: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1026: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1027: MODULE =>g_module_prefix||l_api_name,
1028: MESSAGE =>'140: Before call to OKC_MANAGE_DELIVERABLES_GRP.DisableDeliverables');
1029: END IF;
1030:

Line 1044: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1040: x_msg_data => x_msg_data,
1041: x_msg_count => x_msg_count,
1042: x_return_status => x_return_status);
1043: IF g_fnd_debug = 'Y' then
1044: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1045: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1046: MODULE =>g_module_prefix||l_api_name,
1047: MESSAGE =>'150: After call to OKC_MANAGE_DELIVERABLES_GRP.DisableDeliverables');
1048: END IF;

Line 1045: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1041: x_msg_count => x_msg_count,
1042: x_return_status => x_return_status);
1043: IF g_fnd_debug = 'Y' then
1044: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1045: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1046: MODULE =>g_module_prefix||l_api_name,
1047: MESSAGE =>'150: After call to OKC_MANAGE_DELIVERABLES_GRP.DisableDeliverables');
1048: END IF;
1049: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 1049: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1045: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1046: MODULE =>g_module_prefix||l_api_name,
1047: MESSAGE =>'150: After call to OKC_MANAGE_DELIVERABLES_GRP.DisableDeliverables');
1048: END IF;
1049: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1050: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1051: MODULE =>g_module_prefix||l_api_name,
1052: MESSAGE =>'170: return status'||x_return_status);
1053: END IF;

Line 1050: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1046: MODULE =>g_module_prefix||l_api_name,
1047: MESSAGE =>'150: After call to OKC_MANAGE_DELIVERABLES_GRP.DisableDeliverables');
1048: END IF;
1049: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1050: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1051: MODULE =>g_module_prefix||l_api_name,
1052: MESSAGE =>'170: return status'||x_return_status);
1053: END IF;
1054:

Line 1068: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1064: -- cancel deliverables only if po is being archived after cancel
1065: IF (UPPER(NVL(l_cancel_flag, 'N'))='Y') THEN
1066:
1067: IF g_fnd_debug = 'Y' then
1068: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1069: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1070: MODULE =>g_module_prefix||l_api_name,
1071: MESSAGE =>'180: Before call to wrapper procedure to Cancel Deliverables');
1072: END IF;

Line 1069: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1065: IF (UPPER(NVL(l_cancel_flag, 'N'))='Y') THEN
1066:
1067: IF g_fnd_debug = 'Y' then
1068: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1069: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1070: MODULE =>g_module_prefix||l_api_name,
1071: MESSAGE =>'180: Before call to wrapper procedure to Cancel Deliverables');
1072: END IF;
1073:

Line 1085: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1081: ,p_event_date => SYSDATE
1082: ,p_busdocdates_tbl => l_event_tbl
1083: ,x_return_status => x_return_status);
1084: IF g_fnd_debug = 'Y' then
1085: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1086: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1087: MODULE =>g_module_prefix||l_api_name,
1088: MESSAGE =>'190: After call to wrapper procedure to Cancel Deliverables');
1089: END IF;

Line 1086: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1082: ,p_busdocdates_tbl => l_event_tbl
1083: ,x_return_status => x_return_status);
1084: IF g_fnd_debug = 'Y' then
1085: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1086: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1087: MODULE =>g_module_prefix||l_api_name,
1088: MESSAGE =>'190: After call to wrapper procedure to Cancel Deliverables');
1089: END IF;
1090:

Line 1094: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1090:
1091: END IF;
1092:
1093: IF g_fnd_debug = 'Y' then
1094: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1095: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1096: MODULE =>g_module_prefix||l_api_name,
1097: MESSAGE =>'200: return status '||x_return_status);
1098: END IF;

Line 1095: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1091: END IF;
1092:
1093: IF g_fnd_debug = 'Y' then
1094: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1095: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1096: MODULE =>g_module_prefix||l_api_name,
1097: MESSAGE =>'200: return status '||x_return_status);
1098: END IF;
1099:

Line 1112: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1108: END IF;-- If po revision>0
1109:
1110: END IF; -- if conterms exist
1111: IF g_fnd_debug = 'Y' then
1112: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1113: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1114: MODULE =>g_module_prefix||l_api_name,
1115: MESSAGE =>'210: End Update Contract Terms');
1116: END IF;

Line 1113: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1109:
1110: END IF; -- if conterms exist
1111: IF g_fnd_debug = 'Y' then
1112: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1113: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1114: MODULE =>g_module_prefix||l_api_name,
1115: MESSAGE =>'210: End Update Contract Terms');
1116: END IF;
1117:

Line 1122: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1118: END IF;
1119: EXCEPTION
1120: WHEN l_Contracts_call_exception then
1121: IF g_fnd_debug = 'Y' then
1122: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1123: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1124: MODULE =>g_module_prefix||l_api_name,
1125: MESSAGE =>'300: End Update_contract Terms.In Exception l_Contracts_call_exception');
1126: END IF;

Line 1123: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1119: EXCEPTION
1120: WHEN l_Contracts_call_exception then
1121: IF g_fnd_debug = 'Y' then
1122: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1123: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1124: MODULE =>g_module_prefix||l_api_name,
1125: MESSAGE =>'300: End Update_contract Terms.In Exception l_Contracts_call_exception');
1126: END IF;
1127: END IF;

Line 1143: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1139:
1140: END IF;
1141: IF g_fnd_debug = 'Y' then
1142: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1143: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1144: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1145: MODULE =>g_module_prefix||l_api_name,
1146: MESSAGE =>':Errors in stack-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1147: END IF;

Line 1144: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,

1140: END IF;
1141: IF g_fnd_debug = 'Y' then
1142: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
1143: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1144: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_STATEMENT,
1145: MODULE =>g_module_prefix||l_api_name,
1146: MESSAGE =>':Errors in stack-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));
1147: END IF;
1148: END LOOP;

Line 1166: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1162: (p_count => x_msg_count,
1163: p_data => x_msg_data );
1164:
1165: IF g_fnd_debug = 'Y' then
1166: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1167: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1168: MODULE =>g_module_prefix||l_api_name,
1169: MESSAGE =>'400: End Update_contract_terms.In Exception others');
1170: END IF;

Line 1167: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1163: p_data => x_msg_data );
1164:
1165: IF g_fnd_debug = 'Y' then
1166: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1167: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1168: MODULE =>g_module_prefix||l_api_name,
1169: MESSAGE =>'400: End Update_contract_terms.In Exception others');
1170: END IF;
1171: END IF;

Line 1180: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1176: x_msg_data := SQLCODE||':'||SQLERRM;
1177: END IF;
1178: END IF;
1179: IF g_fnd_debug = 'Y' then
1180: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1181: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1182: MODULE =>g_module_prefix||l_api_name,
1183: MESSAGE =>'410: sql error:'||SQLCODE||':'||SQLERRM);
1184: END IF;

Line 1181: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1177: END IF;
1178: END IF;
1179: IF g_fnd_debug = 'Y' then
1180: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1181: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1182: MODULE =>g_module_prefix||l_api_name,
1183: MESSAGE =>'410: sql error:'||SQLCODE||':'||SQLERRM);
1184: END IF;
1185: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

Line 1185: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

1181: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1182: MODULE =>g_module_prefix||l_api_name,
1183: MESSAGE =>'410: sql error:'||SQLCODE||':'||SQLERRM);
1184: END IF;
1185: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1186: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1187: MODULE =>g_module_prefix||l_api_name,
1188: MESSAGE =>'420: x_msg_data:'||x_msg_data);
1189: END IF;

Line 1186: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,

1182: MODULE =>g_module_prefix||l_api_name,
1183: MESSAGE =>'410: sql error:'||SQLCODE||':'||SQLERRM);
1184: END IF;
1185: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
1186: FND_LOG.string(LOG_LEVEL=>FND_LOG.LEVEL_EXCEPTION,
1187: MODULE =>g_module_prefix||l_api_name,
1188: MESSAGE =>'420: x_msg_data:'||x_msg_data);
1189: END IF;
1190: END IF;

Line 2206: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2202:
2203: l_contracts_document_type := p_bus_doc_type||'_'||p_bus_doc_subtype;
2204:
2205: IF (g_fnd_debug = 'Y') THEN
2206: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2207: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE
2208: ,module => g_module_prefix || l_api_name
2209: ,message => 'Before calling contracts API to cancel deliverables');
2210: END IF;

Line 2207: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE

2203: l_contracts_document_type := p_bus_doc_type||'_'||p_bus_doc_subtype;
2204:
2205: IF (g_fnd_debug = 'Y') THEN
2206: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2207: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE
2208: ,module => g_module_prefix || l_api_name
2209: ,message => 'Before calling contracts API to cancel deliverables');
2210: END IF;
2211: END IF;

Line 2233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2230: END IF;
2231:
2232: IF (g_fnd_debug = 'Y') THEN
2233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2234: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE
2235: ,module => g_module_prefix || l_api_name
2236: ,message => 'Deliverables cancelled successfully');
2237: END IF;

Line 2234: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE

2230: END IF;
2231:
2232: IF (g_fnd_debug = 'Y') THEN
2233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2234: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE
2235: ,module => g_module_prefix || l_api_name
2236: ,message => 'Deliverables cancelled successfully');
2237: END IF;
2238: END IF;

Line 2243: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2239:
2240: EXCEPTION
2241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2242: IF (g_fnd_debug = 'Y') THEN
2243: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2244: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE
2245: ,module => g_module_prefix || l_api_name
2246: ,message => l_msg_data);
2247: END IF;

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

2240: EXCEPTION
2241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2242: IF (g_fnd_debug = 'Y') THEN
2243: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2244: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE
2245: ,module => g_module_prefix || l_api_name
2246: ,message => l_msg_data);
2247: END IF;
2248: END IF;

Line 2254: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

2250: WHEN OTHERS THEN
2251: ROLLBACK;
2252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2253: IF (g_fnd_debug = 'Y') THEN
2254: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2255: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE
2256: ,module => g_module_prefix || l_api_name
2257: ,message => 'Others Exception');
2258: END IF;

Line 2255: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE

2251: ROLLBACK;
2252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2253: IF (g_fnd_debug = 'Y') THEN
2254: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2255: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE
2256: ,module => g_module_prefix || l_api_name
2257: ,message => 'Others Exception');
2258: END IF;
2259: END IF;