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_RCO_VALIDATION_PVT dependencies on FND_LOG

Line 303: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

299: x_rate => l_rate,
300: x_price_break_id => l_price_break_id);
301:
302: IF (g_fnd_debug = 'Y') THEN
303: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
304: fnd_log.string(fnd_log.level_statement, g_module_prefix ||
305: l_api_name, 'New Base Unit Price:' || to_char(l_new_base_unit_price) || ' New Price:' || to_char(l_new_price) || ' New Cur Unit Price:' || to_char(l_new_curr_price));
306: END IF;
307: END IF;

Line 304: fnd_log.string(fnd_log.level_statement, g_module_prefix ||

300: x_price_break_id => l_price_break_id);
301:
302: IF (g_fnd_debug = 'Y') THEN
303: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
304: fnd_log.string(fnd_log.level_statement, g_module_prefix ||
305: l_api_name, 'New Base Unit Price:' || to_char(l_new_base_unit_price) || ' New Price:' || to_char(l_new_price) || ' New Cur Unit Price:' || to_char(l_new_curr_price));
306: END IF;
307: END IF;
308:

Line 375: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

371: CLOSE l_linepricebreak_csr;
372:
373: EXCEPTION WHEN OTHERS THEN
374: IF g_fnd_debug = 'Y' THEN
375: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
376: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
377: l_api_name || '.others_exception', l_progress || ':' || SQLERRM);
378: END IF;
379: END IF;

Line 376: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

372:
373: EXCEPTION WHEN OTHERS THEN
374: IF g_fnd_debug = 'Y' THEN
375: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
376: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
377: l_api_name || '.others_exception', l_progress || ':' || SQLERRM);
378: END IF;
379: END IF;
380: RAISE;

Line 611: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

607: END LOOP;
608: CLOSE l_line_csr;
609: EXCEPTION WHEN OTHERS THEN
610: IF g_fnd_debug = 'Y' THEN
611: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
612: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
613: l_api_name || '.others_exception', l_progress || ':' || SQLERRM);
614: END IF;
615: END IF;

Line 612: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

608: CLOSE l_line_csr;
609: EXCEPTION WHEN OTHERS THEN
610: IF g_fnd_debug = 'Y' THEN
611: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
612: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
613: l_api_name || '.others_exception', l_progress || ':' || SQLERRM);
614: END IF;
615: END IF;
616: RAISE;

Line 670: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

666: where dist.po_line_id = line.po_line_id AND
667: dist.po_distribution_id = p_po_change_table(s).document_distribution_id;
668:
669: IF (g_fnd_debug = 'Y') THEN
670: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
671: FND_LOG.string(FND_LOG.level_statement, g_module_prefix ||
672: l_api_name, 'quantity_delivered : '||l_qty_old_del||', quantity_billed : '||l_qty_old_bill||', new_qty : '||p_po_change_table(s).new_quantity);
673: END IF;
674: END IF;

Line 671: FND_LOG.string(FND_LOG.level_statement, g_module_prefix ||

667: dist.po_distribution_id = p_po_change_table(s).document_distribution_id;
668:
669: IF (g_fnd_debug = 'Y') THEN
670: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
671: FND_LOG.string(FND_LOG.level_statement, g_module_prefix ||
672: l_api_name, 'quantity_delivered : '||l_qty_old_del||', quantity_billed : '||l_qty_old_bill||', new_qty : '||p_po_change_table(s).new_quantity);
673: END IF;
674: END IF;
675:

Line 852: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

848: END IF;
849: END LOOP;
850: EXCEPTION WHEN OTHERS THEN
851: IF g_fnd_debug = 'Y' THEN
852: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
853: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
854: l_api_name || '.others_exception', x_return_msg || ':' || SQLERRM);
855: END IF;
856: END IF;

Line 853: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

849: END LOOP;
850: EXCEPTION WHEN OTHERS THEN
851: IF g_fnd_debug = 'Y' THEN
852: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
853: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
854: l_api_name || '.others_exception', x_return_msg || ':' || SQLERRM);
855: END IF;
856: END IF;
857: RAISE;

Line 1141: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

1137: END IF;
1138: EXCEPTION
1139: WHEN OTHERS THEN
1140: IF g_fnd_debug = 'Y' THEN
1141: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1142: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1143: l_api_name || '.others_exception',
1144: p_header_id || '*' || p_release_id || '*' || p_err_po_msg || ':' || SQLERRM);
1145: END IF;

Line 1142: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

1138: EXCEPTION
1139: WHEN OTHERS THEN
1140: IF g_fnd_debug = 'Y' THEN
1141: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1142: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1143: l_api_name || '.others_exception',
1144: p_header_id || '*' || p_release_id || '*' || p_err_po_msg || ':' || SQLERRM);
1145: END IF;
1146: END IF;

Line 1591: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

1587: EXCEPTION WHEN OTHERS THEN
1588: x_return_status := fnd_api.g_ret_sts_unexp_error;
1589: x_retmsg := 'VC_Exp:' || x_retmsg || ':' || SQLERRM;
1590: IF g_fnd_debug = 'Y' THEN
1591: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1592: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1593: l_api_name || '.others_exception', x_retmsg);
1594: END IF;
1595: END IF;

Line 1592: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

1588: x_return_status := fnd_api.g_ret_sts_unexp_error;
1589: x_retmsg := 'VC_Exp:' || x_retmsg || ':' || SQLERRM;
1590: IF g_fnd_debug = 'Y' THEN
1591: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1592: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1593: l_api_name || '.others_exception', x_retmsg);
1594: END IF;
1595: END IF;
1596: END validate_changes;

Line 1710: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

1706:
1707: EXCEPTION WHEN OTHERS THEN
1708:
1709: IF g_fnd_debug = 'Y' THEN
1710: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1711: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1712: l_api_name || '.others_exception', SQLERRM);
1713: END IF;
1714: END IF;

Line 1711: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

1707: EXCEPTION WHEN OTHERS THEN
1708:
1709: IF g_fnd_debug = 'Y' THEN
1710: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1711: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1712: l_api_name || '.others_exception', SQLERRM);
1713: END IF;
1714: END IF;
1715: RAISE;

Line 1766: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

1762: END IF;
1763: EXCEPTION WHEN OTHERS THEN
1764: x_return_status := fnd_api.g_ret_sts_unexp_error;
1765: IF g_fnd_debug = 'Y' THEN
1766: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1767: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1768: l_api_name || '.others_exception', SQLERRM);
1769: END IF;
1770: END IF;

Line 1767: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

1763: EXCEPTION WHEN OTHERS THEN
1764: x_return_status := fnd_api.g_ret_sts_unexp_error;
1765: IF g_fnd_debug = 'Y' THEN
1766: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1767: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1768: l_api_name || '.others_exception', SQLERRM);
1769: END IF;
1770: END IF;
1771: END calculate_disttax;

Line 1938: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

1934: CLOSE l_line_id_with_price_chn_csr;
1935:
1936: EXCEPTION WHEN OTHERS THEN
1937: IF g_fnd_debug = 'Y' THEN
1938: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1939: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1940: l_api_name || '.others_exception',
1941: p_chn_req_grp_id || '*' || l_progress || ':' || SQLERRM);
1942: END IF;

Line 1939: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

1935:
1936: EXCEPTION WHEN OTHERS THEN
1937: IF g_fnd_debug = 'Y' THEN
1938: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1939: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1940: l_api_name || '.others_exception',
1941: p_chn_req_grp_id || '*' || l_progress || ':' || SQLERRM);
1942: END IF;
1943: END IF;

Line 2066: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

2062: CLOSE l_line_id_with_qty_chn_csr;
2063:
2064: EXCEPTION WHEN OTHERS THEN
2065: IF g_fnd_debug = 'Y' THEN
2066: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
2067: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
2068: l_api_name || '.others_exception',
2069: p_chn_req_grp_id || '*' || l_progress || ':' || SQLERRM);
2070: END IF;

Line 2067: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

2063:
2064: EXCEPTION WHEN OTHERS THEN
2065: IF g_fnd_debug = 'Y' THEN
2066: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
2067: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
2068: l_api_name || '.others_exception',
2069: p_chn_req_grp_id || '*' || l_progress || ':' || SQLERRM);
2070: END IF;
2071: END IF;

Line 2621: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

2617:
2618: --Exception Handling will be taken care of in parent procedures
2619: EXCEPTION WHEN OTHERS THEN
2620: IF g_fnd_debug = 'Y' THEN
2621: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
2622: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
2623: l_api_name || '.others_exception',
2624: l_progress || ':' || SQLERRM);
2625: END IF;

Line 2622: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

2618: --Exception Handling will be taken care of in parent procedures
2619: EXCEPTION WHEN OTHERS THEN
2620: IF g_fnd_debug = 'Y' THEN
2621: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
2622: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
2623: l_api_name || '.others_exception',
2624: l_progress || ':' || SQLERRM);
2625: END IF;
2626: END IF;

Line 2747: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

2743:
2744: IF (l_cancelled = 'Y' ) THEN
2745:
2746: IF (g_fnd_debug = 'Y') THEN
2747: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2748: fnd_log.string(fnd_log.level_statement,
2749: g_module_prefix || l_api_name,
2750: 'Req Line ID:' || p_req_line_id || ' ' ||
2751: 'is Already cancelled');

Line 2748: fnd_log.string(fnd_log.level_statement,

2744: IF (l_cancelled = 'Y' ) THEN
2745:
2746: IF (g_fnd_debug = 'Y') THEN
2747: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2748: fnd_log.string(fnd_log.level_statement,
2749: g_module_prefix || l_api_name,
2750: 'Req Line ID:' || p_req_line_id || ' ' ||
2751: 'is Already cancelled');
2752: END IF;

Line 2769: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

2765: p_req_header_id =>null,
2766: x_cancellable =>is_so_cancel);
2767:
2768: IF (g_fnd_debug = 'Y') THEN
2769: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2770: fnd_log.string(fnd_log.level_statement,
2771: g_module_prefix || l_api_name,
2772: 'Req Line ID:' || p_req_line_id || ' ' ||
2773: 'transferred to so ='||is_so_cancel||' status'||l_sts);

Line 2770: fnd_log.string(fnd_log.level_statement,

2766: x_cancellable =>is_so_cancel);
2767:
2768: IF (g_fnd_debug = 'Y') THEN
2769: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2770: fnd_log.string(fnd_log.level_statement,
2771: g_module_prefix || l_api_name,
2772: 'Req Line ID:' || p_req_line_id || ' ' ||
2773: 'transferred to so ='||is_so_cancel||' status'||l_sts);
2774: END IF;

Line 2889: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

2885: IF (l_received_quantity >= l_quantity OR
2886: l_received_amount >= l_amount) THEN
2887:
2888: IF (g_fnd_debug = 'Y') THEN
2889: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2890: fnd_log.string(fnd_log.level_statement,
2891: g_module_prefix || l_api_name,
2892: 'Req Line ID:' || p_req_line_id || ' ' ||
2893: 'Shipment Fully Received');

Line 2890: fnd_log.string(fnd_log.level_statement,

2886: l_received_amount >= l_amount) THEN
2887:
2888: IF (g_fnd_debug = 'Y') THEN
2889: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2890: fnd_log.string(fnd_log.level_statement,
2891: g_module_prefix || l_api_name,
2892: 'Req Line ID:' || p_req_line_id || ' ' ||
2893: 'Shipment Fully Received');
2894: END IF;

Line 2908: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

2904: IF (l_billed_quantity > l_quantity OR
2905: l_billed_amount > l_amount) THEN
2906:
2907: IF (g_fnd_debug = 'Y') THEN
2908: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2909: fnd_log.string(fnd_log.level_statement,
2910: g_module_prefix || l_api_name,
2911: 'Req Line ID:' || p_req_line_id || ' ' ||
2912: 'Shipment Fully Billed');

Line 2909: fnd_log.string(fnd_log.level_statement,

2905: l_billed_amount > l_amount) THEN
2906:
2907: IF (g_fnd_debug = 'Y') THEN
2908: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2909: fnd_log.string(fnd_log.level_statement,
2910: g_module_prefix || l_api_name,
2911: 'Req Line ID:' || p_req_line_id || ' ' ||
2912: 'Shipment Fully Billed');
2913: END IF;

Line 2931: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

2927: nvl(l_receipt_required_flag, 'Y') <> 'N' AND
2928: l_billed_amount > l_received_amount)) THEN
2929:
2930: IF (g_fnd_debug = 'Y') THEN
2931: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2932: fnd_log.string(fnd_log.level_statement,
2933: g_module_prefix || l_api_name,
2934: 'Req Line ID:' || p_req_line_id || ' ' ||
2935: 'Shipment Over Billed');

Line 2932: fnd_log.string(fnd_log.level_statement,

2928: l_billed_amount > l_received_amount)) THEN
2929:
2930: IF (g_fnd_debug = 'Y') THEN
2931: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2932: fnd_log.string(fnd_log.level_statement,
2933: g_module_prefix || l_api_name,
2934: 'Req Line ID:' || p_req_line_id || ' ' ||
2935: 'Shipment Over Billed');
2936: END IF;

Line 2957: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

2953:
2954: IF (l_rcv_transaction_exist = 1) THEN
2955:
2956: IF (g_fnd_debug = 'Y') THEN
2957: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2958: fnd_log.string(fnd_log.level_statement,
2959: g_module_prefix || l_api_name,
2960: 'Req Line ID:' || p_req_line_id || ' ' ||
2961: 'RCV transaction exists for Shipment');

Line 2958: fnd_log.string(fnd_log.level_statement,

2954: IF (l_rcv_transaction_exist = 1) THEN
2955:
2956: IF (g_fnd_debug = 'Y') THEN
2957: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2958: fnd_log.string(fnd_log.level_statement,
2959: g_module_prefix || l_api_name,
2960: 'Req Line ID:' || p_req_line_id || ' ' ||
2961: 'RCV transaction exists for Shipment');
2962: END IF;

Line 2990: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

2986:
2987: IF (l_asn_exist = 1) THEN
2988:
2989: IF (g_fnd_debug = 'Y') THEN
2990: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2991: fnd_log.string(fnd_log.level_statement,
2992: g_module_prefix || l_api_name,
2993: 'Req Line ID:' || p_req_line_id || ' ' ||
2994: 'ASN not Fully Received');

Line 2991: fnd_log.string(fnd_log.level_statement,

2987: IF (l_asn_exist = 1) THEN
2988:
2989: IF (g_fnd_debug = 'Y') THEN
2990: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2991: fnd_log.string(fnd_log.level_statement,
2992: g_module_prefix || l_api_name,
2993: 'Req Line ID:' || p_req_line_id || ' ' ||
2994: 'ASN not Fully Received');
2995: END IF;

Line 3029: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

3025:
3026: IF (l_not_delivered = 1) THEN
3027:
3028: IF (g_fnd_debug = 'Y') THEN
3029: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3030: fnd_log.string(fnd_log.level_statement,
3031: g_module_prefix || l_api_name,
3032: 'Req Line ID:' || p_req_line_id || ' ' ||
3033: 'Shipment Received but not Delivered');

Line 3030: fnd_log.string(fnd_log.level_statement,

3026: IF (l_not_delivered = 1) THEN
3027:
3028: IF (g_fnd_debug = 'Y') THEN
3029: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3030: fnd_log.string(fnd_log.level_statement,
3031: g_module_prefix || l_api_name,
3032: 'Req Line ID:' || p_req_line_id || ' ' ||
3033: 'Shipment Received but not Delivered');
3034: END IF;

Line 3079: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

3075:
3076: IF (l_dist_not_valid = 1) THEN
3077:
3078: IF (g_fnd_debug = 'Y') THEN
3079: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3080: fnd_log.string(fnd_log.level_statement,
3081: g_module_prefix || l_api_name,
3082: 'Req Line ID:' || p_req_line_id || ' ' ||
3083: 'Distribution Checks Failed');

Line 3080: fnd_log.string(fnd_log.level_statement,

3076: IF (l_dist_not_valid = 1) THEN
3077:
3078: IF (g_fnd_debug = 'Y') THEN
3079: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3080: fnd_log.string(fnd_log.level_statement,
3081: g_module_prefix || l_api_name,
3082: 'Req Line ID:' || p_req_line_id || ' ' ||
3083: 'Distribution Checks Failed');
3084: END IF;

Line 3151: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

3147: -- set org context to the original value
3148: po_moac_utils_pvt.set_org_context(l_req_org_id) ; --
3149:
3150: IF (g_fnd_debug = 'Y') THEN
3151: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3152: fnd_log.string(fnd_log.level_statement,
3153: g_module_prefix || l_api_name,
3154: 'PO_Document_Control_GRP.check_control_action result:' || l_return_status);
3155: END IF;

Line 3152: fnd_log.string(fnd_log.level_statement,

3148: po_moac_utils_pvt.set_org_context(l_req_org_id) ; --
3149:
3150: IF (g_fnd_debug = 'Y') THEN
3151: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3152: fnd_log.string(fnd_log.level_statement,
3153: g_module_prefix || l_api_name,
3154: 'PO_Document_Control_GRP.check_control_action result:' || l_return_status);
3155: END IF;
3156: END IF;

Line 3168: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

3164: END IF;
3165: EXCEPTION WHEN OTHERS THEN
3166: x_return_status := fnd_api.g_ret_sts_unexp_error;
3167: IF (g_fnd_debug = 'Y') THEN
3168: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
3169: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
3170: l_api_name || '.others_exception',
3171: p_req_line_id || '*' || l_progress || ':' || SQLERRM);
3172: END IF;

Line 3169: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

3165: EXCEPTION WHEN OTHERS THEN
3166: x_return_status := fnd_api.g_ret_sts_unexp_error;
3167: IF (g_fnd_debug = 'Y') THEN
3168: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
3169: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
3170: l_api_name || '.others_exception',
3171: p_req_line_id || '*' || l_progress || ':' || SQLERRM);
3172: END IF;
3173: END IF;

Line 3603: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

3599: END IF;
3600:
3601: EXCEPTION WHEN OTHERS THEN
3602: IF g_fnd_debug = 'Y' THEN
3603: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
3604: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
3605: l_api_name || '.others_exception',
3606: p_req_line_id || '*' || l_progress || ':' || SQLERRM);
3607: END IF;

Line 3604: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

3600:
3601: EXCEPTION WHEN OTHERS THEN
3602: IF g_fnd_debug = 'Y' THEN
3603: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
3604: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
3605: l_api_name || '.others_exception',
3606: p_req_line_id || '*' || l_progress || ':' || SQLERRM);
3607: END IF;
3608: END IF;

Line 3826: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

3822: WHEN OTHERS THEN
3823: x_retmsg := 'SRCHUNEXP:' || x_retmsg || ':' || SQLERRM;
3824: x_return_status := fnd_api.g_ret_sts_unexp_error;
3825: IF g_fnd_debug = 'Y' THEN
3826: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
3827: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
3828: l_api_name || '.others_exception', x_retmsg);
3829: END IF;
3830: END IF;

Line 3827: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

3823: x_retmsg := 'SRCHUNEXP:' || x_retmsg || ':' || SQLERRM;
3824: x_return_status := fnd_api.g_ret_sts_unexp_error;
3825: IF g_fnd_debug = 'Y' THEN
3826: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
3827: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
3828: l_api_name || '.others_exception', x_retmsg);
3829: END IF;
3830: END IF;
3831: END save_reqchange;

Line 4007: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

4003: x_return_status := fnd_api.g_ret_sts_success;
4004: EXCEPTION WHEN OTHERS THEN
4005: x_return_status := fnd_api.g_ret_sts_unexp_error;
4006: IF g_fnd_debug = 'Y' THEN
4007: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
4008: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
4009: l_api_name || '.others_exception', x_retmsg || ':' || SQLERRM);
4010: END IF;
4011: END IF;

Line 4008: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

4004: EXCEPTION WHEN OTHERS THEN
4005: x_return_status := fnd_api.g_ret_sts_unexp_error;
4006: IF g_fnd_debug = 'Y' THEN
4007: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
4008: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
4009: l_api_name || '.others_exception', x_retmsg || ':' || SQLERRM);
4010: END IF;
4011: END IF;
4012: END save_reqcancel;

Line 4530: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN

4526:
4527: x_retmsg := 'SMRCH004';
4528:
4529: IF (g_fnd_debug = 'Y') THEN
4530: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
4531: fnd_log.string(fnd_log.level_statement,
4532: g_module_prefix || l_api_name,
4533: 'FUNDS CHECK:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);
4534: END IF;

Line 4531: fnd_log.string(fnd_log.level_statement,

4527: x_retmsg := 'SMRCH004';
4528:
4529: IF (g_fnd_debug = 'Y') THEN
4530: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
4531: fnd_log.string(fnd_log.level_statement,
4532: g_module_prefix || l_api_name,
4533: 'FUNDS CHECK:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);
4534: END IF;
4535: END IF;

Line 4716: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

4712: EXCEPTION WHEN OTHERS THEN
4713: x_return_status := fnd_api.g_ret_sts_unexp_error;
4714: x_retmsg := x_retmsg || ':' || SQLERRM;
4715: IF g_fnd_debug = 'Y' THEN
4716: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
4717: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
4718: l_api_name || '.others_exception', x_retmsg );
4719: END IF;
4720: END IF;

Line 4717: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

4713: x_return_status := fnd_api.g_ret_sts_unexp_error;
4714: x_retmsg := x_retmsg || ':' || SQLERRM;
4715: IF g_fnd_debug = 'Y' THEN
4716: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
4717: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
4718: l_api_name || '.others_exception', x_retmsg );
4719: END IF;
4720: END IF;
4721: END submit_reqchange;

Line 4834: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

4830:
4831: EXCEPTION WHEN OTHERS THEN
4832: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4833: IF g_fnd_debug = 'Y' THEN
4834: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
4835: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
4836: l_api_name || '.others_exception', SQLERRM);
4837: END IF;
4838: END IF;

Line 4835: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

4831: EXCEPTION WHEN OTHERS THEN
4832: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4833: IF g_fnd_debug = 'Y' THEN
4834: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
4835: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
4836: l_api_name || '.others_exception', SQLERRM);
4837: END IF;
4838: END IF;
4839: END submit_reqcancel;

Line 4896: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

4892:
4893: WHEN OTHERS THEN
4894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4895: IF (g_fnd_debug = 'Y') THEN
4896: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
4897: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
4898: l_api_name || '.others_exception',
4899: p_req_line_id||':'||sqlerrm);
4900: END IF;

Line 4897: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

4893: WHEN OTHERS THEN
4894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4895: IF (g_fnd_debug = 'Y') THEN
4896: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
4897: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
4898: l_api_name || '.others_exception',
4899: p_req_line_id||':'||sqlerrm);
4900: END IF;
4901: END IF;

Line 5075: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

5071:
5072: WHEN OTHERS THEN
5073: x_return_status := fnd_api.g_ret_sts_unexp_error;
5074: IF (g_fnd_debug = 'Y') THEN
5075: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5076: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5077: l_api_name || '.others_exception',
5078: p_req_line_id || ':' || SQLERRM);
5079: END IF;

Line 5076: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

5072: WHEN OTHERS THEN
5073: x_return_status := fnd_api.g_ret_sts_unexp_error;
5074: IF (g_fnd_debug = 'Y') THEN
5075: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5076: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5077: l_api_name || '.others_exception',
5078: p_req_line_id || ':' || SQLERRM);
5079: END IF;
5080: END IF;

Line 5182: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

5178:
5179: WHEN OTHERS THEN
5180: x_return_status := fnd_api.g_ret_sts_unexp_error;
5181: IF (g_fnd_debug = 'Y') THEN
5182: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5183: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5184: l_api_name || '.others_exception',
5185: p_req_line_id || ':' || SQLERRM);
5186: END IF;

Line 5183: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

5179: WHEN OTHERS THEN
5180: x_return_status := fnd_api.g_ret_sts_unexp_error;
5181: IF (g_fnd_debug = 'Y') THEN
5182: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5183: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5184: l_api_name || '.others_exception',
5185: p_req_line_id || ':' || SQLERRM);
5186: END IF;
5187: END IF;

Line 5397: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

5393: x_return_status := fnd_api.g_ret_sts_success;
5394: EXCEPTION WHEN OTHERS THEN
5395: x_return_status := fnd_api.g_ret_sts_unexp_error;
5396: IF g_fnd_debug = 'Y' THEN
5397: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5398: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5399: l_api_name || '.others_exception', l_progress || ':' || SQLERRM);
5400: END IF;
5401: END IF;

Line 5398: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

5394: EXCEPTION WHEN OTHERS THEN
5395: x_return_status := fnd_api.g_ret_sts_unexp_error;
5396: IF g_fnd_debug = 'Y' THEN
5397: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5398: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5399: l_api_name || '.others_exception', l_progress || ':' || SQLERRM);
5400: END IF;
5401: END IF;
5402: END save_ireqcancel;

Line 5655: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

5651:
5652:
5653:
5654: IF g_fnd_debug = 'Y' THEN
5655: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5656: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5657: l_api_name || '.others_exception', x_retmsg);
5658: END IF;
5659: END IF;

Line 5656: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

5652:
5653:
5654: IF g_fnd_debug = 'Y' THEN
5655: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5656: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5657: l_api_name || '.others_exception', x_retmsg);
5658: END IF;
5659: END IF;
5660: END save_ireqchange;

Line 5786: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

5782:
5783: EXCEPTION WHEN OTHERS THEN
5784: x_return_status := fnd_api.g_ret_sts_unexp_error ;
5785: IF g_fnd_debug = 'Y' THEN
5786: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5787: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5788: l_api_name || '.others_exception', SQLERRM);
5789: END IF;
5790: END IF;

Line 5787: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

5783: EXCEPTION WHEN OTHERS THEN
5784: x_return_status := fnd_api.g_ret_sts_unexp_error ;
5785: IF g_fnd_debug = 'Y' THEN
5786: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5787: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5788: l_api_name || '.others_exception', SQLERRM);
5789: END IF;
5790: END IF;
5791: END submit_ireqcancel;

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

6526:
6527: x_retMsg := 'SMRCH004';
6528:
6529: IF (g_fnd_debug = 'Y') THEN
6530: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6531: FND_LOG.string(FND_LOG.level_statement,
6532: g_module_prefix || l_api_name,
6533: 'FUNDS CHECK:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);
6534: END IF;

Line 6531: FND_LOG.string(FND_LOG.level_statement,

6527: x_retMsg := 'SMRCH004';
6528:
6529: IF (g_fnd_debug = 'Y') THEN
6530: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6531: FND_LOG.string(FND_LOG.level_statement,
6532: g_module_prefix || l_api_name,
6533: 'FUNDS CHECK:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);
6534: END IF;
6535: END IF;

Line 6730: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

6726: EXCEPTION WHEN OTHERS THEN
6727: x_return_status := fnd_api.g_ret_sts_unexp_error;
6728: x_retmsg := x_retmsg || ':' || SQLERRM;
6729: IF g_fnd_debug = 'Y' THEN
6730: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
6731: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
6732: l_api_name || '.others_exception', x_retmsg );
6733:
6734: END IF;

Line 6731: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||

6727: x_return_status := fnd_api.g_ret_sts_unexp_error;
6728: x_retmsg := x_retmsg || ':' || SQLERRM;
6729: IF g_fnd_debug = 'Y' THEN
6730: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
6731: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
6732: l_api_name || '.others_exception', x_retmsg );
6733:
6734: END IF;
6735: END IF;