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 1014: p_init_msg_list => FND_API.G_FALSE,

1010: -- previous revision has conterms in the first place as this is possible
1011: -- now with migrate PO
1012: PO_CONTERMS_UTL_GRP.Get_Last_Signed_Revision(
1013: p_api_version => 1.0,
1014: p_init_msg_list => FND_API.G_FALSE,
1015: p_header_id => p_po_header_id,
1016: p_revision_num => l_po_revision_num,
1017: x_signed_revision_num => l_last_signed_revision,
1018: x_signed_records => l_signed_records,

Line 1071: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

1067: MESSAGE =>'170: return status'||x_return_status);
1068: END IF;
1069:
1070: END IF;
1071: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
1072: RAISE l_Contracts_call_exception;
1073: END IF; -- Return status from contracts
1074:
1075: --For bug 13123360

Line 1120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then

1116: MESSAGE =>'200: return status '||x_return_status);
1117: END IF;
1118:
1119: END IF;
1120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS then
1121: RAISE l_Contracts_call_exception;
1122: END IF; -- Return status from contracts
1123:
1124:

Line 1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1167: END LOOP;
1168:
1169: END IF;
1170: WHEN OTHERS THEN
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg

Line 1308: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

1304: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1305: x_return_status => l_return_status,
1306: x_msg_data => l_msg_data,
1307: x_msg_count => l_msg_count);
1308: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1309:
1310: IF (g_po_wf_debug = 'Y') THEN
1311: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1312: '100: returned value from Contracts'||result);

Line 1457: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

1453: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1454: x_return_status => l_return_status,
1455: x_msg_data => l_msg_data,
1456: x_msg_count => l_msg_count);
1457: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1458:
1459: IF (g_po_wf_debug = 'Y') THEN
1460: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1461: '100: returned value from Contracts'||result);

Line 1608: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

1604: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1605: x_return_status => l_return_status,
1606: x_msg_data => l_msg_data,
1607: x_msg_count => l_msg_count);
1608: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1609:
1610: IF (g_po_wf_debug = 'Y') THEN
1611: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1612: '100: returned value from Contracts'||result);

Line 1760: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

1756: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1757: x_return_status => l_return_status,
1758: x_msg_data => l_msg_data,
1759: x_msg_count => l_msg_count);
1760: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1761:
1762: IF (g_po_wf_debug = 'Y') THEN
1763: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1764: '100: returned value from Contracts'||result);

Line 1915: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

1911: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
1912: x_return_status => l_return_status,
1913: x_msg_data => l_msg_data,
1914: x_msg_count => l_msg_count);
1915: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1916: IF (result = 'CONTRACTUAL_AND_INTERNAL') THEN
1917: result := 'ALL';
1918: END IF;
1919: IF (g_po_wf_debug = 'Y') THEN

Line 2071: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

2067: p_doc_type => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
2068: x_return_status => l_return_status,
2069: x_msg_data => l_msg_data,
2070: x_msg_count => l_msg_count);
2071: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
2072: IF (result = 'CONTRACTUAL_AND_INTERNAL') THEN
2073: result := 'ALL';
2074: END IF;
2075: IF (g_po_wf_debug = 'Y') THEN

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

2170: -- is a table of dates based events on the PO to resolve deliverables
2171: -- that are based on PO dates (ex. Start date).
2172: --OUT:
2173: --x_return_status
2174: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected/other error
2175: -- FND_API.G_RET_STS_SUCCESS - for successful execution of the API
2176: --Testing:
2177: --
2178: --Notes:

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

2171: -- that are based on PO dates (ex. Start date).
2172: --OUT:
2173: --x_return_status
2174: -- FND_API.G_RET_STS_UNEXP_ERROR - for unexpected/other error
2175: -- FND_API.G_RET_STS_SUCCESS - for successful execution of the API
2176: --Testing:
2177: --
2178: --Notes:
2179: -- This procedure should be called when it is needed to cancel deliverables

Line 2206: x_return_status := FND_API.G_RET_STS_SUCCESS;

2202: l_return_status VARCHAR2(1);
2203:
2204: BEGIN
2205: -- initialize return status
2206: x_return_status := FND_API.G_RET_STS_SUCCESS;
2207:
2208:
2209: -- select the business document version if passed null
2210: IF (p_bus_doc_version IS NULL) THEN

Line 2235: ,p_init_msg_list => FND_API.G_FALSE

2231:
2232: -- call to the actual API
2233: OKC_MANAGE_DELIVERABLES_GRP.cancelDeliverables(
2234: p_api_version => 1.0
2235: ,p_init_msg_list => FND_API.G_FALSE
2236: ,p_commit => FND_API.G_FALSE
2237: ,p_bus_doc_id => p_bus_doc_id
2238: ,p_bus_doc_type => l_contracts_document_type
2239: ,p_bus_doc_version => l_bus_doc_version

Line 2236: ,p_commit => FND_API.G_FALSE

2232: -- call to the actual API
2233: OKC_MANAGE_DELIVERABLES_GRP.cancelDeliverables(
2234: p_api_version => 1.0
2235: ,p_init_msg_list => FND_API.G_FALSE
2236: ,p_commit => FND_API.G_FALSE
2237: ,p_bus_doc_id => p_bus_doc_id
2238: ,p_bus_doc_type => l_contracts_document_type
2239: ,p_bus_doc_version => l_bus_doc_version
2240: ,p_event_code => p_event_code

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

2243: ,x_msg_data => l_msg_data
2244: ,x_msg_count => l_msg_count
2245: ,x_return_status => l_return_status);
2246:
2247: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: END IF;
2250:
2251: IF (g_fnd_debug = 'Y') THEN

Line 2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2244: ,x_msg_count => l_msg_count
2245: ,x_return_status => l_return_status);
2246:
2247: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: END IF;
2250:
2251: IF (g_fnd_debug = 'Y') THEN
2252: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 2260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2256: END IF;
2257: END IF;
2258:
2259: EXCEPTION
2260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2261: IF (g_fnd_debug = 'Y') THEN
2262: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2263: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE
2264: ,module => g_module_prefix || l_api_name

Line 2268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2264: ,module => g_module_prefix || l_api_name
2265: ,message => l_msg_data);
2266: END IF;
2267: END IF;
2268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2269: WHEN OTHERS THEN
2270: ROLLBACK;
2271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2272: IF (g_fnd_debug = 'Y') THEN

Line 2271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2267: END IF;
2268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2269: WHEN OTHERS THEN
2270: ROLLBACK;
2271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2272: IF (g_fnd_debug = 'Y') THEN
2273: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
2274: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE
2275: ,module => g_module_prefix || l_api_name