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.WSH_ITM_RESUBMIT dependencies on WSH_UTIL_CORE

Line 45: l_varchar_status_tab WSH_UTIL_CORE.Column_Tab_Type;

41: l_old_status VARCHAR2(30);
42: l_new_status VARCHAR2(30);
43: l_default_status VARCHAR2(100);
44: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;
45: l_varchar_status_tab WSH_UTIL_CORE.Column_Tab_Type;
46: l_num_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
47: l_logged_at_location_id number ;
48: l_exception_location_id number;
49: L_EXCEPTION_MESSAGE VARCHAR2(200);

Line 46: l_num_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;

42: l_new_status VARCHAR2(30);
43: l_default_status VARCHAR2(100);
44: l_validation_level NUMBER default FND_API.G_VALID_LEVEL_FULL;
45: l_varchar_status_tab WSH_UTIL_CORE.Column_Tab_Type;
46: l_num_delivery_id_tab WSH_UTIL_CORE.Id_Tab_Type;
47: l_logged_at_location_id number ;
48: l_exception_location_id number;
49: L_EXCEPTION_MESSAGE VARCHAR2(200);
50: l_delivery_id number;

Line 76: WSH_UTIL_CORE.println('Start of Handle exception for the request control id'||p_request_control_id);

72: ORDER BY wex.creation_date;
73:
74: BEGIN
75:
76: WSH_UTIL_CORE.println('Start of Handle exception for the request control id'||p_request_control_id);
77: WSH_UTIL_CORE.println('Closes all failed exception for that request control id and logs another submit exception for it');
78:
79: l_flag :=FALSE;
80:

Line 77: WSH_UTIL_CORE.println('Closes all failed exception for that request control id and logs another submit exception for it');

73:
74: BEGIN
75:
76: WSH_UTIL_CORE.println('Start of Handle exception for the request control id'||p_request_control_id);
77: WSH_UTIL_CORE.println('Closes all failed exception for that request control id and logs another submit exception for it');
78:
79: l_flag :=FALSE;
80:
81: OPEN DELIVERY_RESUBMIT(p_request_control_id);

Line 95: WSH_UTIL_CORE.println('Exception id :'||l_exception_id);

91:
92: EXIT WHEN DELIVERY_RESUBMIT%NOTFOUND;
93:
94:
95: WSH_UTIL_CORE.println('Exception id :'||l_exception_id);
96: WSH_UTIL_CORE.println('The status :'||l_status);
97: WSH_UTIL_CORE.println('Location id :'||l_logged_at_location_id);
98: WSH_UTIL_CORE.println('Exception location id :'||l_exception_location_id);
99: WSH_UTIL_CORE.println('Delivery id :'||l_delivery_id);

Line 96: WSH_UTIL_CORE.println('The status :'||l_status);

92: EXIT WHEN DELIVERY_RESUBMIT%NOTFOUND;
93:
94:
95: WSH_UTIL_CORE.println('Exception id :'||l_exception_id);
96: WSH_UTIL_CORE.println('The status :'||l_status);
97: WSH_UTIL_CORE.println('Location id :'||l_logged_at_location_id);
98: WSH_UTIL_CORE.println('Exception location id :'||l_exception_location_id);
99: WSH_UTIL_CORE.println('Delivery id :'||l_delivery_id);
100: WSH_UTIL_CORE.println('Delivery name :'||l_delivery_name);

Line 97: WSH_UTIL_CORE.println('Location id :'||l_logged_at_location_id);

93:
94:
95: WSH_UTIL_CORE.println('Exception id :'||l_exception_id);
96: WSH_UTIL_CORE.println('The status :'||l_status);
97: WSH_UTIL_CORE.println('Location id :'||l_logged_at_location_id);
98: WSH_UTIL_CORE.println('Exception location id :'||l_exception_location_id);
99: WSH_UTIL_CORE.println('Delivery id :'||l_delivery_id);
100: WSH_UTIL_CORE.println('Delivery name :'||l_delivery_name);
101:

Line 98: WSH_UTIL_CORE.println('Exception location id :'||l_exception_location_id);

94:
95: WSH_UTIL_CORE.println('Exception id :'||l_exception_id);
96: WSH_UTIL_CORE.println('The status :'||l_status);
97: WSH_UTIL_CORE.println('Location id :'||l_logged_at_location_id);
98: WSH_UTIL_CORE.println('Exception location id :'||l_exception_location_id);
99: WSH_UTIL_CORE.println('Delivery id :'||l_delivery_id);
100: WSH_UTIL_CORE.println('Delivery name :'||l_delivery_name);
101:
102: l_msg_data := NULL;

Line 99: WSH_UTIL_CORE.println('Delivery id :'||l_delivery_id);

95: WSH_UTIL_CORE.println('Exception id :'||l_exception_id);
96: WSH_UTIL_CORE.println('The status :'||l_status);
97: WSH_UTIL_CORE.println('Location id :'||l_logged_at_location_id);
98: WSH_UTIL_CORE.println('Exception location id :'||l_exception_location_id);
99: WSH_UTIL_CORE.println('Delivery id :'||l_delivery_id);
100: WSH_UTIL_CORE.println('Delivery name :'||l_delivery_name);
101:
102: l_msg_data := NULL;
103: l_old_status := 'OPEN';

Line 100: WSH_UTIL_CORE.println('Delivery name :'||l_delivery_name);

96: WSH_UTIL_CORE.println('The status :'||l_status);
97: WSH_UTIL_CORE.println('Location id :'||l_logged_at_location_id);
98: WSH_UTIL_CORE.println('Exception location id :'||l_exception_location_id);
99: WSH_UTIL_CORE.println('Delivery id :'||l_delivery_id);
100: WSH_UTIL_CORE.println('Delivery name :'||l_delivery_name);
101:
102: l_msg_data := NULL;
103: l_old_status := 'OPEN';
104: l_new_status := 'CLOSED';

Line 129: WSH_UTIL_CORE.println('Triggering point is'|| l_triggering_point);

125: FETCH triggering_point into l_triggering_point;
126:
127: CLOSE triggering_point;
128:
129: WSH_UTIL_CORE.println('Triggering point is'|| l_triggering_point);
130: IF l_triggering_point= 'PICK_RELEASE' THEN
131: L_EXCEPTION_NAME := 'WSH_PR_SUB_EXPORT_COMPL';
132: ELSE
133: L_EXCEPTION_NAME := 'WSH_SC_SUB_EXPORT_COMPL';

Line 162: WSH_UTIL_CORE.println('End of Call Shipping');

158: p_delivery_id => l_delivery_id,
159: p_delivery_name => l_delivery_name
160: );
161:
162: WSH_UTIL_CORE.println('End of Call Shipping');
163:
164: /* UPDATE wsh_itm_request_control
165: SET process_flag = 0,
166: response_header_id = NULL

Line 175: WSH_UTIL_CORE.println(' Error while hadling the exceptions');

171: EXCEPTION
172:
173: WHEN OTHERS THEN
174: ROLLBACK TO WSH_ITM_RESUBMIT;
175: WSH_UTIL_CORE.println(' Error while hadling the exceptions');
176:
177: END Handle_Exception;
178:
179:

Line 280: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;

276:
277: l_completion_status := 'NORMAL';
278: l_log_level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');
279:
280: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
281:
282: IF l_log_level IS NOT NULL THEN
283: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
284: END IF;

Line 283: WSH_UTIL_CORE.Set_Log_Level(l_log_level);

279:
280: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
281:
282: IF l_log_level IS NOT NULL THEN
283: WSH_UTIL_CORE.Set_Log_Level(l_log_level);
284: END IF;
285:
286: ------------------------------------------
287: -- Print the values of all the parameters.

Line 290: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);

286: ------------------------------------------
287: -- Print the values of all the parameters.
288: ------------------------------------------
289:
290: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
291: WSH_UTIL_CORE.println('Resubmit Type : ' || p_resubmit_type);
292: WSH_UTIL_CORE.println('Reference No. : ' || p_reference_id);
293: WSH_UTIL_CORE.println('Reference Line No. : ' || p_reference_line_id);
294: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);

Line 291: WSH_UTIL_CORE.println('Resubmit Type : ' || p_resubmit_type);

287: -- Print the values of all the parameters.
288: ------------------------------------------
289:
290: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
291: WSH_UTIL_CORE.println('Resubmit Type : ' || p_resubmit_type);
292: WSH_UTIL_CORE.println('Reference No. : ' || p_reference_id);
293: WSH_UTIL_CORE.println('Reference Line No. : ' || p_reference_line_id);
294: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
295: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);

Line 292: WSH_UTIL_CORE.println('Reference No. : ' || p_reference_id);

288: ------------------------------------------
289:
290: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
291: WSH_UTIL_CORE.println('Resubmit Type : ' || p_resubmit_type);
292: WSH_UTIL_CORE.println('Reference No. : ' || p_reference_id);
293: WSH_UTIL_CORE.println('Reference Line No. : ' || p_reference_line_id);
294: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
295: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
296: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);

Line 293: WSH_UTIL_CORE.println('Reference Line No. : ' || p_reference_line_id);

289:
290: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
291: WSH_UTIL_CORE.println('Resubmit Type : ' || p_resubmit_type);
292: WSH_UTIL_CORE.println('Reference No. : ' || p_reference_id);
293: WSH_UTIL_CORE.println('Reference Line No. : ' || p_reference_line_id);
294: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
295: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
296: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
297: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);

Line 294: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);

290: WSH_UTIL_CORE.println('Application Id : ' || p_application_id);
291: WSH_UTIL_CORE.println('Resubmit Type : ' || p_resubmit_type);
292: WSH_UTIL_CORE.println('Reference No. : ' || p_reference_id);
293: WSH_UTIL_CORE.println('Reference Line No. : ' || p_reference_line_id);
294: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
295: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
296: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
297: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
298: WSH_UTIL_CORE.println('Party id : ' || p_party_id);

Line 295: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);

291: WSH_UTIL_CORE.println('Resubmit Type : ' || p_resubmit_type);
292: WSH_UTIL_CORE.println('Reference No. : ' || p_reference_id);
293: WSH_UTIL_CORE.println('Reference Line No. : ' || p_reference_line_id);
294: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
295: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
296: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
297: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
298: WSH_UTIL_CORE.println('Party id : ' || p_party_id);
299:

Line 296: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);

292: WSH_UTIL_CORE.println('Reference No. : ' || p_reference_id);
293: WSH_UTIL_CORE.println('Reference Line No. : ' || p_reference_line_id);
294: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
295: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
296: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
297: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
298: WSH_UTIL_CORE.println('Party id : ' || p_party_id);
299:
300: WSH_UTIL_CORE.println('*** Inside PROCEDURE ITM_Resubmit_Requests ***');

Line 297: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);

293: WSH_UTIL_CORE.println('Reference Line No. : ' || p_reference_line_id);
294: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
295: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
296: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
297: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
298: WSH_UTIL_CORE.println('Party id : ' || p_party_id);
299:
300: WSH_UTIL_CORE.println('*** Inside PROCEDURE ITM_Resubmit_Requests ***');
301:

Line 298: WSH_UTIL_CORE.println('Party id : ' || p_party_id);

294: WSH_UTIL_CORE.println('Error Type : ' || p_error_type);
295: WSH_UTIL_CORE.println('Error Code : ' || p_error_code);
296: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
297: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
298: WSH_UTIL_CORE.println('Party id : ' || p_party_id);
299:
300: WSH_UTIL_CORE.println('*** Inside PROCEDURE ITM_Resubmit_Requests ***');
301:
302: IF p_application_id = 660 THEN --{

Line 300: WSH_UTIL_CORE.println('* Inside PROCEDURE ITM_Resubmit_Requests *');

296: WSH_UTIL_CORE.println('Vendor Id : ' || p_vendor_id);
297: WSH_UTIL_CORE.println('Party Type : ' || p_party_type);
298: WSH_UTIL_CORE.println('Party id : ' || p_party_id);
299:
300: WSH_UTIL_CORE.println('*** Inside PROCEDURE ITM_Resubmit_Requests ***');
301:
302: IF p_application_id = 660 THEN --{
303:
304: l_sql_string := 'SELECT DISTINCT wrc.request_control_id '||

Line 387: WSH_UTIL_CORE.println(l_sub_str);

383: IF i > length(l_sql_string) THEN
384: EXIT;
385: END IF;
386: l_sub_str := SUBSTR(l_sql_string, i , 80);
387: WSH_UTIL_CORE.println(l_sub_str);
388: i := i + 80;
389: END LOOP;
390:
391: l_CursorID := DBMS_SQL.Open_Cursor;

Line 436: WSH_UTIL_CORE.println('Request Control Id is' || l_request_control_id);

432: DBMS_SQL.Close_Cursor(l_cursorID);
433: EXIT;
434: ELSE
435: DBMS_SQL.Column_Value(l_CursorID, 1, l_request_control_id);
436: WSH_UTIL_CORE.println('Request Control Id is' || l_request_control_id);
437: END IF;
438: ELSE
439: fetch Get_Request_Control_ship into l_request_control_id;
440:

Line 441: WSH_UTIL_CORE.println('Request Control Id for application shipping is' || l_request_control_id);

437: END IF;
438: ELSE
439: fetch Get_Request_Control_ship into l_request_control_id;
440:
441: WSH_UTIL_CORE.println('Request Control Id for application shipping is' || l_request_control_id);
442: exit when Get_request_control_ship%notfound;
443: WSH_UTIL_CORE.println('Before the handle exception '||l_request_control_id);
444: Handle_Exception(l_request_control_id);
445: WSH_UTIL_CORE.println('After the handle exception'||l_request_control_id);

Line 443: WSH_UTIL_CORE.println('Before the handle exception '||l_request_control_id);

439: fetch Get_Request_Control_ship into l_request_control_id;
440:
441: WSH_UTIL_CORE.println('Request Control Id for application shipping is' || l_request_control_id);
442: exit when Get_request_control_ship%notfound;
443: WSH_UTIL_CORE.println('Before the handle exception '||l_request_control_id);
444: Handle_Exception(l_request_control_id);
445: WSH_UTIL_CORE.println('After the handle exception'||l_request_control_id);
446: WSH_UTIL_CORE.println('Request Control Id after handling the exception for shipping is' || l_request_control_id);
447: END IF;

Line 445: WSH_UTIL_CORE.println('After the handle exception'||l_request_control_id);

441: WSH_UTIL_CORE.println('Request Control Id for application shipping is' || l_request_control_id);
442: exit when Get_request_control_ship%notfound;
443: WSH_UTIL_CORE.println('Before the handle exception '||l_request_control_id);
444: Handle_Exception(l_request_control_id);
445: WSH_UTIL_CORE.println('After the handle exception'||l_request_control_id);
446: WSH_UTIL_CORE.println('Request Control Id after handling the exception for shipping is' || l_request_control_id);
447: END IF;
448:
449: WSH_UTIL_CORE.println('Request Control Id is' || l_request_control_id);

Line 446: WSH_UTIL_CORE.println('Request Control Id after handling the exception for shipping is' || l_request_control_id);

442: exit when Get_request_control_ship%notfound;
443: WSH_UTIL_CORE.println('Before the handle exception '||l_request_control_id);
444: Handle_Exception(l_request_control_id);
445: WSH_UTIL_CORE.println('After the handle exception'||l_request_control_id);
446: WSH_UTIL_CORE.println('Request Control Id after handling the exception for shipping is' || l_request_control_id);
447: END IF;
448:
449: WSH_UTIL_CORE.println('Request Control Id is' || l_request_control_id);
450:

Line 449: WSH_UTIL_CORE.println('Request Control Id is' || l_request_control_id);

445: WSH_UTIL_CORE.println('After the handle exception'||l_request_control_id);
446: WSH_UTIL_CORE.println('Request Control Id after handling the exception for shipping is' || l_request_control_id);
447: END IF;
448:
449: WSH_UTIL_CORE.println('Request Control Id is' || l_request_control_id);
450:
451: WSH_UTIL_CORE.println(' ');
452: WSH_UTIL_CORE.println('Start Processing for Request control : ' || l_request_control_id);
453:

Line 451: WSH_UTIL_CORE.println(' ');

447: END IF;
448:
449: WSH_UTIL_CORE.println('Request Control Id is' || l_request_control_id);
450:
451: WSH_UTIL_CORE.println(' ');
452: WSH_UTIL_CORE.println('Start Processing for Request control : ' || l_request_control_id);
453:
454:
455: WSH_UTIL_CORE.println('Calling the Response Analyser');

Line 452: WSH_UTIL_CORE.println('Start Processing for Request control : ' || l_request_control_id);

448:
449: WSH_UTIL_CORE.println('Request Control Id is' || l_request_control_id);
450:
451: WSH_UTIL_CORE.println(' ');
452: WSH_UTIL_CORE.println('Start Processing for Request control : ' || l_request_control_id);
453:
454:
455: WSH_UTIL_CORE.println('Calling the Response Analyser');
456: WSH_UTIL_CORE.println('Request Control Id :' || l_request_control_id);

Line 455: WSH_UTIL_CORE.println('Calling the Response Analyser');

451: WSH_UTIL_CORE.println(' ');
452: WSH_UTIL_CORE.println('Start Processing for Request control : ' || l_request_control_id);
453:
454:
455: WSH_UTIL_CORE.println('Calling the Response Analyser');
456: WSH_UTIL_CORE.println('Request Control Id :' || l_request_control_id);
457:
458: -----------------------------------------------------------
459: -- Calling the Response Analyser to Get the Interpretation

Line 456: WSH_UTIL_CORE.println('Request Control Id :' || l_request_control_id);

452: WSH_UTIL_CORE.println('Start Processing for Request control : ' || l_request_control_id);
453:
454:
455: WSH_UTIL_CORE.println('Calling the Response Analyser');
456: WSH_UTIL_CORE.println('Request Control Id :' || l_request_control_id);
457:
458: -----------------------------------------------------------
459: -- Calling the Response Analyser to Get the Interpretation
460: -----------------------------------------------------------

Line 471: WSH_UTIL_CORE.println(' ');

467: x_return_status => l_return_status,
468: x_SrvTab => l_SrvTab
469: );
470:
471: WSH_UTIL_CORE.println(' ');
472: WSH_UTIL_CORE.println('After Call to Response Analyser');
473: WSH_UTIL_CORE.println('Response from Response Analyser :' || l_interpreted_value);
474:
475: IF (p_application_id =660 AND l_interpreted_value ='DATA') then

Line 472: WSH_UTIL_CORE.println('After Call to Response Analyser');

468: x_SrvTab => l_SrvTab
469: );
470:
471: WSH_UTIL_CORE.println(' ');
472: WSH_UTIL_CORE.println('After Call to Response Analyser');
473: WSH_UTIL_CORE.println('Response from Response Analyser :' || l_interpreted_value);
474:
475: IF (p_application_id =660 AND l_interpreted_value ='DATA') then
476: WSH_UTIL_CORE.println('Data errors will not be processes for Order Management');

Line 473: WSH_UTIL_CORE.println('Response from Response Analyser :' || l_interpreted_value);

469: );
470:
471: WSH_UTIL_CORE.println(' ');
472: WSH_UTIL_CORE.println('After Call to Response Analyser');
473: WSH_UTIL_CORE.println('Response from Response Analyser :' || l_interpreted_value);
474:
475: IF (p_application_id =660 AND l_interpreted_value ='DATA') then
476: WSH_UTIL_CORE.println('Data errors will not be processes for Order Management');
477: ELSE

Line 476: WSH_UTIL_CORE.println('Data errors will not be processes for Order Management');

472: WSH_UTIL_CORE.println('After Call to Response Analyser');
473: WSH_UTIL_CORE.println('Response from Response Analyser :' || l_interpreted_value);
474:
475: IF (p_application_id =660 AND l_interpreted_value ='DATA') then
476: WSH_UTIL_CORE.println('Data errors will not be processes for Order Management');
477: ELSE
478:
479: BEGIN
480: IF l_return_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 487: WSH_UTIL_CORE.println('Updating process flag to 0');

483:
484:
485: IF (l_interpreted_value = p_resubmit_type OR p_resubmit_type IS NULL) THEN
486:
487: WSH_UTIL_CORE.println('Updating process flag to 0');
488:
489: --------------------------------
490: -- Update the Process Flag to 0
491: --------------------------------

Line 499: WSH_UTIL_CORE.println('Commiting the records..');

495: response_header_id = NULL
496: WHERE request_control_id = l_request_control_id;
497:
498:
499: WSH_UTIL_CORE.println('Commiting the records..');
500: commit;
501: WSH_UTIL_CORE.println('Finished processing for Request Control :' || l_request_control_id);
502: WSH_UTIL_CORE.println(' ');
503:

Line 501: WSH_UTIL_CORE.println('Finished processing for Request Control :' || l_request_control_id);

497:
498:
499: WSH_UTIL_CORE.println('Commiting the records..');
500: commit;
501: WSH_UTIL_CORE.println('Finished processing for Request Control :' || l_request_control_id);
502: WSH_UTIL_CORE.println(' ');
503:
504: ELSE
505:

Line 502: WSH_UTIL_CORE.println(' ');

498:
499: WSH_UTIL_CORE.println('Commiting the records..');
500: commit;
501: WSH_UTIL_CORE.println('Finished processing for Request Control :' || l_request_control_id);
502: WSH_UTIL_CORE.println(' ');
503:
504: ELSE
505:
506: WSH_UTIL_CORE.println('Response from Response Analyser is different from parameter p_resubmit_type');

Line 506: WSH_UTIL_CORE.println('Response from Response Analyser is different from parameter p_resubmit_type');

502: WSH_UTIL_CORE.println(' ');
503:
504: ELSE
505:
506: WSH_UTIL_CORE.println('Response from Response Analyser is different from parameter p_resubmit_type');
507: WSH_UTIL_CORE.println('So will not process this record');
508:
509: END IF;
510:

Line 507: WSH_UTIL_CORE.println('So will not process this record');

503:
504: ELSE
505:
506: WSH_UTIL_CORE.println('Response from Response Analyser is different from parameter p_resubmit_type');
507: WSH_UTIL_CORE.println('So will not process this record');
508:
509: END IF;
510:
511: EXCEPTION

Line 514: WSH_UTIL_CORE.println('Processing Failed in Response Analyser');

510:
511: EXCEPTION
512: WHEN Response_Analyser_Failed THEN
513: ROLLBACK TO WSH_ITM_RESUBMIT;
514: WSH_UTIL_CORE.println('Processing Failed in Response Analyser');
515: END;
516: END IF;
517:
518: END LOOP; --}

Line 529: WSH_UTIL_CORE.println('End of the Loop for the Cursor ');

525: CLOSE Get_Request_Control_ship;
526: END IF;
527:
528:
529: WSH_UTIL_CORE.println('End of the Loop for the Cursor ');
530:
531: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
532:
533:

Line 548: WSH_UTIL_CORE.PrintMsg('In the exception Block');

544: END IF;
545: l_completion_status := 'ERROR';
546: l_error_code := SQLCODE;
547: l_error_text := SQLERRM;
548: WSH_UTIL_CORE.PrintMsg('In the exception Block');
549: WSH_UTIL_CORE.PrintMsg('Processing failed with an error');
550: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);
551: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
552:

Line 549: WSH_UTIL_CORE.PrintMsg('Processing failed with an error');

545: l_completion_status := 'ERROR';
546: l_error_code := SQLCODE;
547: l_error_text := SQLERRM;
548: WSH_UTIL_CORE.PrintMsg('In the exception Block');
549: WSH_UTIL_CORE.PrintMsg('Processing failed with an error');
550: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);
551: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
552:
553: END ITM_Resubmit_Requests;

Line 550: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);

546: l_error_code := SQLCODE;
547: l_error_text := SQLERRM;
548: WSH_UTIL_CORE.PrintMsg('In the exception Block');
549: WSH_UTIL_CORE.PrintMsg('Processing failed with an error');
550: WSH_UTIL_CORE.PrintMsg('The unexpected error is '||l_error_code||':' || l_error_text);
551: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
552:
553: END ITM_Resubmit_Requests;
554: