DBA Data[Home] [Help]

APPS.PO_MOD_CONTROL_PVT dependencies on FND_API

Line 25: resultout := FND_API.G_RET_STS_SUCCESS;

21: d_position := 0;
22: IF (PO_LOG.d_proc) THEN
23: PO_LOG.proc_begin(d_module);
24: END IF;
25: resultout := FND_API.G_RET_STS_SUCCESS;
26:
27: d_position := 10;
28:
29: -- Call PO_DRAFTS_PVT.remove_draft_changes to remove all draft entries

Line 31: p_exclude_ctrl_tbl => FND_API.G_TRUE,

27: d_position := 10;
28:
29: -- Call PO_DRAFTS_PVT.remove_draft_changes to remove all draft entries
30: PO_DRAFTS_PVT.remove_draft_changes(p_draft_id => p_draft_id,
31: p_exclude_ctrl_tbl => FND_API.G_TRUE,
32: x_return_status => resultout);
33:
34: d_position := 20;
35: IF resultout = FND_API.G_RET_STS_SUCCESS THEN

Line 35: IF resultout = FND_API.G_RET_STS_SUCCESS THEN

31: p_exclude_ctrl_tbl => FND_API.G_TRUE,
32: x_return_status => resultout);
33:
34: d_position := 20;
35: IF resultout = FND_API.G_RET_STS_SUCCESS THEN
36: -- If return status success, then call PO_HEADERS_DRAFT_PKG.sync_draft_from_txn
37: d_position := 30;
38: l_po_header_id_tbl.extend(1);
39: l_po_draft_id_tbl.extend(1);

Line 59: resultout := FND_API.G_RET_STS_SUCCESS;

55: set control_action = p_action
56: where draft_id = p_draft_id;
57:
58: d_position := 60;
59: resultout := FND_API.G_RET_STS_SUCCESS;
60:
61: IF (PO_LOG.d_proc) THEN
62: PO_LOG.proc_end(d_module);
63: END IF;

Line 72: resultout := FND_API.G_RET_STS_UNEXP_ERROR;

68: ( p_pkg_name => d_pkg_name,
69: p_procedure_name => d_api_name || '.' || d_position
70: );
71:
72: resultout := FND_API.G_RET_STS_UNEXP_ERROR;
73:
74: end process_mod_control_action;
75:
76:

Line 110: result := FND_API.G_RET_STS_SUCCESS;

106: d_position := 0;
107: IF (PO_LOG.d_proc) THEN
108: PO_LOG.proc_begin(d_module);
109: END IF;
110: result := FND_API.G_RET_STS_SUCCESS;
111:
112: d_position := 10;
113: PO_DRAFTS_PVT.update_draft_status(p_draft_id,status);
114:

Line 258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

254: END IF;
255:
256: EXCEPTION
257: WHEN OTHERS THEN
258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
259:
260: END process_mod_withdrawn_action;
261:
262: /*===========================================================================

Line 350: result := FND_API.G_RET_STS_SUCCESS;

346: IF (PO_LOG.d_proc) THEN
347: PO_LOG.proc_begin(d_module);
348: END IF;
349:
350: result := FND_API.G_RET_STS_SUCCESS;
351:
352: d_position := 10;
353:
354: -- delete data from po_entity_locks table while deleting mod

Line 427: , p_init_msg_list => FND_API.G_TRUE

423: WHERE draft_id = p_draft_id;
424:
425: OKC_TERMS_UTIL_GRP.delete_doc
426: ( p_api_version => 1.0
427: , p_init_msg_list => FND_API.G_TRUE
428: , p_commit => FND_API.G_FALSE
429: , p_doc_id => p_draft_id
430: , p_doc_type => l_contract_document_type
431: , p_validate_commit => FND_API.G_FALSE

Line 428: , p_commit => FND_API.G_FALSE

424:
425: OKC_TERMS_UTIL_GRP.delete_doc
426: ( p_api_version => 1.0
427: , p_init_msg_list => FND_API.G_TRUE
428: , p_commit => FND_API.G_FALSE
429: , p_doc_id => p_draft_id
430: , p_doc_type => l_contract_document_type
431: , p_validate_commit => FND_API.G_FALSE
432: , p_release_locks_yn => 'Y'

Line 431: , p_validate_commit => FND_API.G_FALSE

427: , p_init_msg_list => FND_API.G_TRUE
428: , p_commit => FND_API.G_FALSE
429: , p_doc_id => p_draft_id
430: , p_doc_type => l_contract_document_type
431: , p_validate_commit => FND_API.G_FALSE
432: , p_release_locks_yn => 'Y'
433: , x_return_status => l_return_status
434: , x_msg_data => l_msg_data
435: , x_msg_count => l_msg_count

Line 508: p_commit => fnd_api.g_false,

504: p_document_rec.business_document_type := l_okc_doc_type;
505: p_document_rec.business_document_id := p_draft_id;
506:
507: OKC_REP_CONTRACT_IMP_PUB.delete_cancel_contract(p_api_version => '1.0',
508: p_commit => fnd_api.g_false,
509: p_document_rec => p_document_rec,
510: p_contract_type => 'REP_SBCR',
511: p_contract_id => null,
512: x_msg_data => l_msg_data ,

Line 518: PO_DRAFTS_PVT.remove_draft_changes(p_draft_id,FND_API.G_FALSE,result);

514: x_return_status => l_return_status);
515:
516: -- SBCR Integration Code to Delete associated SBCR Records END.
517:
518: PO_DRAFTS_PVT.remove_draft_changes(p_draft_id,FND_API.G_FALSE,result);
519:
520: IF (PO_LOG.d_proc) THEN
521: PO_LOG.proc_end(d_module);
522: END IF;

Line 526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

522: END IF;
523:
524: EXCEPTION
525: WHEN OTHERS THEN
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527:
528: END process_mod_delete_action;
529:
530:

Line 663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

659:
660: EXCEPTION
661:
662: WHEN OTHERS THEN
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664:
665: END delete_uda_data;
666:
667:

Line 691: resultout := FND_API.G_RET_STS_SUCCESS;

687: d_position := 0;
688: IF (PO_LOG.d_proc) THEN
689: PO_LOG.proc_begin(d_module);
690: END IF;
691: resultout := FND_API.G_RET_STS_SUCCESS;
692:
693: d_position := 10;
694:
695:

Line 738: IF resultout = FND_API.G_RET_STS_SUCCESS THEN

734: p_price_adjustment_id => NULL
735: );
736:
737:
738: IF resultout = FND_API.G_RET_STS_SUCCESS THEN
739: -- If return status success, then call PO_HEADERS_DRAFT_PKG.sync_draft_from_txn
740: d_position := 80;
741: l_po_line_id_tbl.extend(1);
742: l_po_draft_id_tbl.extend(1);

Line 764: resultout := FND_API.G_RET_STS_SUCCESS;

760: set control_action = p_action
761: where draft_id = p_draft_id;
762:
763: d_position := 60;
764: resultout := FND_API.G_RET_STS_SUCCESS;
765:
766: IF (PO_LOG.d_proc) THEN
767: PO_LOG.proc_end(d_module);
768: END IF;

Line 777: resultout := FND_API.G_RET_STS_UNEXP_ERROR;

773: ( p_pkg_name => d_pkg_name,
774: p_procedure_name => d_api_name || '.' || d_position
775: );
776:
777: resultout := FND_API.G_RET_STS_UNEXP_ERROR;
778:
779: end do_mod_line_control_action;
780:
781: -- The procedure 'do_mod_line_loc_control_action' performing the control actions

Line 804: resultout := FND_API.G_RET_STS_SUCCESS;

800: d_position := 0;
801: IF (PO_LOG.d_proc) THEN
802: PO_LOG.proc_begin(d_module);
803: END IF;
804: resultout := FND_API.G_RET_STS_SUCCESS;
805:
806: d_position := 10;
807:
808: PO_LINE_LOCATIONS_DRAFT_PKG.delete_rows

Line 814: IF resultout = FND_API.G_RET_STS_SUCCESS THEN

810: p_line_location_id => p_po_line_loc_id
811: );
812:
813: d_position := 20;
814: IF resultout = FND_API.G_RET_STS_SUCCESS THEN
815: -- If return status success, then call PO_HEADERS_DRAFT_PKG.sync_draft_from_txn
816: d_position := 30;
817: l_po_line_loc_id_tbl.extend(1);
818: l_po_draft_id_tbl.extend(1);

Line 838: resultout := FND_API.G_RET_STS_SUCCESS;

834: set control_action = p_action
835: where draft_id = p_draft_id;
836:
837: d_position := 60;
838: resultout := FND_API.G_RET_STS_SUCCESS;
839:
840: IF (PO_LOG.d_proc) THEN
841: PO_LOG.proc_end(d_module);
842: END IF;

Line 851: resultout := FND_API.G_RET_STS_UNEXP_ERROR;

847: ( p_pkg_name => d_pkg_name,
848: p_procedure_name => d_api_name || '.' || d_position
849: );
850:
851: resultout := FND_API.G_RET_STS_UNEXP_ERROR;
852:
853: end do_mod_line_loc_control_action;
854:
855: ------------------------------------------------------------------------------

Line 896: x_return_status := FND_API.g_ret_sts_success;

892: PO_LOG.proc_begin(d_module,'p_doc_level_id',p_doc_level_id);
893: END IF;
894:
895: --Initialisation of local variables
896: x_return_status := FND_API.g_ret_sts_success;
897: l_cons_trans_exist := 'N';
898: l_index := 1;
899: l_mode := UPPER(p_mode);
900: x_valid_ctrl_ctn_tbl := PO_TBL_VARCHAR30();

Line 968: IF (x_return_status = FND_API.g_ret_sts_success)then

964: PO_LOG.stmt(d_module,d_pos,'x_return_status',x_return_status);
965: END IF;
966: d_pos := 60;
967:
968: IF (x_return_status = FND_API.g_ret_sts_success)then
969:
970: IF p_doc_level IN (PO_CORE_S.g_doc_level_HEADER, PO_CORE_S.g_doc_level_LINE) THEN
971: -- Checks if there exists a consumption transaction that is in process for
972: -- the passed in transaction source document ID and and item ID.

Line 1070: ELSIF (x_return_status = FND_API.g_ret_sts_error)then

1066: END IF; --l_mode = 'UPDATE'
1067: END IF; -- l_cons_trans_exist = 'Y'
1068: END LOOP;
1069:
1070: ELSIF (x_return_status = FND_API.g_ret_sts_error)then
1071: d_pos := 120;
1072: IF (PO_LOG.d_stmt) THEN
1073: PO_LOG.stmt(d_module,d_pos,'No Valid Control Action Found');
1074: END IF;

Line 1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1073: PO_LOG.stmt(d_module,d_pos,'No Valid Control Action Found');
1074: END IF;
1075: ELSE
1076: d_pos := 130;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF; --x_return_status = FND_API.g_ret_sts_success
1079: IF (PO_LOG.d_proc) THEN
1080: PO_LOG.proc_end(d_module);
1081: END IF;

Line 1078: END IF; --x_return_status = FND_API.g_ret_sts_success

1074: END IF;
1075: ELSE
1076: d_pos := 130;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END IF; --x_return_status = FND_API.g_ret_sts_success
1079: IF (PO_LOG.d_proc) THEN
1080: PO_LOG.proc_end(d_module);
1081: END IF;
1082: EXCEPTION

Line 1084: x_return_status := FND_API.g_ret_sts_unexp_error;

1080: PO_LOG.proc_end(d_module);
1081: END IF;
1082: EXCEPTION
1083: WHEN OTHERS THEN
1084: x_return_status := FND_API.g_ret_sts_unexp_error;
1085: FND_MSG_PUB.add_exc_msg(d_pkg_name, l_api_name||':'||d_pos);
1086: IF PO_LOG.d_exc THEN
1087: PO_LOG.exc(d_module,d_pos,'Unhandled Exception in' || d_module);
1088: END IF;

Line 1227: IF (l_ret_sts <> FND_API.g_ret_sts_success)

1223: , x_online_report_id => l_enc_report_id
1224: );
1225:
1226:
1227: IF (l_ret_sts <> FND_API.g_ret_sts_success)
1228: THEN
1229:
1230: d_position := 50;
1231: x_return_status := fnd_api.G_RET_STS_ERROR;

Line 1231: x_return_status := fnd_api.G_RET_STS_ERROR;

1227: IF (l_ret_sts <> FND_API.g_ret_sts_success)
1228: THEN
1229:
1230: d_position := 50;
1231: x_return_status := fnd_api.G_RET_STS_ERROR;
1232: x_return_mssg := 'do_return not successful';
1233: RAISE PO_CORE_S.g_early_return_exc;
1234:
1235: END IF;

Line 1255: x_return_status := fnd_api.G_RET_STS_ERROR;

1251: ELSIF (l_enc_ret_code = PO_DOCUMENT_FUNDS_PVT.g_return_PARTIAL)
1252: THEN
1253:
1254: d_position := 80;
1255: x_return_status := fnd_api.G_RET_STS_ERROR;
1256: x_return_mssg := 'funds do_return partial';
1257: RAISE PO_CORE_S.g_early_return_exc;
1258:
1259: ELSIF (l_enc_ret_code = PO_DOCUMENT_FUNDS_PVT.g_return_FAILURE)

Line 1263: x_return_status := fnd_api.G_RET_STS_ERROR;

1259: ELSIF (l_enc_ret_code = PO_DOCUMENT_FUNDS_PVT.g_return_FAILURE)
1260: THEN
1261:
1262: d_position := 90;
1263: x_return_status := fnd_api.G_RET_STS_ERROR;
1264: x_return_mssg := 'funds do_return failure';
1265:
1266: RAISE PO_CORE_S.g_early_return_exc;
1267:

Line 1273: x_return_status := fnd_api.G_RET_STS_ERROR;

1269: ELSIF (l_enc_ret_code = PO_DOCUMENT_FUNDS_PVT.g_return_FATAL)
1270: THEN
1271:
1272: d_position := 100;
1273: x_return_status := fnd_api.G_RET_STS_ERROR;
1274: x_return_mssg := 'funds do_return fatal';
1275: RAISE PO_CORE_S.g_early_return_exc;
1276:
1277: ELSE

Line 1280: x_return_status := fnd_api.G_RET_STS_ERROR;

1276:
1277: ELSE
1278:
1279: d_position := 110;
1280: x_return_status := fnd_api.G_RET_STS_ERROR;
1281: x_return_mssg := 'Bad return code from funds do_return';
1282: RAISE PO_CORE_S.g_early_return_exc;
1283:
1284: END IF;

Line 1426: x_return_status := fnd_api.g_ret_sts_success;

1422: END;
1423:
1424: d_position := 190;
1425:
1426: x_return_status := fnd_api.g_ret_sts_success;
1427:
1428: IF ( po_log.d_proc ) THEN
1429: po_log.Proc_end(d_module);
1430: END IF;

Line 1446: x_return_status := fnd_api.G_RET_STS_ERROR;

1442:
1443: IF PO_LOG.d_exc THEN
1444: PO_LOG.exc(d_module, d_position, 'Exception occurred ' || SQLERRM);
1445: END IF;
1446: x_return_status := fnd_api.G_RET_STS_ERROR;
1447: x_return_mssg := SQLERRM;
1448:
1449: ROLLBACK TO WITHDRAW_ACTION_SP;
1450: