APPS.M4R_7B1_WSM_IN dependencies on WSM_INTERFACE_ERRORS

Line 1445: g_exception_tracking_msg := 'Querying WSM_INTERFACE_ERRORS for Errors';

1441: END IF;
1442:
1443: BEGIN
1444:
1445: g_exception_tracking_msg := 'Querying WSM_INTERFACE_ERRORS for Errors';
1446: --bsaratna
1447: l_errloop_cnt := 0;
1448: l_err_msg1 := '';
1449: l_err_flag := 'N';

Line 1452: FROM WSM_INTERFACE_ERRORS

1448: l_err_msg1 := '';
1449: l_err_flag := 'N';
1450: FOR i IN (SELECT message
1451: INTO l_err_msg1
1452: FROM WSM_INTERFACE_ERRORS
1453: WHERE transaction_id = l_txn_id)
1454: LOOP
1455: IF (g_debug_level <= 1) THEN
1456: cln_debug_pub.Add('Loop error : ' || i.message, 1);

Line 1473: FROM WSM_INTERFACE_ERRORS

1469: --bsaratna
1470:
1471: /*SELECT MESSAGE
1472: INTO l_err_msg1
1473: FROM WSM_INTERFACE_ERRORS
1474: WHERE transaction_id = l_txn_id;
1475:
1476: IF (g_debug_level <= 1) THEN
1477: cln_debug_pub.Add('l_err_msg1 : ' || l_err_msg1, 1);

Line 2728: g_exception_tracking_msg := 'Querying WSM_INTERFACE_ERRORS for Errors';

2724:
2725: ELSE
2726:
2727: BEGIN
2728: g_exception_tracking_msg := 'Querying WSM_INTERFACE_ERRORS for Errors';
2729:
2730: l_errloop_cnt := 0;
2731: l_interface_err := '';
2732:

Line 2735: FROM wsm_interface_errors

2731: l_interface_err := '';
2732:
2733: --bsaratna
2734: FOR i IN (SELECT message
2735: FROM wsm_interface_errors
2736: WHERE message_type = 1
2737: AND header_id = (SELECT header_id
2738: FROM wsm_split_merge_txn_interface
2739: WHERE group_id = l_group_id))

Line 2808: FROM WSM_INTERFACE_ERRORS

2804: END IF;
2805: --bsaratna
2806: /*SELECT MESSAGE
2807: INTO l_interface_err
2808: FROM WSM_INTERFACE_ERRORS
2809: WHERE MESSAGE_TYPE = 1
2810: AND header_id = ( SELECT HEADER_ID
2811: FROM wsm_split_merge_txn_interface
2812: WHERE group_id = l_group_id);