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 1178: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN

1174: END IF;
1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: IF g_fnd_debug = 'Y' THEN
1178: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1179: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1180: l_api_name || '.others_exception',
1181: p_header_id || '*' || p_release_id || '*' || p_err_po_msg || ':' || SQLERRM);
1182: END IF;

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

1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: IF g_fnd_debug = 'Y' THEN
1178: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1179: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1180: l_api_name || '.others_exception',
1181: p_header_id || '*' || p_release_id || '*' || p_err_po_msg || ':' || SQLERRM);
1182: END IF;
1183: END IF;

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

1624: EXCEPTION WHEN OTHERS THEN
1625: x_return_status := fnd_api.g_ret_sts_unexp_error;
1626: x_retmsg := 'VC_Exp:' || x_retmsg || ':' || SQLERRM;
1627: IF g_fnd_debug = 'Y' THEN
1628: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1629: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1630: l_api_name || '.others_exception', x_retmsg);
1631: END IF;
1632: END IF;

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

1625: x_return_status := fnd_api.g_ret_sts_unexp_error;
1626: x_retmsg := 'VC_Exp:' || x_retmsg || ':' || SQLERRM;
1627: IF g_fnd_debug = 'Y' THEN
1628: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1629: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1630: l_api_name || '.others_exception', x_retmsg);
1631: END IF;
1632: END IF;
1633: END validate_changes;

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

1743:
1744: EXCEPTION WHEN OTHERS THEN
1745:
1746: IF g_fnd_debug = 'Y' THEN
1747: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1748: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1749: l_api_name || '.others_exception', SQLERRM);
1750: END IF;
1751: END IF;

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

1744: EXCEPTION WHEN OTHERS THEN
1745:
1746: IF g_fnd_debug = 'Y' THEN
1747: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1748: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1749: l_api_name || '.others_exception', SQLERRM);
1750: END IF;
1751: END IF;
1752: RAISE;

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

1799: END IF;
1800: EXCEPTION WHEN OTHERS THEN
1801: x_return_status := fnd_api.g_ret_sts_unexp_error;
1802: IF g_fnd_debug = 'Y' THEN
1803: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1804: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1805: l_api_name || '.others_exception', SQLERRM);
1806: END IF;
1807: END IF;

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

1800: EXCEPTION WHEN OTHERS THEN
1801: x_return_status := fnd_api.g_ret_sts_unexp_error;
1802: IF g_fnd_debug = 'Y' THEN
1803: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1804: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1805: l_api_name || '.others_exception', SQLERRM);
1806: END IF;
1807: END IF;
1808: END calculate_disttax;

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

1971: CLOSE l_line_id_with_price_chn_csr;
1972:
1973: EXCEPTION WHEN OTHERS THEN
1974: IF g_fnd_debug = 'Y' THEN
1975: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1976: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1977: l_api_name || '.others_exception',
1978: p_chn_req_grp_id || '*' || l_progress || ':' || SQLERRM);
1979: END IF;

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

1972:
1973: EXCEPTION WHEN OTHERS THEN
1974: IF g_fnd_debug = 'Y' THEN
1975: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
1976: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
1977: l_api_name || '.others_exception',
1978: p_chn_req_grp_id || '*' || l_progress || ':' || SQLERRM);
1979: END IF;
1980: END IF;

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

2099: CLOSE l_line_id_with_qty_chn_csr;
2100:
2101: EXCEPTION WHEN OTHERS THEN
2102: IF g_fnd_debug = 'Y' THEN
2103: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
2104: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
2105: l_api_name || '.others_exception',
2106: p_chn_req_grp_id || '*' || l_progress || ':' || SQLERRM);
2107: END IF;

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

2100:
2101: EXCEPTION WHEN OTHERS THEN
2102: IF g_fnd_debug = 'Y' THEN
2103: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
2104: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
2105: l_api_name || '.others_exception',
2106: p_chn_req_grp_id || '*' || l_progress || ':' || SQLERRM);
2107: END IF;
2108: END IF;

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

2654:
2655: --Exception Handling will be taken care of in parent procedures
2656: EXCEPTION WHEN OTHERS THEN
2657: IF g_fnd_debug = 'Y' THEN
2658: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
2659: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
2660: l_api_name || '.others_exception',
2661: l_progress || ':' || SQLERRM);
2662: END IF;

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

2655: --Exception Handling will be taken care of in parent procedures
2656: EXCEPTION WHEN OTHERS THEN
2657: IF g_fnd_debug = 'Y' THEN
2658: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
2659: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
2660: l_api_name || '.others_exception',
2661: l_progress || ':' || SQLERRM);
2662: END IF;
2663: END IF;

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

2807:
2808: IF (l_cancelled = 'Y' ) THEN
2809:
2810: IF (g_fnd_debug = 'Y') THEN
2811: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2812: fnd_log.string(fnd_log.level_statement,
2813: g_module_prefix || l_api_name,
2814: 'Req Line ID:' || p_req_line_id || ' ' ||
2815: 'is Already cancelled');

Line 2812: fnd_log.string(fnd_log.level_statement,

2808: IF (l_cancelled = 'Y' ) THEN
2809:
2810: IF (g_fnd_debug = 'Y') THEN
2811: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2812: fnd_log.string(fnd_log.level_statement,
2813: g_module_prefix || l_api_name,
2814: 'Req Line ID:' || p_req_line_id || ' ' ||
2815: 'is Already cancelled');
2816: END IF;

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

2829: p_req_header_id =>null,
2830: x_cancellable =>is_so_cancel);
2831:
2832: IF (g_fnd_debug = 'Y') THEN
2833: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2834: fnd_log.string(fnd_log.level_statement,
2835: g_module_prefix || l_api_name,
2836: 'Req Line ID:' || p_req_line_id || ' ' ||
2837: 'transferred to so ='||is_so_cancel||' status'||l_sts);

Line 2834: fnd_log.string(fnd_log.level_statement,

2830: x_cancellable =>is_so_cancel);
2831:
2832: IF (g_fnd_debug = 'Y') THEN
2833: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2834: fnd_log.string(fnd_log.level_statement,
2835: g_module_prefix || l_api_name,
2836: 'Req Line ID:' || p_req_line_id || ' ' ||
2837: 'transferred to so ='||is_so_cancel||' status'||l_sts);
2838: END IF;

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

2949: IF (l_received_quantity >= l_quantity OR
2950: l_received_amount >= l_amount) THEN
2951:
2952: IF (g_fnd_debug = 'Y') THEN
2953: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2954: fnd_log.string(fnd_log.level_statement,
2955: g_module_prefix || l_api_name,
2956: 'Req Line ID:' || p_req_line_id || ' ' ||
2957: 'Shipment Fully Received');

Line 2954: fnd_log.string(fnd_log.level_statement,

2950: l_received_amount >= l_amount) THEN
2951:
2952: IF (g_fnd_debug = 'Y') THEN
2953: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2954: fnd_log.string(fnd_log.level_statement,
2955: g_module_prefix || l_api_name,
2956: 'Req Line ID:' || p_req_line_id || ' ' ||
2957: 'Shipment Fully Received');
2958: END IF;

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

2968: IF (l_billed_quantity > l_quantity OR
2969: l_billed_amount > l_amount) THEN
2970:
2971: IF (g_fnd_debug = 'Y') THEN
2972: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2973: fnd_log.string(fnd_log.level_statement,
2974: g_module_prefix || l_api_name,
2975: 'Req Line ID:' || p_req_line_id || ' ' ||
2976: 'Shipment Fully Billed');

Line 2973: fnd_log.string(fnd_log.level_statement,

2969: l_billed_amount > l_amount) THEN
2970:
2971: IF (g_fnd_debug = 'Y') THEN
2972: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2973: fnd_log.string(fnd_log.level_statement,
2974: g_module_prefix || l_api_name,
2975: 'Req Line ID:' || p_req_line_id || ' ' ||
2976: 'Shipment Fully Billed');
2977: END IF;

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

2991: nvl(l_receipt_required_flag, 'Y') <> 'N' AND
2992: l_billed_amount > l_received_amount)) THEN
2993:
2994: IF (g_fnd_debug = 'Y') THEN
2995: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2996: fnd_log.string(fnd_log.level_statement,
2997: g_module_prefix || l_api_name,
2998: 'Req Line ID:' || p_req_line_id || ' ' ||
2999: 'Shipment Over Billed');

Line 2996: fnd_log.string(fnd_log.level_statement,

2992: l_billed_amount > l_received_amount)) THEN
2993:
2994: IF (g_fnd_debug = 'Y') THEN
2995: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
2996: fnd_log.string(fnd_log.level_statement,
2997: g_module_prefix || l_api_name,
2998: 'Req Line ID:' || p_req_line_id || ' ' ||
2999: 'Shipment Over Billed');
3000: END IF;

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

3017:
3018: IF (l_rcv_transaction_exist = 1) THEN
3019:
3020: IF (g_fnd_debug = 'Y') THEN
3021: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3022: fnd_log.string(fnd_log.level_statement,
3023: g_module_prefix || l_api_name,
3024: 'Req Line ID:' || p_req_line_id || ' ' ||
3025: 'RCV transaction exists for Shipment');

Line 3022: fnd_log.string(fnd_log.level_statement,

3018: IF (l_rcv_transaction_exist = 1) THEN
3019:
3020: IF (g_fnd_debug = 'Y') THEN
3021: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3022: fnd_log.string(fnd_log.level_statement,
3023: g_module_prefix || l_api_name,
3024: 'Req Line ID:' || p_req_line_id || ' ' ||
3025: 'RCV transaction exists for Shipment');
3026: END IF;

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

3050:
3051: IF (l_asn_exist = 1) THEN
3052:
3053: IF (g_fnd_debug = 'Y') THEN
3054: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3055: fnd_log.string(fnd_log.level_statement,
3056: g_module_prefix || l_api_name,
3057: 'Req Line ID:' || p_req_line_id || ' ' ||
3058: 'ASN not Fully Received');

Line 3055: fnd_log.string(fnd_log.level_statement,

3051: IF (l_asn_exist = 1) THEN
3052:
3053: IF (g_fnd_debug = 'Y') THEN
3054: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3055: fnd_log.string(fnd_log.level_statement,
3056: g_module_prefix || l_api_name,
3057: 'Req Line ID:' || p_req_line_id || ' ' ||
3058: 'ASN not Fully Received');
3059: END IF;

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

3089:
3090: IF (l_not_delivered = 1) THEN
3091:
3092: IF (g_fnd_debug = 'Y') THEN
3093: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3094: fnd_log.string(fnd_log.level_statement,
3095: g_module_prefix || l_api_name,
3096: 'Req Line ID:' || p_req_line_id || ' ' ||
3097: 'Shipment Received but not Delivered');

Line 3094: fnd_log.string(fnd_log.level_statement,

3090: IF (l_not_delivered = 1) THEN
3091:
3092: IF (g_fnd_debug = 'Y') THEN
3093: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3094: fnd_log.string(fnd_log.level_statement,
3095: g_module_prefix || l_api_name,
3096: 'Req Line ID:' || p_req_line_id || ' ' ||
3097: 'Shipment Received but not Delivered');
3098: END IF;

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

3139:
3140: IF (l_dist_not_valid = 1) THEN
3141:
3142: IF (g_fnd_debug = 'Y') THEN
3143: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3144: fnd_log.string(fnd_log.level_statement,
3145: g_module_prefix || l_api_name,
3146: 'Req Line ID:' || p_req_line_id || ' ' ||
3147: 'Distribution Checks Failed');

Line 3144: fnd_log.string(fnd_log.level_statement,

3140: IF (l_dist_not_valid = 1) THEN
3141:
3142: IF (g_fnd_debug = 'Y') THEN
3143: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3144: fnd_log.string(fnd_log.level_statement,
3145: g_module_prefix || l_api_name,
3146: 'Req Line ID:' || p_req_line_id || ' ' ||
3147: 'Distribution Checks Failed');
3148: END IF;

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

3211: -- set org context to the original value
3212: po_moac_utils_pvt.set_org_context(l_req_org_id) ; --
3213:
3214: IF (g_fnd_debug = 'Y') THEN
3215: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3216: fnd_log.string(fnd_log.level_statement,
3217: g_module_prefix || l_api_name,
3218: 'PO_Document_Control_GRP.check_control_action result:' || l_return_status);
3219: END IF;

Line 3216: fnd_log.string(fnd_log.level_statement,

3212: po_moac_utils_pvt.set_org_context(l_req_org_id) ; --
3213:
3214: IF (g_fnd_debug = 'Y') THEN
3215: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
3216: fnd_log.string(fnd_log.level_statement,
3217: g_module_prefix || l_api_name,
3218: 'PO_Document_Control_GRP.check_control_action result:' || l_return_status);
3219: END IF;
3220: END IF;

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

3228: END IF;
3229: EXCEPTION WHEN OTHERS THEN
3230: x_return_status := fnd_api.g_ret_sts_unexp_error;
3231: IF (g_fnd_debug = 'Y') THEN
3232: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
3233: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
3234: l_api_name || '.others_exception',
3235: p_req_line_id || '*' || l_progress || ':' || SQLERRM);
3236: END IF;

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

3229: EXCEPTION WHEN OTHERS THEN
3230: x_return_status := fnd_api.g_ret_sts_unexp_error;
3231: IF (g_fnd_debug = 'Y') THEN
3232: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
3233: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
3234: l_api_name || '.others_exception',
3235: p_req_line_id || '*' || l_progress || ':' || SQLERRM);
3236: END IF;
3237: END IF;

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

3680: END IF;
3681:
3682: EXCEPTION WHEN OTHERS THEN
3683: IF g_fnd_debug = 'Y' THEN
3684: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
3685: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
3686: l_api_name || '.others_exception',
3687: p_req_line_id || '*' || l_progress || ':' || SQLERRM);
3688: END IF;

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

3681:
3682: EXCEPTION WHEN OTHERS THEN
3683: IF g_fnd_debug = 'Y' THEN
3684: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
3685: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
3686: l_api_name || '.others_exception',
3687: p_req_line_id || '*' || l_progress || ':' || SQLERRM);
3688: END IF;
3689: END IF;

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

3903: WHEN OTHERS THEN
3904: x_retmsg := 'SRCHUNEXP:' || x_retmsg || ':' || SQLERRM;
3905: x_return_status := fnd_api.g_ret_sts_unexp_error;
3906: IF g_fnd_debug = 'Y' THEN
3907: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
3908: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
3909: l_api_name || '.others_exception', x_retmsg);
3910: END IF;
3911: END IF;

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

3904: x_retmsg := 'SRCHUNEXP:' || x_retmsg || ':' || SQLERRM;
3905: x_return_status := fnd_api.g_ret_sts_unexp_error;
3906: IF g_fnd_debug = 'Y' THEN
3907: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
3908: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
3909: l_api_name || '.others_exception', x_retmsg);
3910: END IF;
3911: END IF;
3912: END save_reqchange;

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

4084: x_return_status := fnd_api.g_ret_sts_success;
4085: EXCEPTION WHEN OTHERS THEN
4086: x_return_status := fnd_api.g_ret_sts_unexp_error;
4087: IF g_fnd_debug = 'Y' THEN
4088: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
4089: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
4090: l_api_name || '.others_exception', x_retmsg || ':' || SQLERRM);
4091: END IF;
4092: END IF;

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

4085: EXCEPTION WHEN OTHERS THEN
4086: x_return_status := fnd_api.g_ret_sts_unexp_error;
4087: IF g_fnd_debug = 'Y' THEN
4088: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
4089: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
4090: l_api_name || '.others_exception', x_retmsg || ':' || SQLERRM);
4091: END IF;
4092: END IF;
4093: END save_reqcancel;

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

4659:
4660: x_retmsg := 'SMRCH004';
4661:
4662: IF (g_fnd_debug = 'Y') THEN
4663: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
4664: fnd_log.string(fnd_log.level_statement,
4665: g_module_prefix || l_api_name,
4666: 'FUNDS CHECK:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);
4667: END IF;

Line 4664: fnd_log.string(fnd_log.level_statement,

4660: x_retmsg := 'SMRCH004';
4661:
4662: IF (g_fnd_debug = 'Y') THEN
4663: IF (fnd_log.g_current_runtime_level <= fnd_log.level_statement) THEN
4664: fnd_log.string(fnd_log.level_statement,
4665: g_module_prefix || l_api_name,
4666: 'FUNDS CHECK:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);
4667: END IF;
4668: END IF;

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

4848: EXCEPTION WHEN OTHERS THEN
4849: x_return_status := fnd_api.g_ret_sts_unexp_error;
4850: x_retmsg := x_retmsg || ':' || SQLERRM;
4851: IF g_fnd_debug = 'Y' THEN
4852: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
4853: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
4854: l_api_name || '.others_exception', x_retmsg );
4855: END IF;
4856: END IF;

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

4849: x_return_status := fnd_api.g_ret_sts_unexp_error;
4850: x_retmsg := x_retmsg || ':' || SQLERRM;
4851: IF g_fnd_debug = 'Y' THEN
4852: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
4853: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
4854: l_api_name || '.others_exception', x_retmsg );
4855: END IF;
4856: END IF;
4857: END submit_reqchange;

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

4966:
4967: EXCEPTION WHEN OTHERS THEN
4968: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4969: IF g_fnd_debug = 'Y' THEN
4970: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
4971: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
4972: l_api_name || '.others_exception', SQLERRM);
4973: END IF;
4974: END IF;

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

4967: EXCEPTION WHEN OTHERS THEN
4968: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4969: IF g_fnd_debug = 'Y' THEN
4970: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
4971: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
4972: l_api_name || '.others_exception', SQLERRM);
4973: END IF;
4974: END IF;
4975: END submit_reqcancel;

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

5028:
5029: WHEN OTHERS THEN
5030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5031: IF (g_fnd_debug = 'Y') THEN
5032: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
5033: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
5034: l_api_name || '.others_exception',
5035: p_req_line_id||':'||sqlerrm);
5036: END IF;

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

5029: WHEN OTHERS THEN
5030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5031: IF (g_fnd_debug = 'Y') THEN
5032: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
5033: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
5034: l_api_name || '.others_exception',
5035: p_req_line_id||':'||sqlerrm);
5036: END IF;
5037: END IF;

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

5223:
5224: WHEN OTHERS THEN
5225: x_return_status := fnd_api.g_ret_sts_unexp_error;
5226: IF (g_fnd_debug = 'Y') THEN
5227: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5228: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5229: l_api_name || '.others_exception',
5230: p_req_line_id || ':' || SQLERRM);
5231: END IF;

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

5224: WHEN OTHERS THEN
5225: x_return_status := fnd_api.g_ret_sts_unexp_error;
5226: IF (g_fnd_debug = 'Y') THEN
5227: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5228: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5229: l_api_name || '.others_exception',
5230: p_req_line_id || ':' || SQLERRM);
5231: END IF;
5232: END IF;

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

5336:
5337: WHEN OTHERS THEN
5338: x_return_status := fnd_api.g_ret_sts_unexp_error;
5339: IF (g_fnd_debug = 'Y') THEN
5340: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5341: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5342: l_api_name || '.others_exception',
5343: p_req_line_id || ':' || SQLERRM);
5344: END IF;

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

5337: WHEN OTHERS THEN
5338: x_return_status := fnd_api.g_ret_sts_unexp_error;
5339: IF (g_fnd_debug = 'Y') THEN
5340: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5341: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5342: l_api_name || '.others_exception',
5343: p_req_line_id || ':' || SQLERRM);
5344: END IF;
5345: END IF;

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

5551: x_return_status := fnd_api.g_ret_sts_success;
5552: EXCEPTION WHEN OTHERS THEN
5553: x_return_status := fnd_api.g_ret_sts_unexp_error;
5554: IF g_fnd_debug = 'Y' THEN
5555: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5556: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5557: l_api_name || '.others_exception', l_progress || ':' || SQLERRM);
5558: END IF;
5559: END IF;

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

5552: EXCEPTION WHEN OTHERS THEN
5553: x_return_status := fnd_api.g_ret_sts_unexp_error;
5554: IF g_fnd_debug = 'Y' THEN
5555: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5556: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5557: l_api_name || '.others_exception', l_progress || ':' || SQLERRM);
5558: END IF;
5559: END IF;
5560: END save_ireqcancel;

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

5809:
5810:
5811:
5812: IF g_fnd_debug = 'Y' THEN
5813: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5814: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5815: l_api_name || '.others_exception', x_retmsg);
5816: END IF;
5817: END IF;

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

5810:
5811:
5812: IF g_fnd_debug = 'Y' THEN
5813: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5814: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5815: l_api_name || '.others_exception', x_retmsg);
5816: END IF;
5817: END IF;
5818: END save_ireqchange;

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

5940:
5941: EXCEPTION WHEN OTHERS THEN
5942: x_return_status := fnd_api.g_ret_sts_unexp_error ;
5943: IF g_fnd_debug = 'Y' THEN
5944: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5945: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5946: l_api_name || '.others_exception', SQLERRM);
5947: END IF;
5948: END IF;

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

5941: EXCEPTION WHEN OTHERS THEN
5942: x_return_status := fnd_api.g_ret_sts_unexp_error ;
5943: IF g_fnd_debug = 'Y' THEN
5944: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
5945: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
5946: l_api_name || '.others_exception', SQLERRM);
5947: END IF;
5948: END IF;
5949: END submit_ireqcancel;

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

6577:
6578: x_retMsg := 'SMRCH004';
6579:
6580: IF (g_fnd_debug = 'Y') THEN
6581: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6582: FND_LOG.string(FND_LOG.level_statement,
6583: g_module_prefix || l_api_name,
6584: 'FUNDS CHECK:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);
6585: END IF;

Line 6582: FND_LOG.string(FND_LOG.level_statement,

6578: x_retMsg := 'SMRCH004';
6579:
6580: IF (g_fnd_debug = 'Y') THEN
6581: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
6582: FND_LOG.string(FND_LOG.level_statement,
6583: g_module_prefix || l_api_name,
6584: 'FUNDS CHECK:' || l_fc_result_status ||' PO RETURN CODE:' || l_po_return_code);
6585: END IF;
6586: END IF;

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

6777: EXCEPTION WHEN OTHERS THEN
6778: x_return_status := fnd_api.g_ret_sts_unexp_error;
6779: x_retmsg := x_retmsg || ':' || SQLERRM;
6780: IF g_fnd_debug = 'Y' THEN
6781: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
6782: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
6783: l_api_name || '.others_exception', x_retmsg );
6784:
6785: END IF;

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

6778: x_return_status := fnd_api.g_ret_sts_unexp_error;
6779: x_retmsg := x_retmsg || ':' || SQLERRM;
6780: IF g_fnd_debug = 'Y' THEN
6781: IF (fnd_log.g_current_runtime_level <= fnd_log.level_unexpected) THEN
6782: fnd_log.string(fnd_log.level_unexpected, g_module_prefix ||
6783: l_api_name || '.others_exception', x_retmsg );
6784:
6785: END IF;
6786: END IF;