DBA Data[Home] [Help]

APPS.RCV_LCM_WEB_SERVICE dependencies on ASN_DEBUG

Line 17: asn_debug.put_line('Entering RCV_LCM_WEB_SERVICE.Get_Landed_Cost' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));

13: g_pgm_appl_id NUMBER := FND_PROFILE.value('RESP_APPL_ID');
14: --
15: BEGIN
16: --
17: asn_debug.put_line('Entering RCV_LCM_WEB_SERVICE.Get_Landed_Cost' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
18: asn_debug.put_line('p_group_id : ' || p_group_id);
19: asn_debug.put_line('p_processing_mode : ' || p_processing_mode);
20: asn_debug.put_line('g_user_id : ' || g_user_id);
21: asn_debug.put_line('g_resp_id : ' || g_resp_id);

Line 18: asn_debug.put_line('p_group_id : ' || p_group_id);

14: --
15: BEGIN
16: --
17: asn_debug.put_line('Entering RCV_LCM_WEB_SERVICE.Get_Landed_Cost' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
18: asn_debug.put_line('p_group_id : ' || p_group_id);
19: asn_debug.put_line('p_processing_mode : ' || p_processing_mode);
20: asn_debug.put_line('g_user_id : ' || g_user_id);
21: asn_debug.put_line('g_resp_id : ' || g_resp_id);
22: asn_debug.put_line('g_pgm_appl_id : ' || g_pgm_appl_id);

Line 19: asn_debug.put_line('p_processing_mode : ' || p_processing_mode);

15: BEGIN
16: --
17: asn_debug.put_line('Entering RCV_LCM_WEB_SERVICE.Get_Landed_Cost' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
18: asn_debug.put_line('p_group_id : ' || p_group_id);
19: asn_debug.put_line('p_processing_mode : ' || p_processing_mode);
20: asn_debug.put_line('g_user_id : ' || g_user_id);
21: asn_debug.put_line('g_resp_id : ' || g_resp_id);
22: asn_debug.put_line('g_pgm_appl_id : ' || g_pgm_appl_id);
23: --

Line 20: asn_debug.put_line('g_user_id : ' || g_user_id);

16: --
17: asn_debug.put_line('Entering RCV_LCM_WEB_SERVICE.Get_Landed_Cost' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
18: asn_debug.put_line('p_group_id : ' || p_group_id);
19: asn_debug.put_line('p_processing_mode : ' || p_processing_mode);
20: asn_debug.put_line('g_user_id : ' || g_user_id);
21: asn_debug.put_line('g_resp_id : ' || g_resp_id);
22: asn_debug.put_line('g_pgm_appl_id : ' || g_pgm_appl_id);
23: --
24: OPEN rti_cur(p_group_id,p_processing_mode);

Line 21: asn_debug.put_line('g_resp_id : ' || g_resp_id);

17: asn_debug.put_line('Entering RCV_LCM_WEB_SERVICE.Get_Landed_Cost' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
18: asn_debug.put_line('p_group_id : ' || p_group_id);
19: asn_debug.put_line('p_processing_mode : ' || p_processing_mode);
20: asn_debug.put_line('g_user_id : ' || g_user_id);
21: asn_debug.put_line('g_resp_id : ' || g_resp_id);
22: asn_debug.put_line('g_pgm_appl_id : ' || g_pgm_appl_id);
23: --
24: OPEN rti_cur(p_group_id,p_processing_mode);
25: FETCH rti_cur BULK COLLECT into p_rti_rec;

Line 22: asn_debug.put_line('g_pgm_appl_id : ' || g_pgm_appl_id);

18: asn_debug.put_line('p_group_id : ' || p_group_id);
19: asn_debug.put_line('p_processing_mode : ' || p_processing_mode);
20: asn_debug.put_line('g_user_id : ' || g_user_id);
21: asn_debug.put_line('g_resp_id : ' || g_resp_id);
22: asn_debug.put_line('g_pgm_appl_id : ' || g_pgm_appl_id);
23: --
24: OPEN rti_cur(p_group_id,p_processing_mode);
25: FETCH rti_cur BULK COLLECT into p_rti_rec;
26:

Line 29: asn_debug.put_line('calling LCM API to get the landed cost' || p_rti_rec.COUNT);

25: FETCH rti_cur BULK COLLECT into p_rti_rec;
26:
27: IF p_rti_rec.first IS NOT NULL THEN
28:
29: asn_debug.put_line('calling LCM API to get the landed cost' || p_rti_rec.COUNT);
30:
31: INL_INTEGRATION_GRP.Get_LandedCost(p_rti_rec,p_group_id,p_processing_mode);
32:
33: asn_debug.put_line('after calling LCM API to get the landed cost' || p_rti_rec.COUNT);

Line 33: asn_debug.put_line('after calling LCM API to get the landed cost' || p_rti_rec.COUNT);

29: asn_debug.put_line('calling LCM API to get the landed cost' || p_rti_rec.COUNT);
30:
31: INL_INTEGRATION_GRP.Get_LandedCost(p_rti_rec,p_group_id,p_processing_mode);
32:
33: asn_debug.put_line('after calling LCM API to get the landed cost' || p_rti_rec.COUNT);
34:
35: END IF;
36:
37: IF rti_cur%ISOPEN THEN

Line 43: asn_debug.put_line('the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));

39: END IF;
40:
41: EXCEPTION
42: WHEN OTHERS THEN
43: asn_debug.put_line('the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));
44:
45: IF rti_cur%ISOPEN THEN
46: CLOSE rti_cur;
47: END IF;

Line 60: asn_debug.put_line(sql%rowcount || ' RTIs updated to Error' );

56: AND source_document_code = 'PO'
57: AND transaction_type NOT IN ('SHIP', 'RECEIVE', 'ACCEPT', 'REJECT','TRANSFER','UNORDERED')
58: AND lcm_shipment_line_id IS NOT NULL;
59:
60: asn_debug.put_line(sql%rowcount || ' RTIs updated to Error' );
61:
62: END Get_Landed_Cost;
63:
64: END RCV_LCM_WEB_SERVICE;