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

Line 240: IF (nvl(l_archive_start_date,FND_API.G_MISS_DATE) <>

236: AND revision_num = (l_po_revision_num-1);
237:
238: -- If start date changed since last revision, then
239: -- send the event code and date to update Deliverables
240: IF (nvl(l_archive_start_date,FND_API.G_MISS_DATE) <>
241: nvl(l_po_start_date,FND_API.G_MISS_DATE)) THEN
242:
243: x_event_tbl(1).event_code := 'PO_START_DATE';
244: x_event_tbl(1).event_date := l_po_start_date;

Line 241: nvl(l_po_start_date,FND_API.G_MISS_DATE)) THEN

237:
238: -- If start date changed since last revision, then
239: -- send the event code and date to update Deliverables
240: IF (nvl(l_archive_start_date,FND_API.G_MISS_DATE) <>
241: nvl(l_po_start_date,FND_API.G_MISS_DATE)) THEN
242:
243: x_event_tbl(1).event_code := 'PO_START_DATE';
244: x_event_tbl(1).event_date := l_po_start_date;
245: END IF;

Line 248: IF (nvl(l_archive_end_date,FND_API.G_MISS_DATE) <>

244: x_event_tbl(1).event_date := l_po_start_date;
245: END IF;
246: -- If end date changed since last revision, then
247: -- send the event code and date to update Deliverables
248: IF (nvl(l_archive_end_date,FND_API.G_MISS_DATE) <>
249: nvl(l_po_end_date,FND_API.G_MISS_DATE)) THEN
250:
251: x_event_tbl(2).event_code := 'PO_END_DATE';
252: x_event_tbl(2).event_date := l_po_end_date;

Line 249: nvl(l_po_end_date,FND_API.G_MISS_DATE)) THEN

245: END IF;
246: -- If end date changed since last revision, then
247: -- send the event code and date to update Deliverables
248: IF (nvl(l_archive_end_date,FND_API.G_MISS_DATE) <>
249: nvl(l_po_end_date,FND_API.G_MISS_DATE)) THEN
250:
251: x_event_tbl(2).event_code := 'PO_END_DATE';
252: x_event_tbl(2).event_date := l_po_end_date;
253: END IF;

Line 387: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

383:
384: END IF;
385:
386: -- Check l_return_status for CONTRACT_TERMS_AMENDED
387: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
388:
389: -- Check return value from CONTRACT_TERMS_AMENDED
390: IF (l_k_terms_changed = 'NONE') THEN
391: IF (g_po_wf_debug = 'Y') THEN

Line 421: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

417: '150: Return status after call to IS_ARTICLE_AMENDED'||l_return_status);
418:
419: END IF;
420:
421: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
422:
423: IF (l_k_terms_changed = 'NONE') THEN
424: IF (g_po_wf_debug = 'Y') THEN
425: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

Line 448: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

444: '165: Return status after call to Is_Deliverable_Amended'||l_return_status);
445:
446: END IF;
447:
448: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
449: IF (l_k_terms_changed = 'NONE') THEN
450: IF (g_po_wf_debug = 'Y') THEN
451: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
452: '170: K Deliverables changed: N'||l_k_terms_changed);

Line 646: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

642: MODULE =>g_module_prefix||l_api_name,
643: MESSAGE =>'80: After call to OKC_...Get_Last_Update_Date. Status'||x_return_status);
644: END IF;
645: End if;
646: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
647: RAISE l_Contracts_call_exception;
648: END IF; -- Return status from contracts
649: ELSE
650: -- There might be some value in these populated when user clicked the

Line 736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

732: MESSAGE =>'400: End Update_conTerms_dates.In Exception OTHERS');
733: END IF;
734:
735: END IF;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: IF FND_MSG_PUB.Check_Msg_Level
738: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
739: THEN
740: FND_MSG_PUB.Add_Exc_Msg

Line 910: p_sync_flag => FND_API.G_TRUE,

906: p_bus_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
907: p_bus_doc_version => l_po_revision_num,
908: p_event_code => 'PO_SIGNED',
909: p_event_date => p_signed_date,
910: p_sync_flag => FND_API.G_TRUE,
911: p_bus_doc_date_events_tbl => l_event_tbl,
912: x_msg_data => x_msg_data,
913: x_msg_count => x_msg_count,
914: x_return_status => x_return_status);

Line 928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

924: MESSAGE =>'90: return status'||x_return_status);
925: END IF;
926:
927: END IF;
928: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
929: RAISE l_Contracts_call_exception;
930: END IF; -- Return status from contracts
931: IF (l_po_revision_num > 0) then --Reresolution will only happen if revision num is greater than 0
932: -- update resolved deliverables with changed date

Line 988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

984: MESSAGE =>'130: Return Status'|| x_return_status);
985: END IF;
986:
987: END IF;--debug
988: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
989: RAISE l_Contracts_call_exception;
990: END IF; -- Return status from contracts
991: END IF;--l_event_tbl.count>0
992:

Line 1005: p_init_msg_list => FND_API.G_FALSE,

1001: -- previous revision has conterms in the first place as this is possible
1002: -- now with migrate PO
1003: PO_CONTERMS_UTL_GRP.Get_Last_Signed_Revision(
1004: p_api_version => 1.0,
1005: p_init_msg_list => FND_API.G_FALSE,
1006: p_header_id => p_po_header_id,
1007: p_revision_num => l_po_revision_num,
1008: x_signed_revision_num => l_last_signed_revision,
1009: x_signed_records => l_signed_records,

Line 1056: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

1052: MESSAGE =>'170: return status'||x_return_status);
1053: END IF;
1054:
1055: END IF;
1056: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
1057: RAISE l_Contracts_call_exception;
1058: END IF; -- Return status from contracts
1059:
1060: -- Bug 3652222 START

Line 1101: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

1097: MESSAGE =>'200: return status '||x_return_status);
1098: END IF;
1099:
1100: END IF;
1101: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
1102: RAISE l_Contracts_call_exception;
1103: END IF; -- Return status from contracts
1104:
1105:

Line 1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1148: END LOOP;
1149:
1150: END IF;
1151: WHEN OTHERS THEN
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1153: IF FND_MSG_PUB.Check_Msg_Level
1154: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1155: THEN
1156: FND_MSG_PUB.Add_Exc_Msg

Line 1289: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

1285: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1286: x_return_status => l_return_status,
1287: x_msg_data => l_msg_data,
1288: x_msg_count => l_msg_count);
1289: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1290:
1291: IF (g_po_wf_debug = 'Y') THEN
1292: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1293: '100: returned value from Contracts'||result);

Line 1438: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

1434: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1435: x_return_status => l_return_status,
1436: x_msg_data => l_msg_data,
1437: x_msg_count => l_msg_count);
1438: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1439:
1440: IF (g_po_wf_debug = 'Y') THEN
1441: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1442: '100: returned value from Contracts'||result);

Line 1589: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

1585: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1586: x_return_status => l_return_status,
1587: x_msg_data => l_msg_data,
1588: x_msg_count => l_msg_count);
1589: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1590:
1591: IF (g_po_wf_debug = 'Y') THEN
1592: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1593: '100: returned value from Contracts'||result);

Line 1741: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

1737: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1738: x_return_status => l_return_status,
1739: x_msg_data => l_msg_data,
1740: x_msg_count => l_msg_count);
1741: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1742:
1743: IF (g_po_wf_debug = 'Y') THEN
1744: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1745: '100: returned value from Contracts'||result);

Line 1896: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

1892: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1893: x_return_status => l_return_status,
1894: x_msg_data => l_msg_data,
1895: x_msg_count => l_msg_count);
1896: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1897: IF (result = 'CONTRACTUAL_AND_INTERNAL') THEN
1898: result := 'ALL';
1899: END IF;
1900: IF (g_po_wf_debug = 'Y') THEN

Line 2052: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

2048: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
2049: x_return_status => l_return_status,
2050: x_msg_data => l_msg_data,
2051: x_msg_count => l_msg_count);
2052: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
2053: IF (result = 'CONTRACTUAL_AND_INTERNAL') THEN
2054: result := 'ALL';
2055: END IF;
2056: IF (g_po_wf_debug = 'Y') THEN

Line 2155: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected/other error

2151: -- is a table of dates based events on the PO to resolve deliverables
2152: -- that are based on PO dates (ex. Start date).
2153: --OUT:
2154: --x_return_status
2155: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected/other error
2156: -- FND_API.G_RET_STS_SUCCESS - for successful execution of the API
2157: --Testing:
2158: --
2159: --Notes:

Line 2156: -- FND_API.G_RET_STS_SUCCESS - for successful execution of the API

2152: -- that are based on PO dates (ex. Start date).
2153: --OUT:
2154: --x_return_status
2155: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected/other error
2156: -- FND_API.G_RET_STS_SUCCESS - for successful execution of the API
2157: --Testing:
2158: --
2159: --Notes:
2160: -- This procedure should be called when it is needed to cancel deliverables

Line 2187: x_return_status := FND_API.G_RET_STS_SUCCESS;

2183: l_return_status VARCHAR2(1);
2184:
2185: BEGIN
2186: -- initialize return status
2187: x_return_status := FND_API.G_RET_STS_SUCCESS;
2188:
2189:
2190: -- select the business document version if passed null
2191: IF (p_bus_doc_version IS NULL) THEN

Line 2216: ,p_init_msg_list => FND_API.G_FALSE

2212:
2213: -- call to the actual API
2214: OKC_MANAGE_DELIVERABLES_GRP.cancelDeliverables(
2215: p_api_version => 1.0
2216: ,p_init_msg_list => FND_API.G_FALSE
2217: ,p_commit => FND_API.G_FALSE
2218: ,p_bus_doc_id => p_bus_doc_id
2219: ,p_bus_doc_type => l_contracts_document_type
2220: ,p_bus_doc_version => l_bus_doc_version

Line 2217: ,p_commit => FND_API.G_FALSE

2213: -- call to the actual API
2214: OKC_MANAGE_DELIVERABLES_GRP.cancelDeliverables(
2215: p_api_version => 1.0
2216: ,p_init_msg_list => FND_API.G_FALSE
2217: ,p_commit => FND_API.G_FALSE
2218: ,p_bus_doc_id => p_bus_doc_id
2219: ,p_bus_doc_type => l_contracts_document_type
2220: ,p_bus_doc_version => l_bus_doc_version
2221: ,p_event_code => p_event_code

Line 2228: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2224: ,x_msg_data => l_msg_data
2225: ,x_msg_count => l_msg_count
2226: ,x_return_status => l_return_status);
2227:
2228: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2230: END IF;
2231:
2232: IF (g_fnd_debug = 'Y') THEN

Line 2229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2225: ,x_msg_count => l_msg_count
2226: ,x_return_status => l_return_status);
2227:
2228: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2230: END IF;
2231:
2232: IF (g_fnd_debug = 'Y') THEN
2233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 2241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2237: END IF;
2238: END IF;
2239:
2240: EXCEPTION
2241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2242: IF (g_fnd_debug = 'Y') THEN
2243: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2244: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE
2245: ,module => g_module_prefix || l_api_name

Line 2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2245: ,module => g_module_prefix || l_api_name
2246: ,message => l_msg_data);
2247: END IF;
2248: END IF;
2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2250: WHEN OTHERS THEN
2251: ROLLBACK;
2252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2253: IF (g_fnd_debug = 'Y') THEN

Line 2252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2248: END IF;
2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2250: WHEN OTHERS THEN
2251: ROLLBACK;
2252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2253: IF (g_fnd_debug = 'Y') THEN
2254: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2255: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE
2256: ,module => g_module_prefix || l_api_name