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_MOD_SYNC_PROCESS_PVT dependencies on FND_API

Line 564: x_return_status := FND_API.G_RET_STS_SUCCESS;

560:
561: BEGIN
562: log_debug('sync_with_award_process : start '||
563: 'DocType '||p_document_type||' DraftId '||p_draft_id);
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565: if p_document_type = 'PO' then
566: --Sync action is only for the PO
567: --validate attributes
568: if p_draft_id = -1 then

Line 907: x_return_status := FND_API.G_RET_STS_ERROR;

903: log_debug('sync_with_award_process : '||
904: 'Validations result: '||l_result_type);
905:
906: IF l_result_type <> po_validations.c_result_type_success THEN
907: x_return_status := FND_API.G_RET_STS_ERROR;
908: get_errors(l_results, x_results);
909: if p_reject_if_error = 'Y' then
910: system_reject_mod(p_draft_id, x_return_status);
911: if x_return_status = FND_API.G_RET_STS_SUCCESS

Line 911: if x_return_status = FND_API.G_RET_STS_SUCCESS

907: x_return_status := FND_API.G_RET_STS_ERROR;
908: get_errors(l_results, x_results);
909: if p_reject_if_error = 'Y' then
910: system_reject_mod(p_draft_id, x_return_status);
911: if x_return_status = FND_API.G_RET_STS_SUCCESS
912: then
913: -- reseting the status to original
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: end if;

Line 914: x_return_status := FND_API.G_RET_STS_ERROR;

910: system_reject_mod(p_draft_id, x_return_status);
911: if x_return_status = FND_API.G_RET_STS_SUCCESS
912: then
913: -- reseting the status to original
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: end if;
916: end if;
917: return;
918: END IF;

Line 950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

946: end if;
947:
948: EXCEPTION
949: when others then
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
951: log_debug('sync_with_award_process : '||
952: 'At exception'||substr(sqlerrm,1200));
953: END;
954:

Line 992: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

988: l_po_header_id NUMBER;
989: l_document_type_code VARCHAR2(500);
990: l_document_style_id NUMBER;
991: l_enabled_flag VARCHAR2(5);
992: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
993: BEGIN
994:
995: d_position := 0;
996: IF (PO_LOG.d_proc) THEN

Line 1030: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1026: IF PO_LOG.d_stmt THEN
1027: PO_LOG.stmt(d_module,d_position,'After Check_Uda_Enabled with x_return_status : ' || l_return_status);
1028: END IF;
1029:
1030: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1032: END IF;
1033:
1034: -- update header

Line 1031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1027: PO_LOG.stmt(d_module,d_position,'After Check_Uda_Enabled with x_return_status : ' || l_return_status);
1028: END IF;
1029:
1030: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1032: END IF;
1033:
1034: -- update header
1035: sync_headers( p_draft_id => p_draft_id

Line 1088: x_return_status := FND_API.G_RET_STS_SUCCESS;

1084: d_position := 80;
1085: IF (PO_LOG.d_proc) THEN
1086: PO_LOG.proc_end(d_module);
1087: END IF;
1088: x_return_status := FND_API.G_RET_STS_SUCCESS;
1089:
1090: EXCEPTION
1091: WHEN OTHERS THEN
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1088: x_return_status := FND_API.G_RET_STS_SUCCESS;
1089:
1090: EXCEPTION
1091: WHEN OTHERS THEN
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: IF (PO_LOG.d_exc) THEN
1094: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
1095: END IF;
1096: RAISE;

Line 1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1502: END IF;
1503:
1504: EXCEPTION
1505: WHEN OTHERS THEN
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: IF (PO_LOG.d_exc) THEN
1508: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
1509: END IF;
1510: RAISE;

Line 1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1948: END IF;
1949:
1950: EXCEPTION
1951: WHEN others THEN
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: IF (PO_LOG.d_exc) THEN
1954: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
1955: END IF;
1956: RAISE;

Line 2174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2170: END IF;
2171:
2172: EXCEPTION
2173: WHEN others THEN
2174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2175: IF (PO_LOG.d_exc) THEN
2176: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
2177: END IF;
2178: RAISE;

Line 2370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2366: END IF;
2367:
2368: EXCEPTION
2369: WHEN others THEN
2370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2371: IF (PO_LOG.d_exc) THEN
2372: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
2373: END IF;
2374: RAISE;

Line 3238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3234: END IF;
3235:
3236: EXCEPTION
3237: WHEN others THEN
3238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3239: IF (PO_LOG.d_exc) THEN
3240: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
3241: END IF;
3242: RAISE;

Line 4066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4062: END IF;
4063:
4064: EXCEPTION
4065: WHEN others THEN
4066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4067: IF (PO_LOG.d_exc) THEN
4068: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
4069: END IF;
4070: RAISE;

Line 4422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4418: END IF;
4419:
4420: EXCEPTION
4421: WHEN others THEN
4422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4423: IF (PO_LOG.d_exc) THEN
4424: PO_LOG.exc(d_module,d_position,SQLCODE || SQLERRM);
4425: END IF;
4426: RAISE;

Line 4726: -- FND_API.G_RET_STS_SUCCESS if API is successful

4722: --IN OUT:
4723: --OUT:
4724: --x_return_status
4725: -- Return status of the API.
4726: -- FND_API.G_RET_STS_SUCCESS if API is successful
4727: -- FND_API.G_RET_STS_ERR if there are user errors
4728: -- FND_API.G_RET_STS_UNEXP_ERR if unexpected error (exception) occurs
4729: --End of Comments
4730: ------------------------------------------------------------------------

Line 4727: -- FND_API.G_RET_STS_ERR if there are user errors

4723: --OUT:
4724: --x_return_status
4725: -- Return status of the API.
4726: -- FND_API.G_RET_STS_SUCCESS if API is successful
4727: -- FND_API.G_RET_STS_ERR if there are user errors
4728: -- FND_API.G_RET_STS_UNEXP_ERR if unexpected error (exception) occurs
4729: --End of Comments
4730: ------------------------------------------------------------------------
4731: procedure sync_with_award_wf(itemtype in varchar2,

Line 4728: -- FND_API.G_RET_STS_UNEXP_ERR if unexpected error (exception) occurs

4724: --x_return_status
4725: -- Return status of the API.
4726: -- FND_API.G_RET_STS_SUCCESS if API is successful
4727: -- FND_API.G_RET_STS_ERR if there are user errors
4728: -- FND_API.G_RET_STS_UNEXP_ERR if unexpected error (exception) occurs
4729: --End of Comments
4730: ------------------------------------------------------------------------
4731: procedure sync_with_award_wf(itemtype in varchar2,
4732: itemkey in varchar2,

Line 4804: IF l_return_status_mod = FND_API.G_RET_STS_SUCCESS THEN

4800: l_draftid,
4801: l_return_status_mod
4802: );
4803:
4804: IF l_return_status_mod = FND_API.G_RET_STS_SUCCESS THEN
4805: --
4806: -- Sync OKC data only if revision number has changed on the base document
4807: SELECT revision_num
4808: INTO l_base_rev_num

Line 4830: l_return_status_mod := FND_API.G_RET_STS_SUCCESS;

4826: END IF;
4827: END IF;
4828:
4829: ELSE
4830: l_return_status_mod := FND_API.G_RET_STS_SUCCESS;
4831: END IF;
4832:
4833: IF l_return_status = FND_API.G_RET_STS_SUCCESS
4834: AND l_return_status_mod = FND_API.G_RET_STS_SUCCESS THEN

Line 4833: IF l_return_status = FND_API.G_RET_STS_SUCCESS

4829: ELSE
4830: l_return_status_mod := FND_API.G_RET_STS_SUCCESS;
4831: END IF;
4832:
4833: IF l_return_status = FND_API.G_RET_STS_SUCCESS
4834: AND l_return_status_mod = FND_API.G_RET_STS_SUCCESS THEN
4835: resultout:='COMPLETE:'||'SUCCESS';
4836:
4837: --commit the code upto this point,because po_drafts table is getting updated

Line 4834: AND l_return_status_mod = FND_API.G_RET_STS_SUCCESS THEN

4830: l_return_status_mod := FND_API.G_RET_STS_SUCCESS;
4831: END IF;
4832:
4833: IF l_return_status = FND_API.G_RET_STS_SUCCESS
4834: AND l_return_status_mod = FND_API.G_RET_STS_SUCCESS THEN
4835: resultout:='COMPLETE:'||'SUCCESS';
4836:
4837: --commit the code upto this point,because po_drafts table is getting updated
4838: --for the row corresponding to draft_id=p_draft_id

Line 4882: -- FND_API.G_RET_STS_SUCCESS if API is successful

4878: --IN OUT:
4879: --OUT:
4880: --x_return_status
4881: -- Return status of the API.
4882: -- FND_API.G_RET_STS_SUCCESS if API is successful
4883: -- FND_API.G_RET_STS_ERR if there are user errors
4884: -- FND_API.G_RET_STS_UNEXP_ERR if unexpected error (exception) occurs
4885: --x_results
4886: -- Error messages concatenated.

Line 4883: -- FND_API.G_RET_STS_ERR if there are user errors

4879: --OUT:
4880: --x_return_status
4881: -- Return status of the API.
4882: -- FND_API.G_RET_STS_SUCCESS if API is successful
4883: -- FND_API.G_RET_STS_ERR if there are user errors
4884: -- FND_API.G_RET_STS_UNEXP_ERR if unexpected error (exception) occurs
4885: --x_results
4886: -- Error messages concatenated.
4887: --End of Comments

Line 4884: -- FND_API.G_RET_STS_UNEXP_ERR if unexpected error (exception) occurs

4880: --x_return_status
4881: -- Return status of the API.
4882: -- FND_API.G_RET_STS_SUCCESS if API is successful
4883: -- FND_API.G_RET_STS_ERR if there are user errors
4884: -- FND_API.G_RET_STS_UNEXP_ERR if unexpected error (exception) occurs
4885: --x_results
4886: -- Error messages concatenated.
4887: --End of Comments
4888: ------------------------------------------------------------------------

Line 4912: if x_return_status = FND_API.G_RET_STS_SUCCESS then

4908: log_debug('sync_with_award: End :'||'x_Return_status :'||
4909: x_return_status||
4910: ' x_results '||x_results);
4911:
4912: if x_return_status = FND_API.G_RET_STS_SUCCESS then
4913: sync_mod_updatable_attrs(
4914: p_draft_id,
4915: l_return_status_mod
4916: );

Line 4918: IF l_return_status_mod = FND_API.G_RET_STS_SUCCESS THEN

4914: p_draft_id,
4915: l_return_status_mod
4916: );
4917:
4918: IF l_return_status_mod = FND_API.G_RET_STS_SUCCESS THEN
4919: -- Sync OKC data
4920: PO_CONTERMS_UTL_GRP.copy_conterms_mod(
4921: p_document_id => p_document_id,
4922: p_draft_id => p_draft_id,

Line 4932: if x_return_status = FND_API.G_RET_STS_SUCCESS then

4928:
4929: x_return_status := l_return_status_mod;
4930: end if;
4931:
4932: if x_return_status = FND_API.G_RET_STS_SUCCESS then
4933: commit;
4934: else
4935: rollback;
4936: end if;