DBA Data[Home] [Help]

APPS.PO_ENCUMBRANCE_PREPROCESSING dependencies on FND_API

Line 946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

942: FND_MESSAGE.set_name('PO', 'PO_ALL_INVALID_PARAMETER');
943: FND_MESSAGE.set_token('PROCEDURE', l_api_name);
944: FND_MESSAGE.set_token('PACKAGE', g_pkg_name);
945: fnd_msg_pub.add;
946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
947:
948: WHEN OTHERS THEN
949: --add message to the stack and log a debug msg if necessary
950: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

Line 1219: IF l_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR,

1215: );
1216:
1217: l_progress := '250';
1218:
1219: IF l_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR,
1220: FND_API.G_RET_STS_ERROR) THEN
1221: RAISE G_POPULATE_ENC_GT_EXC;
1222: END IF;
1223:

Line 1220: FND_API.G_RET_STS_ERROR) THEN

1216:
1217: l_progress := '250';
1218:
1219: IF l_return_status IN (FND_API.G_RET_STS_UNEXP_ERROR,
1220: FND_API.G_RET_STS_ERROR) THEN
1221: RAISE G_POPULATE_ENC_GT_EXC;
1222: END IF;
1223:
1224: ELSE

Line 1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1300: PO_DEBUG.debug_exc(l_log_head,l_progress);
1301: END IF;
1302: -- populate_enc_gt should have left its error msg on the stack
1303: -- no further action required
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305:
1306: WHEN PO_CORE_S.G_INVALID_CALL_EXC THEN
1307: IF g_debug_unexp THEN
1308: PO_DEBUG.debug_exc(l_log_head,l_progress);

Line 1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1310: FND_MESSAGE.set_name('PO', 'PO_ALL_INVALID_PARAMETER');
1311: FND_MESSAGE.set_token('PROCEDURE', l_api_name);
1312: FND_MESSAGE.set_token('PACKAGE', g_pkg_name);
1313: fnd_msg_pub.add;
1314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1315:
1316: WHEN OTHERS THEN
1317: --add message to the stack and log a debug msg if necessary
1318: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

Line 1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1983: FND_MESSAGE.set_name('PO', 'PO_ALL_INVALID_PARAMETER');
1984: FND_MESSAGE.set_token('PROCEDURE', l_api_name);
1985: FND_MESSAGE.set_token('PACKAGE', g_pkg_name);
1986: fnd_msg_pub.add;
1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1988:
1989: WHEN OTHERS THEN
1990: --add message to the stack and log a debug msg if necessary
1991: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

Line 2320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2316: FND_MESSAGE.set_name('PO', 'PO_ALL_INVALID_PARAMETER');
2317: FND_MESSAGE.set_token('PROCEDURE', l_api_name);
2318: FND_MESSAGE.set_token('PACKAGE', g_pkg_name);
2319: fnd_msg_pub.add;
2320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2321:
2322: WHEN OTHERS THEN
2323: --add message to the stack and log a debug msg if necessary
2324: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

Line 2433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2429: FND_MESSAGE.set_name('PO', 'PO_ALL_INVALID_PARAMETER');
2430: FND_MESSAGE.set_token('PROCEDURE', l_api_name);
2431: FND_MESSAGE.set_token('PACKAGE', g_pkg_name);
2432: fnd_msg_pub.add;
2433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2434:
2435: WHEN OTHERS THEN
2436: --add message to the stack and log a debug msg if necessary
2437: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

Line 2773: RAISE FND_API.G_EXC_ERROR;

2769: l_progress := '090';
2770:
2771: l_exc_message_name := 'PO_ENC_NA_OU';
2772: l_exc_code := g_ENC_VALIDATION_EXC_CODE;
2773: RAISE FND_API.G_EXC_ERROR;
2774:
2775: ELSE
2776: l_progress := '095';
2777: IF g_debug_stmt THEN

Line 2843: RAISE FND_API.G_EXC_ERROR;

2839:
2840: IF (l_doc_level_tbl.COUNT <> 1) THEN
2841: l_progress := 'a35';
2842: l_exc_code := g_INVALID_CALL_EXC_CODE;
2843: RAISE FND_API.G_EXC_ERROR;
2844: END IF;
2845:
2846: l_doc_level := l_doc_level_tbl(1);
2847:

Line 2862: RAISE FND_API.G_EXC_ERROR;

2858:
2859: IF (l_doc_level_id_tbl.COUNT <> l_count_tbl(1)) THEN
2860: l_progress := 'a55';
2861: l_exc_code := g_INVALID_CALL_EXC_CODE;
2862: RAISE FND_API.G_EXC_ERROR;
2863: END IF;
2864:
2865: l_progress := 'a60';
2866:

Line 2942: RAISE FND_API.G_EXC_ERROR;

2938: -- actions on PAs only allowed at the header level
2939: IF (l_doc_level <> g_doc_level_HEADER) THEN
2940: l_progress := '125';
2941: l_exc_code := g_INVALID_CALL_EXC_CODE;
2942: RAISE FND_API.G_EXC_ERROR;
2943: END IF;
2944:
2945: l_progress := '130';
2946:

Line 2969: RAISE FND_API.G_EXC_ERROR;

2965: l_progress := '150';
2966:
2967: l_exc_message_name := 'PO_ENC_NA_DOC';
2968: l_exc_code := g_ENC_VALIDATION_EXC_CODE;
2969: RAISE FND_API.G_EXC_ERROR;
2970:
2971: ELSE
2972: l_progress := '160';
2973: IF g_debug_stmt THEN

Line 3090: RAISE FND_API.G_EXC_ERROR;

3086: l_progress := '285';
3087:
3088: l_exc_message_name := 'PO_ENC_API_MULTIPLE_DOCS';
3089: l_exc_code := g_ENC_VALIDATION_EXC_CODE;
3090: RAISE FND_API.G_EXC_ERROR;
3091:
3092: ELSE
3093: l_progress := '290';
3094: IF g_debug_stmt THEN

Line 3211: RAISE FND_API.G_EXC_ERROR;

3207: l_progress := '430';
3208:
3209: l_exc_message_name := 'PO_ALL_INVALID_DOC_STATE';
3210: l_exc_code := g_ENC_VALIDATION_EXC_CODE;
3211: RAISE FND_API.G_EXC_ERROR;
3212:
3213: ELSE
3214: l_progress := '440';
3215: IF g_debug_stmt THEN

Line 3249: l_return_status := FND_API.G_RET_STS_SUCCESS;

3245:
3246: -- Initialize the return variables.
3247:
3248: l_sub_check_status := NULL;
3249: l_return_status := FND_API.G_RET_STS_SUCCESS;
3250:
3251: -- Set up the submission check call.
3252:
3253: l_progress := '520';

Line 3350: IF (l_sub_check_status <> FND_API.G_RET_STS_SUCCESS) THEN

3346: PO_DEBUG.debug_var(l_log_head,l_progress,'l_msg_data',l_msg_data);
3347: PO_DEBUG.debug_var(l_log_head,l_progress,'x_sub_check_report_id',x_sub_check_report_id);
3348: END IF;
3349:
3350: IF (l_sub_check_status <> FND_API.G_RET_STS_SUCCESS) THEN
3351: l_progress := '560';
3352: l_exc_code := g_SUBMISSION_CHECK_EXC_CODE;
3353: RAISE FND_API.G_EXC_ERROR;
3354: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3353: RAISE FND_API.G_EXC_ERROR;

3349:
3350: IF (l_sub_check_status <> FND_API.G_RET_STS_SUCCESS) THEN
3351: l_progress := '560';
3352: l_exc_code := g_SUBMISSION_CHECK_EXC_CODE;
3353: RAISE FND_API.G_EXC_ERROR;
3354: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3355: l_progress := '570';
3356: l_exc_message_name := 'PO_ALL_INVALID_DOC_STATE';
3357: l_exc_code := g_ENC_VALIDATION_EXC_CODE;

Line 3354: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3350: IF (l_sub_check_status <> FND_API.G_RET_STS_SUCCESS) THEN
3351: l_progress := '560';
3352: l_exc_code := g_SUBMISSION_CHECK_EXC_CODE;
3353: RAISE FND_API.G_EXC_ERROR;
3354: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3355: l_progress := '570';
3356: l_exc_message_name := 'PO_ALL_INVALID_DOC_STATE';
3357: l_exc_code := g_ENC_VALIDATION_EXC_CODE;
3358: RAISE FND_API.G_EXC_ERROR;

Line 3358: RAISE FND_API.G_EXC_ERROR;

3354: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3355: l_progress := '570';
3356: l_exc_message_name := 'PO_ALL_INVALID_DOC_STATE';
3357: l_exc_code := g_ENC_VALIDATION_EXC_CODE;
3358: RAISE FND_API.G_EXC_ERROR;
3359: END IF;
3360:
3361: END LOOP;
3362:

Line 3941: WHEN FND_API.G_EXC_ERROR THEN

3937: End If;
3938:
3939:
3940: EXCEPTION
3941: WHEN FND_API.G_EXC_ERROR THEN
3942: RAISE;
3943:
3944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3945: RAISE;

Line 3944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3940: EXCEPTION
3941: WHEN FND_API.G_EXC_ERROR THEN
3942: RAISE;
3943:
3944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3945: RAISE;
3946:
3947: WHEN PO_DOCUMENT_FUNDS_PVT.G_NO_VALID_PERIOD_EXC THEN
3948: RAISE;

Line 3984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3980: WHEN OTHERS THEN
3981: --add message to the stack and log a debug msg if necessary
3982: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
3983: fnd_msg_pub.add;
3984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3985:
3986: END derive_packet_values;
3987:
3988:

Line 4292: WHEN FND_API.G_EXC_ERROR THEN

4288:
4289:
4290: EXCEPTION
4291:
4292: WHEN FND_API.G_EXC_ERROR THEN
4293: RAISE;
4294:
4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: RAISE;

Line 4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4291:
4292: WHEN FND_API.G_EXC_ERROR THEN
4293: RAISE;
4294:
4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: RAISE;
4297:
4298: WHEN PO_DOCUMENT_FUNDS_PVT.G_NO_VALID_PERIOD_EXC THEN
4299: RAISE;

Line 4305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4301: WHEN OTHERS THEN
4302: --add message to the stack and log a debug msg if necessary
4303: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
4304: fnd_msg_pub.add;
4305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4306:
4307: END get_period_info;
4308:
4309:

Line 5076: WHEN FND_API.G_EXC_ERROR THEN

5072: END IF;
5073:
5074:
5075: EXCEPTION
5076: WHEN FND_API.G_EXC_ERROR THEN
5077: RAISE;
5078:
5079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5080: RAISE;

Line 5079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5075: EXCEPTION
5076: WHEN FND_API.G_EXC_ERROR THEN
5077: RAISE;
5078:
5079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5080: RAISE;
5081:
5082: WHEN PO_DOCUMENT_FUNDS_PVT.g_UOM_CONVERSION_EXC THEN ----
5083: RAISE;

Line 5089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5085: WHEN OTHERS THEN
5086: --add message to the stack and log a debug msg if necessary
5087: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
5088: fnd_msg_pub.add;
5089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5090:
5091: END get_amounts;
5092:
5093:

Line 5253: WHEN FND_API.G_EXC_ERROR THEN

5249: END IF;
5250:
5251:
5252: EXCEPTION
5253: WHEN FND_API.G_EXC_ERROR THEN
5254: RAISE;
5255:
5256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5257: RAISE;

Line 5256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5252: EXCEPTION
5253: WHEN FND_API.G_EXC_ERROR THEN
5254: RAISE;
5255:
5256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5257: RAISE;
5258:
5259: WHEN OTHERS THEN
5260: --add message to the stack and log a debug msg if necessary

Line 5263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5259: WHEN OTHERS THEN
5260: --add message to the stack and log a debug msg if necessary
5261: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
5262: fnd_msg_pub.add;
5263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5264:
5265: END get_initial_amounts;
5266:
5267:

Line 5585: WHEN FND_API.G_EXC_ERROR THEN

5581: END IF;
5582:
5583:
5584: EXCEPTION
5585: WHEN FND_API.G_EXC_ERROR THEN
5586: RAISE;
5587:
5588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5589: RAISE;

Line 5588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5584: EXCEPTION
5585: WHEN FND_API.G_EXC_ERROR THEN
5586: RAISE;
5587:
5588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5589: RAISE;
5590:
5591: WHEN OTHERS THEN
5592: --add message to the stack and log a debug msg if necessary

Line 5595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5591: WHEN OTHERS THEN
5592: --add message to the stack and log a debug msg if necessary
5593: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
5594: fnd_msg_pub.add;
5595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5596:
5597: END get_main_doc_amts;
5598:
5599:

Line 5780: -- and Backing Requistion UOM , user defined exception FND_API.G_EXC_ERROR

5776: END IF;
5777:
5778: ----
5779: -- When the Conversion rate is not defined between the main document UOM
5780: -- and Backing Requistion UOM , user defined exception FND_API.G_EXC_ERROR
5781: -- is being thrown and the encumbrance action is stopped without showning the details
5782: -- of the error.
5783: -- Added the below code to update PO_ENCUMBRANCE_GT table with result text
5784: -- showing the details of the error .

Line 5807: RAISE PO_DOCUMENT_FUNDS_PVT.g_UOM_CONVERSION_EXC; --FND_API.G_EXC_ERROR

5803: AND REQ_DISTS.distribution_type = g_dist_type_REQUISITION
5804: AND REQ_DISTS.uom_conversion_rate = -999
5805: );
5806:
5807: RAISE PO_DOCUMENT_FUNDS_PVT.g_UOM_CONVERSION_EXC; --FND_API.G_EXC_ERROR
5808: END IF;
5809: ----
5810:
5811: l_progress := '050';

Line 6063: WHEN FND_API.G_EXC_ERROR THEN

6059: END IF;
6060:
6061:
6062: EXCEPTION
6063: WHEN FND_API.G_EXC_ERROR THEN
6064: RAISE;
6065:
6066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6067: RAISE;

Line 6066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6062: EXCEPTION
6063: WHEN FND_API.G_EXC_ERROR THEN
6064: RAISE;
6065:
6066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6067: RAISE;
6068:
6069: WHEN PO_DOCUMENT_FUNDS_PVT.g_UOM_CONVERSION_EXC THEN ----
6070: RAISE;

Line 6076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6072: WHEN OTHERS THEN
6073: --add message to the stack and log a debug msg if necessary
6074: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
6075: fnd_msg_pub.add;
6076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6077:
6078: END get_backing_doc_amts;
6079:
6080:

Line 6471: WHEN FND_API.G_EXC_ERROR THEN

6467: END IF;
6468:
6469:
6470: EXCEPTION
6471: WHEN FND_API.G_EXC_ERROR THEN
6472: RAISE;
6473:
6474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6475: RAISE;

Line 6474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6470: EXCEPTION
6471: WHEN FND_API.G_EXC_ERROR THEN
6472: RAISE;
6473:
6474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6475: RAISE;
6476:
6477: WHEN OTHERS THEN
6478: --add message to the stack and log a debug msg if necessary

Line 6481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6477: WHEN OTHERS THEN
6478: --add message to the stack and log a debug msg if necessary
6479: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
6480: fnd_msg_pub.add;
6481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6482:
6483: END get_final_amounts;
6484:
6485:

Line 6667: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6663: , p_round_only_flag_tbl => l_round_only_flag_tbl --bug 3568671
6664: , x_amount_out_tbl => l_amount_result_tbl
6665: );
6666:
6667: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6668: l_progress := '015';
6669: -- the API already pushed the SQL error details
6670: -- onto the message stack, so just raise this to
6671: -- bubble back up to do_action.

Line 6672: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

6668: l_progress := '015';
6669: -- the API already pushed the SQL error details
6670: -- onto the message stack, so just raise this to
6671: -- bubble back up to do_action.
6672: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
6673: END IF;
6674:
6675: l_progress := '020';
6676:

Line 6725: WHEN FND_API.G_EXC_ERROR THEN

6721: END IF;
6722: ----
6723:
6724: EXCEPTION
6725: WHEN FND_API.G_EXC_ERROR THEN
6726: RAISE;
6727:
6728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6729: RAISE;

Line 6728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6724: EXCEPTION
6725: WHEN FND_API.G_EXC_ERROR THEN
6726: RAISE;
6727:
6728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6729: RAISE;
6730:
6731: WHEN OTHERS THEN
6732: --add message to the stack and log a debug msg if necessary

Line 6735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6731: WHEN OTHERS THEN
6732: --add message to the stack and log a debug msg if necessary
6733: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
6734: fnd_msg_pub.add;
6735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6736:
6737: END round_and_convert_amounts;
6738:
6739:

Line 6978: WHEN FND_API.G_EXC_ERROR THEN

6974: END IF;
6975: End If;
6976:
6977: EXCEPTION
6978: WHEN FND_API.G_EXC_ERROR THEN
6979: RAISE;
6980:
6981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6982: RAISE;

Line 6981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6977: EXCEPTION
6978: WHEN FND_API.G_EXC_ERROR THEN
6979: RAISE;
6980:
6981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6982: RAISE;
6983:
6984: WHEN OTHERS THEN
6985: --add message to the stack and log a debug msg if necessary

Line 6988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6984: WHEN OTHERS THEN
6985: --add message to the stack and log a debug msg if necessary
6986: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
6987: fnd_msg_pub.add;
6988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6989:
6990: END check_backing_pa_amounts;
6991:
6992:

Line 7156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7152: WHEN OTHERS THEN
7153: --add message to the stack and log a debug msg if necessary
7154: po_message_s.sql_error(g_pkg_name, l_proc_name, l_progress, SQLCODE, SQLERRM);
7155: fnd_msg_pub.add;
7156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7157:
7158: END correct_backing_pa_amounts;
7159:
7160:

Line 7308: WHEN FND_API.G_EXC_ERROR THEN

7304: PO_DEBUG.debug_end(l_log_head);
7305: END IF;
7306:
7307: EXCEPTION
7308: WHEN FND_API.G_EXC_ERROR THEN
7309: RAISE;
7310:
7311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7312: RAISE;

Line 7311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7307: EXCEPTION
7308: WHEN FND_API.G_EXC_ERROR THEN
7309: RAISE;
7310:
7311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7312: RAISE;
7313:
7314: WHEN OTHERS THEN
7315: --add message to the stack and log a debug msg if necessary

Line 7318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7314: WHEN OTHERS THEN
7315: --add message to the stack and log a debug msg if necessary
7316: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
7317: fnd_msg_pub.add;
7318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7319:
7320: END set_complex_work_req_amounts;
7321:
7322:

Line 7485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7481: WHEN OTHERS THEN
7482: --add message to the stack and log a debug msg if necessary
7483: po_message_s.sql_error(g_pkg_name, l_proc_name, l_progress, SQLCODE, SQLERRM);
7484: fnd_msg_pub.add;
7485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7486: END correct_backing_req_amounts;
7487: --
7488:
7489:

Line 7875: WHEN FND_API.G_EXC_ERROR THEN

7871: PO_DEBUG.debug_end(l_log_head);
7872: END IF;
7873:
7874: EXCEPTION
7875: WHEN FND_API.G_EXC_ERROR THEN
7876: RAISE;
7877:
7878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7879: RAISE;

Line 7878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7874: EXCEPTION
7875: WHEN FND_API.G_EXC_ERROR THEN
7876: RAISE;
7877:
7878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7879: RAISE;
7880:
7881: WHEN OTHERS THEN
7882: --add message to the stack and log a debug msg if necessary

Line 7885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7881: WHEN OTHERS THEN
7882: --add message to the stack and log a debug msg if necessary
7883: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
7884: fnd_msg_pub.add;
7885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7886:
7887: END get_gl_references;
7888:
7889:

Line 8209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8205: ELSE
8206: l_progress := '050';
8207: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, '000', 'Invalid Action');
8208: fnd_msg_pub.add;
8209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8210: END IF; -- check on p_action
8211: l_progress:= '060';
8212: --
8213: -- Get functional currency setup

Line 8301: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8297: , p_round_only_flag_tbl => l_round_only_flag_tbl
8298: , x_amount_out_tbl => l_amount_result_tbl
8299: );
8300:
8301: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8302:
8303: PO_DEBUG.debug_stmt(l_log_head,l_progress,'After completing PO_CORE_S2.round_and_convert_currency on distributions');
8304: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status',l_return_status);
8305: l_progress := '090';

Line 8306: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

8302:
8303: PO_DEBUG.debug_stmt(l_log_head,l_progress,'After completing PO_CORE_S2.round_and_convert_currency on distributions');
8304: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status',l_return_status);
8305: l_progress := '090';
8306: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
8307: END IF;
8308:
8309: IF g_debug_stmt THEN
8310: PO_DEBUG.debug_var(l_log_head,l_progress,'l_amount_result_tbl',l_amount_result_tbl);

Line 8363: WHEN FND_API.G_EXC_ERROR THEN

8359: END IF;
8360: End If;
8361:
8362: EXCEPTION
8363: WHEN FND_API.G_EXC_ERROR THEN
8364: RAISE;
8365:
8366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8367: RAISE;

Line 8366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8362: EXCEPTION
8363: WHEN FND_API.G_EXC_ERROR THEN
8364: RAISE;
8365:
8366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8367: RAISE;
8368:
8369: WHEN OTHERS THEN
8370: --add message to the stack and log a debug msg if necessary

Line 8373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8369: WHEN OTHERS THEN
8370: --add message to the stack and log a debug msg if necessary
8371: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
8372: fnd_msg_pub.add;
8373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8374:
8375: END update_amounts;
8376: --
8377:

Line 8563: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8559: p_to_currency_mau_tbl => l_min_acct_unit_func_tbl ,
8560: p_round_only_flag_tbl => l_round_only_flag_tbl ,
8561: x_amount_out_tbl => l_amount_result_tbl );
8562:
8563: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8564: l_progress := '045';
8565: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
8566: END IF;
8567: l_progress := '050';

Line 8565: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;

8561: x_amount_out_tbl => l_amount_result_tbl );
8562:
8563: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8564: l_progress := '045';
8565: RAISE FND_API.g_EXC_UNEXPECTED_ERROR;
8566: END IF;
8567: l_progress := '050';
8568: IF g_debug_stmt THEN
8569: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Rounding of CLM Document Amounts Successful');

Line 8588: WHEN FND_API.G_EXC_ERROR THEN

8584: IF g_debug_stmt THEN
8585: PO_DEBUG.debug_end(l_log_head);
8586: End if;
8587: EXCEPTION
8588: WHEN FND_API.G_EXC_ERROR THEN
8589: RAISE;
8590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8591: RAISE;
8592: WHEN OTHERS THEN

Line 8590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8586: End if;
8587: EXCEPTION
8588: WHEN FND_API.G_EXC_ERROR THEN
8589: RAISE;
8590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8591: RAISE;
8592: WHEN OTHERS THEN
8593: --add message to the stack and log a debug msg if necessary
8594: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);

Line 8596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8592: WHEN OTHERS THEN
8593: --add message to the stack and log a debug msg if necessary
8594: po_message_s.sql_error(g_pkg_name, l_api_name, l_progress, SQLCODE, SQLERRM);
8595: fnd_msg_pub.add;
8596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8597: END UPDATE_CLM_FINAL_AMOUNTS;
8598: /* <> */
8599:
8600: END PO_ENCUMBRANCE_PREPROCESSING;