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.DOM_DOCUMENT_UTIL dependencies on DOM_LOG

Line 103: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN

99:
100:
101:
102:
103: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
104: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
105: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
106: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
107: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );

Line 104: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);

100:
101:
102:
103: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
104: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
105: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
106: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
107: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
108: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Action Type : ' || p_action_type);

Line 105: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

101:
102:
103: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
104: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
105: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
106: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
107: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
108: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Action Type : ' || p_action_type);
109: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);

Line 106: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );

102:
103: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
104: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
105: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
106: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
107: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
108: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Action Type : ' || p_action_type);
109: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
110: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

Line 107: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );

103: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
104: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
105: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
106: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
107: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
108: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Action Type : ' || p_action_type);
109: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
110: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
111: END IF ;

Line 108: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Action Type : ' || p_action_type);

104: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
105: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
106: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
107: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
108: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Action Type : ' || p_action_type);
109: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
110: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
111: END IF ;
112:

Line 109: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);

105: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
106: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
107: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
108: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Action Type : ' || p_action_type);
109: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
110: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
111: END IF ;
112:
113:

Line 110: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

106: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
107: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
108: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Action Type : ' || p_action_type);
109: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
110: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
111: END IF ;
112:
113:
114:

Line 133: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN

129:
130:
131:
132:
133: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
134: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'End ' || l_api_name);
135: END IF ;
136:
137:

Line 134: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'End ' || l_api_name);

130:
131:
132:
133: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
134: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'End ' || l_api_name);
135: END IF ;
136:
137:
138:

Line 212: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN

208:
209:
210:
211:
212: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
213: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
214: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
215: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
216: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Approval Status : ' || TO_CHAR(p_approval_status) );

Line 213: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);

209:
210:
211:
212: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
213: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
214: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
215: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
216: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Approval Status : ' || TO_CHAR(p_approval_status) );
217: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'WF Route Status : ' || p_wf_route_status);

Line 214: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

210:
211:
212: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
213: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
214: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
215: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
216: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Approval Status : ' || TO_CHAR(p_approval_status) );
217: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'WF Route Status : ' || p_wf_route_status);
218: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);

Line 215: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );

211:
212: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
213: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
214: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
215: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
216: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Approval Status : ' || TO_CHAR(p_approval_status) );
217: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'WF Route Status : ' || p_wf_route_status);
218: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
219: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

Line 216: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Approval Status : ' || TO_CHAR(p_approval_status) );

212: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
213: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
214: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
215: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
216: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Approval Status : ' || TO_CHAR(p_approval_status) );
217: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'WF Route Status : ' || p_wf_route_status);
218: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
219: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
220: END IF ;

Line 217: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'WF Route Status : ' || p_wf_route_status);

213: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
214: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
215: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
216: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Approval Status : ' || TO_CHAR(p_approval_status) );
217: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'WF Route Status : ' || p_wf_route_status);
218: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
219: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
220: END IF ;
221:

Line 218: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);

214: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
215: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
216: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Approval Status : ' || TO_CHAR(p_approval_status) );
217: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'WF Route Status : ' || p_wf_route_status);
218: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
219: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
220: END IF ;
221:
222:

Line 219: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

215: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
216: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Approval Status : ' || TO_CHAR(p_approval_status) );
217: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'WF Route Status : ' || p_wf_route_status);
218: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
219: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
220: END IF ;
221:
222:
223: -- Initialize API return status to success

Line 326: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN

322: ( p_count => x_msg_count,
323: p_data => x_msg_data );
324:
325:
326: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
327: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'End ' || l_api_name);
328: END IF ;
329:
330:

Line 327: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'End ' || l_api_name);

323: p_data => x_msg_data );
324:
325:
326: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
327: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'End ' || l_api_name);
328: END IF ;
329:
330:
331:

Line 413: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN

409: -- Initialize API return status to success
410: x_return_status := FND_API.G_RET_STS_SUCCESS;
411:
412:
413: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
414: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
415: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
416: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
417: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );

Line 414: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);

410: x_return_status := FND_API.G_RET_STS_SUCCESS;
411:
412:
413: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
414: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
415: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
416: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
417: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
418: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );

Line 415: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

411:
412:
413: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
414: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
415: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
416: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
417: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
418: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
419: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);

Line 416: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );

412:
413: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
414: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
415: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
416: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
417: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
418: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
419: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
420: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

Line 417: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );

413: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
414: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
415: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
416: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
417: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
418: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
419: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
420: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
421: END IF ;

Line 418: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );

414: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);
415: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
416: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
417: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
418: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
419: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
420: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
421: END IF ;
422:

Line 419: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);

415: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
416: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
417: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
418: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
419: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
420: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
421: END IF ;
422:
423:

Line 420: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

416: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
417: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
418: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
419: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
420: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
421: END IF ;
422:
423:
424: -----------------------------------------------------------------

Line 440: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN

436: , x_lc_phase_display_name => l_lc_phase_display_name
437: ) ;
438:
439:
440: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
441: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Got Document LC Info' );
442: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
443: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Id : ' || TO_CHAR(l_document_id) );
444: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Rev Id : ' || TO_CHAR(l_document_revision_id) );

Line 441: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Got Document LC Info' );

437: ) ;
438:
439:
440: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
441: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Got Document LC Info' );
442: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
443: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Id : ' || TO_CHAR(l_document_id) );
444: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Rev Id : ' || TO_CHAR(l_document_revision_id) );
445: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Check Out Status : ' || l_checkout_status);

Line 442: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

438:
439:
440: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
441: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Got Document LC Info' );
442: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
443: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Id : ' || TO_CHAR(l_document_id) );
444: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Rev Id : ' || TO_CHAR(l_document_revision_id) );
445: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Check Out Status : ' || l_checkout_status);
446: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Seq Num : ' || TO_CHAR(l_lc_sequence_number) );

Line 443: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Id : ' || TO_CHAR(l_document_id) );

439:
440: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
441: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Got Document LC Info' );
442: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
443: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Id : ' || TO_CHAR(l_document_id) );
444: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Rev Id : ' || TO_CHAR(l_document_revision_id) );
445: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Check Out Status : ' || l_checkout_status);
446: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Seq Num : ' || TO_CHAR(l_lc_sequence_number) );
447: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(l_lc_phase_code) );

Line 444: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Rev Id : ' || TO_CHAR(l_document_revision_id) );

440: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
441: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Got Document LC Info' );
442: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
443: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Id : ' || TO_CHAR(l_document_id) );
444: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Rev Id : ' || TO_CHAR(l_document_revision_id) );
445: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Check Out Status : ' || l_checkout_status);
446: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Seq Num : ' || TO_CHAR(l_lc_sequence_number) );
447: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(l_lc_phase_code) );
448: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Type : ' || TO_CHAR(l_lc_phase_type) );

Line 445: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Check Out Status : ' || l_checkout_status);

441: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Got Document LC Info' );
442: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
443: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Id : ' || TO_CHAR(l_document_id) );
444: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Rev Id : ' || TO_CHAR(l_document_revision_id) );
445: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Check Out Status : ' || l_checkout_status);
446: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Seq Num : ' || TO_CHAR(l_lc_sequence_number) );
447: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(l_lc_phase_code) );
448: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Type : ' || TO_CHAR(l_lc_phase_type) );
449: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Display : ' || l_lc_phase_display_name );

Line 446: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Seq Num : ' || TO_CHAR(l_lc_sequence_number) );

442: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
443: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Id : ' || TO_CHAR(l_document_id) );
444: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Rev Id : ' || TO_CHAR(l_document_revision_id) );
445: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Check Out Status : ' || l_checkout_status);
446: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Seq Num : ' || TO_CHAR(l_lc_sequence_number) );
447: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(l_lc_phase_code) );
448: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Type : ' || TO_CHAR(l_lc_phase_type) );
449: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Display : ' || l_lc_phase_display_name );
450: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

Line 447: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(l_lc_phase_code) );

443: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Id : ' || TO_CHAR(l_document_id) );
444: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Rev Id : ' || TO_CHAR(l_document_revision_id) );
445: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Check Out Status : ' || l_checkout_status);
446: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Seq Num : ' || TO_CHAR(l_lc_sequence_number) );
447: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(l_lc_phase_code) );
448: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Type : ' || TO_CHAR(l_lc_phase_type) );
449: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Display : ' || l_lc_phase_display_name );
450: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
451: END IF ;

Line 448: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Type : ' || TO_CHAR(l_lc_phase_type) );

444: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document Rev Id : ' || TO_CHAR(l_document_revision_id) );
445: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Check Out Status : ' || l_checkout_status);
446: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Seq Num : ' || TO_CHAR(l_lc_sequence_number) );
447: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(l_lc_phase_code) );
448: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Type : ' || TO_CHAR(l_lc_phase_type) );
449: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Display : ' || l_lc_phase_display_name );
450: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
451: END IF ;
452:

Line 449: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Display : ' || l_lc_phase_display_name );

445: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Check Out Status : ' || l_checkout_status);
446: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Seq Num : ' || TO_CHAR(l_lc_sequence_number) );
447: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(l_lc_phase_code) );
448: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Type : ' || TO_CHAR(l_lc_phase_type) );
449: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Display : ' || l_lc_phase_display_name );
450: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
451: END IF ;
452:
453:

Line 450: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

446: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Seq Num : ' || TO_CHAR(l_lc_sequence_number) );
447: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(l_lc_phase_code) );
448: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Type : ' || TO_CHAR(l_lc_phase_type) );
449: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Display : ' || l_lc_phase_display_name );
450: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
451: END IF ;
452:
453:
454: IF l_checkout_status IS NOT NULL

Line 465: IF DOM_LOG.CHECK_LOG_LEVEL THEN

461: , G_PHASE_TYPE_ARCHIVE
462: )
463: THEN
464:
465: IF DOM_LOG.CHECK_LOG_LEVEL THEN
466: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document LC Workflow cannot be started in this status') ;
467: END IF ;
468:
469: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 466: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document LC Workflow cannot be started in this status') ;

462: )
463: THEN
464:
465: IF DOM_LOG.CHECK_LOG_LEVEL THEN
466: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document LC Workflow cannot be started in this status') ;
467: END IF ;
468:
469: x_return_status := FND_API.G_RET_STS_ERROR ;
470: FND_MESSAGE.SET_NAME('DOM', 'DOM_LC_WF_CANNOT_START') ;

Line 487: IF DOM_LOG.CHECK_LOG_LEVEL THEN

483:
484: -- Standard check of p_commit.
485: IF FND_API.To_Boolean( p_commit ) THEN
486:
487: IF DOM_LOG.CHECK_LOG_LEVEL THEN
488: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Do Commit.') ;
489: END IF ;
490:
491: COMMIT WORK;

Line 488: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Do Commit.') ;

484: -- Standard check of p_commit.
485: IF FND_API.To_Boolean( p_commit ) THEN
486:
487: IF DOM_LOG.CHECK_LOG_LEVEL THEN
488: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Do Commit.') ;
489: END IF ;
490:
491: COMMIT WORK;
492: END IF;

Line 500: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN

496: ( p_count => x_msg_count
497: , p_data => x_msg_data
498: );
499:
500: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
501: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'end ' || l_api_name);
502: END IF ;
503:
504:

Line 501: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'end ' || l_api_name);

497: , p_data => x_msg_data
498: );
499:
500: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
501: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'end ' || l_api_name);
502: END IF ;
503:
504:
505: EXCEPTION

Line 510: IF DOM_LOG.CHECK_LOG_LEVEL THEN

506: WHEN FND_API.G_EXC_ERROR THEN
507: -- Standard check of p_commit.
508: IF FND_API.To_Boolean( p_commit ) THEN
509:
510: IF DOM_LOG.CHECK_LOG_LEVEL THEN
511: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
512: END IF ;
513: ROLLBACK TO l_api_name ;
514: END IF;

Line 511: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;

507: -- Standard check of p_commit.
508: IF FND_API.To_Boolean( p_commit ) THEN
509:
510: IF DOM_LOG.CHECK_LOG_LEVEL THEN
511: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
512: END IF ;
513: ROLLBACK TO l_api_name ;
514: END IF;
515:

Line 523: IF DOM_LOG.CHECK_LOG_LEVEL THEN

519: ( p_count => x_msg_count
520: , p_data => x_msg_data
521: );
522:
523: IF DOM_LOG.CHECK_LOG_LEVEL THEN
524: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'RollBack and Finish with Error.') ;
525: END IF ;
526:
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 524: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'RollBack and Finish with Error.') ;

520: , p_data => x_msg_data
521: );
522:
523: IF DOM_LOG.CHECK_LOG_LEVEL THEN
524: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'RollBack and Finish with Error.') ;
525: END IF ;
526:
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: IF FND_API.To_Boolean( p_commit ) THEN

Line 530: IF DOM_LOG.CHECK_LOG_LEVEL THEN

526:
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: IF FND_API.To_Boolean( p_commit ) THEN
529:
530: IF DOM_LOG.CHECK_LOG_LEVEL THEN
531: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
532: END IF ;
533: ROLLBACK TO l_api_name ;
534: END IF;

Line 531: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;

527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: IF FND_API.To_Boolean( p_commit ) THEN
529:
530: IF DOM_LOG.CHECK_LOG_LEVEL THEN
531: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
532: END IF ;
533: ROLLBACK TO l_api_name ;
534: END IF;
535:

Line 543: IF DOM_LOG.CHECK_LOG_LEVEL THEN

539: ( p_count => x_msg_count
540: , p_data => x_msg_data
541: );
542:
543: IF DOM_LOG.CHECK_LOG_LEVEL THEN
544: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and Finish with unxepcted error.') ;
545: END IF ;
546:
547: WHEN OTHERS THEN

Line 544: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and Finish with unxepcted error.') ;

540: , p_data => x_msg_data
541: );
542:
543: IF DOM_LOG.CHECK_LOG_LEVEL THEN
544: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and Finish with unxepcted error.') ;
545: END IF ;
546:
547: WHEN OTHERS THEN
548: IF FND_API.To_Boolean( p_commit ) THEN

Line 549: IF DOM_LOG.CHECK_LOG_LEVEL THEN

545: END IF ;
546:
547: WHEN OTHERS THEN
548: IF FND_API.To_Boolean( p_commit ) THEN
549: IF DOM_LOG.CHECK_LOG_LEVEL THEN
550: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
551: END IF ;
552: ROLLBACK TO l_api_name ;
553: END IF;

Line 550: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;

546:
547: WHEN OTHERS THEN
548: IF FND_API.To_Boolean( p_commit ) THEN
549: IF DOM_LOG.CHECK_LOG_LEVEL THEN
550: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
551: END IF ;
552: ROLLBACK TO l_api_name ;
553: END IF;
554:

Line 576: IF DOM_LOG.CHECK_LOG_LEVEL THEN

572: ( p_count => x_msg_count
573: , p_data => x_msg_data
574: );
575:
576: IF DOM_LOG.CHECK_LOG_LEVEL THEN
577: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and finish with system unxepcted error: '
578: || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
579: END IF ;
580:

Line 577: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and finish with system unxepcted error: '

573: , p_data => x_msg_data
574: );
575:
576: IF DOM_LOG.CHECK_LOG_LEVEL THEN
577: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and finish with system unxepcted error: '
578: || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
579: END IF ;
580:
581:

Line 634: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN

630: -- Initialize API return status to success
631: x_return_status := FND_API.G_RET_STS_SUCCESS;
632:
633:
634: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
635: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'begin ' || l_api_name);
636: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
637: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
638: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );

Line 635: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'begin ' || l_api_name);

631: x_return_status := FND_API.G_RET_STS_SUCCESS;
632:
633:
634: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
635: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'begin ' || l_api_name);
636: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
637: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
638: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
639: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );

Line 636: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

632:
633:
634: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
635: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'begin ' || l_api_name);
636: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
637: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
638: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
639: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
640: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);

Line 637: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );

633:
634: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
635: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'begin ' || l_api_name);
636: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
637: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
638: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
639: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
640: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
641: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

Line 638: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );

634: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
635: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'begin ' || l_api_name);
636: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
637: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
638: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
639: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
640: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
641: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
642: END IF ;

Line 639: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );

635: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'begin ' || l_api_name);
636: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
637: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
638: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
639: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
640: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
641: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
642: END IF ;
643:

Line 640: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);

636: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
637: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
638: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
639: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
640: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
641: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
642: END IF ;
643:
644:

Line 641: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');

637: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Change Id : ' || TO_CHAR(p_change_id) );
638: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Route Id : ' || TO_CHAR(p_route_id) );
639: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
640: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'API Caller : ' || p_api_caller);
641: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'-----------------------------------------------------');
642: END IF ;
643:
644:
645: -----------------------------------------------------------------

Line 657: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN

653: -----------------------------------------------------------------
654: -- End of API body
655: -----------------------------------------------------------------
656:
657: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
658: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'end ' || l_api_name);
659: END IF ;
660:
661:

Line 658: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'end ' || l_api_name);

654: -- End of API body
655: -----------------------------------------------------------------
656:
657: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
658: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'end ' || l_api_name);
659: END IF ;
660:
661:
662: -- Standard check of p_commit.

Line 665: IF DOM_LOG.CHECK_LOG_LEVEL THEN

661:
662: -- Standard check of p_commit.
663: IF FND_API.To_Boolean( p_commit ) THEN
664:
665: IF DOM_LOG.CHECK_LOG_LEVEL THEN
666: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Do Commit.') ;
667: END IF ;
668:
669: COMMIT WORK;

Line 666: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Do Commit.') ;

662: -- Standard check of p_commit.
663: IF FND_API.To_Boolean( p_commit ) THEN
664:
665: IF DOM_LOG.CHECK_LOG_LEVEL THEN
666: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Do Commit.') ;
667: END IF ;
668:
669: COMMIT WORK;
670: END IF;

Line 678: IF DOM_LOG.CHECK_LOG_LEVEL THEN

674: ( p_count => x_msg_count
675: , p_data => x_msg_data
676: );
677:
678: IF DOM_LOG.CHECK_LOG_LEVEL THEN
679: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Finish. Eng Of Proc') ;
680: END IF ;
681:
682:

Line 679: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Finish. Eng Of Proc') ;

675: , p_data => x_msg_data
676: );
677:
678: IF DOM_LOG.CHECK_LOG_LEVEL THEN
679: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Finish. Eng Of Proc') ;
680: END IF ;
681:
682:
683: EXCEPTION

Line 687: IF DOM_LOG.CHECK_LOG_LEVEL THEN

683: EXCEPTION
684: WHEN FND_API.G_EXC_ERROR THEN
685: -- Standard check of p_commit.
686: IF FND_API.To_Boolean( p_commit ) THEN
687: IF DOM_LOG.CHECK_LOG_LEVEL THEN
688: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
689: END IF ;
690: ROLLBACK TO l_api_name ;
691: END IF;

Line 688: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;

684: WHEN FND_API.G_EXC_ERROR THEN
685: -- Standard check of p_commit.
686: IF FND_API.To_Boolean( p_commit ) THEN
687: IF DOM_LOG.CHECK_LOG_LEVEL THEN
688: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
689: END IF ;
690: ROLLBACK TO l_api_name ;
691: END IF;
692:

Line 700: IF DOM_LOG.CHECK_LOG_LEVEL THEN

696: ( p_count => x_msg_count
697: , p_data => x_msg_data
698: );
699:
700: IF DOM_LOG.CHECK_LOG_LEVEL THEN
701: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'RollBack and Finish with Error.') ;
702: END IF ;
703:
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 701: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'RollBack and Finish with Error.') ;

697: , p_data => x_msg_data
698: );
699:
700: IF DOM_LOG.CHECK_LOG_LEVEL THEN
701: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'RollBack and Finish with Error.') ;
702: END IF ;
703:
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: IF FND_API.To_Boolean( p_commit ) THEN

Line 706: IF DOM_LOG.CHECK_LOG_LEVEL THEN

702: END IF ;
703:
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: IF FND_API.To_Boolean( p_commit ) THEN
706: IF DOM_LOG.CHECK_LOG_LEVEL THEN
707: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
708: END IF ;
709: ROLLBACK TO l_api_name ;
710: END IF;

Line 707: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;

703:
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: IF FND_API.To_Boolean( p_commit ) THEN
706: IF DOM_LOG.CHECK_LOG_LEVEL THEN
707: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
708: END IF ;
709: ROLLBACK TO l_api_name ;
710: END IF;
711:

Line 719: IF DOM_LOG.CHECK_LOG_LEVEL THEN

715: ( p_count => x_msg_count
716: , p_data => x_msg_data
717: );
718:
719: IF DOM_LOG.CHECK_LOG_LEVEL THEN
720: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and Finish with unxepcted error.') ;
721: END IF ;
722:
723: WHEN OTHERS THEN

Line 720: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and Finish with unxepcted error.') ;

716: , p_data => x_msg_data
717: );
718:
719: IF DOM_LOG.CHECK_LOG_LEVEL THEN
720: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and Finish with unxepcted error.') ;
721: END IF ;
722:
723: WHEN OTHERS THEN
724: IF FND_API.To_Boolean( p_commit ) THEN

Line 725: IF DOM_LOG.CHECK_LOG_LEVEL THEN

721: END IF ;
722:
723: WHEN OTHERS THEN
724: IF FND_API.To_Boolean( p_commit ) THEN
725: IF DOM_LOG.CHECK_LOG_LEVEL THEN
726: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
727: END IF ;
728: ROLLBACK TO l_api_name ;
729: END IF;

Line 726: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;

722:
723: WHEN OTHERS THEN
724: IF FND_API.To_Boolean( p_commit ) THEN
725: IF DOM_LOG.CHECK_LOG_LEVEL THEN
726: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
727: END IF ;
728: ROLLBACK TO l_api_name ;
729: END IF;
730:

Line 752: IF DOM_LOG.CHECK_LOG_LEVEL THEN

748: ( p_count => x_msg_count
749: , p_data => x_msg_data
750: );
751:
752: IF DOM_LOG.CHECK_LOG_LEVEL THEN
753: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and finish with system unxepcted error: '
754: || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
755: END IF ;
756:

Line 753: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and finish with system unxepcted error: '

749: , p_data => x_msg_data
750: );
751:
752: IF DOM_LOG.CHECK_LOG_LEVEL THEN
753: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and finish with system unxepcted error: '
754: || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
755: END IF ;
756:
757: