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.

[Home] [Help]

APPS.PON_CONTERMS_UTL_PVT dependencies on FND_API

Line 53: x_return_status := fnd_api.g_ret_sts_success;

49: into x_auction_header_id
50: from pon_bid_headers
51: where bid_number = p_contracts_doc_id;
52:
53: x_return_status := fnd_api.g_ret_sts_success;
54: exception
55: when others then
56: x_return_status := fnd_api.g_ret_sts_error;
57: x_msg_data := 'Bad Bid Number ' || p_contracts_doc_id;

Line 56: x_return_status := fnd_api.g_ret_sts_error;

52:
53: x_return_status := fnd_api.g_ret_sts_success;
54: exception
55: when others then
56: x_return_status := fnd_api.g_ret_sts_error;
57: x_msg_data := 'Bad Bid Number ' || p_contracts_doc_id;
58: x_msg_count := 1;
59: end;
60: else

Line 61: x_return_status := fnd_api.g_ret_sts_error;

57: x_msg_data := 'Bad Bid Number ' || p_contracts_doc_id;
58: x_msg_count := 1;
59: end;
60: else
61: x_return_status := fnd_api.g_ret_sts_error;
62: x_msg_data := 'Unknown doctype ' || p_contracts_doctype;
63: x_msg_count := 1;
64: end if;
65:

Line 67: x_return_status := fnd_api.g_ret_sts_success;

63: x_msg_count := 1;
64: end if;
65:
66: -- success!
67: x_return_status := fnd_api.g_ret_sts_success;
68: END get_auction_header_id;
69:
70:
71: FUNCTION get_response_doc_type(p_doc_type_id IN NUMBER) RETURN VARCHAR2 IS

Line 121: RETURN FND_API.G_TRUE;

117:
118: -- read the global variable that stores the profile option.
119:
120: IF (g_contracts_installed_flag = 'Y') THEN
121: RETURN FND_API.G_TRUE;
122: ELSE
123: RETURN FND_API.G_FALSE;
124: END IF;
125:

Line 123: RETURN FND_API.G_FALSE;

119:
120: IF (g_contracts_installed_flag = 'Y') THEN
121: RETURN FND_API.G_TRUE;
122: ELSE
123: RETURN FND_API.G_FALSE;
124: END IF;
125:
126: EXCEPTION
127: WHEN OTHERS THEN

Line 279: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

275:
276: l_api_name CONSTANT VARCHAR2(30) := 'activateDeliverables';
277: l_api_version CONSTANT NUMBER := 1.0;
278:
279: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
280: l_doc_type_id NUMBER;
281: l_bus_doc_type VARCHAR2(30) ;
282: l_open_date DATE;
283: l_close_date DATE;

Line 306: x_result := FND_API.g_ret_sts_success;

302:
303:
304: BEGIN
305:
306: x_result := FND_API.g_ret_sts_success;
307:
308: select doctype_id, open_bidding_date, close_bidding_date, org_id
309: into l_doc_type_id, l_open_date, l_close_date, l_org_id
310: from pon_auction_headers_all

Line 324: if (is_contracts_installed() = FND_API.G_TRUE) then

320: if (p_old_bid_number <>-1) then
321: select bid_status into l_old_bid_status from pon_bid_headers where bid_number = p_old_bid_number;
322: end if;
323:
324: if (is_contracts_installed() = FND_API.G_TRUE) then
325:
326: begin
327: --{
328: --

Line 344: p_init_msg_list => FND_API.G_FALSE,

340: -- bug 3608706 - new api to update the status history
341:
342: OKC_MANAGE_DELIVERABLES_GRP.postDelStatusChanges (
343: p_api_version => 1.0,
344: p_init_msg_list => FND_API.G_FALSE,
345: p_commit => FND_API.G_FALSE,
346: p_bus_doc_id => p_new_bid_number,
347: p_bus_doc_type => l_bus_doc_type,
348: p_bus_doc_version => -99,

Line 345: p_commit => FND_API.G_FALSE,

341:
342: OKC_MANAGE_DELIVERABLES_GRP.postDelStatusChanges (
343: p_api_version => 1.0,
344: p_init_msg_list => FND_API.G_FALSE,
345: p_commit => FND_API.G_FALSE,
346: p_bus_doc_id => p_new_bid_number,
347: p_bus_doc_type => l_bus_doc_type,
348: p_bus_doc_version => -99,
349: x_msg_data => l_msg_data,

Line 366: p_init_msg_list => FND_API.G_FALSE,

362: -- activate deliverables for the new bid
363:
364: OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables (
365: p_api_version => 1.0,
366: p_init_msg_list => FND_API.G_FALSE,
367: p_commit => FND_API.G_FALSE,
368: p_bus_doc_id => p_new_bid_number,
369: p_bus_doc_type => l_bus_doc_type,
370: p_bus_doc_version => -99,

Line 367: p_commit => FND_API.G_FALSE,

363:
364: OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables (
365: p_api_version => 1.0,
366: p_init_msg_list => FND_API.G_FALSE,
367: p_commit => FND_API.G_FALSE,
368: p_bus_doc_id => p_new_bid_number,
369: p_bus_doc_type => l_bus_doc_type,
370: p_bus_doc_version => -99,
371: p_event_code => PON_CONTERMS_UTL_PVT.RESPONSE_RECEIVED,

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

376: x_return_status => l_return_status);
377:
378: -- keep logging
379:
380: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
381: x_result := FND_API.G_RET_STS_ERROR;
382: x_error_code := '20001';
383: x_error_message := 'ACTIVATE_FAILED';
384:

Line 381: x_result := FND_API.G_RET_STS_ERROR;

377:
378: -- keep logging
379:
380: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
381: x_result := FND_API.G_RET_STS_ERROR;
382: x_error_code := '20001';
383: x_error_message := 'ACTIVATE_FAILED';
384:
385: IF (g_fnd_debug = 'Y') THEN

Line 393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

389: module => g_module_prefix || l_api_name,
390: message => l_msg_data);
391: END IF;
392: END IF;
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: END IF;
395:
396: OKC_MANAGE_DELIVERABLES_GRP.enableNotifications(
397: p_api_version => 1.0,

Line 398: p_init_msg_list => FND_API.G_FALSE,

394: END IF;
395:
396: OKC_MANAGE_DELIVERABLES_GRP.enableNotifications(
397: p_api_version => 1.0,
398: p_init_msg_list => FND_API.G_FALSE,
399: p_commit => FND_API.G_FALSE,
400: p_bus_doc_id => p_new_bid_number,
401: p_bus_doc_type => l_bus_doc_type,
402: p_bus_doc_version => -99,

Line 399: p_commit => FND_API.G_FALSE,

395:
396: OKC_MANAGE_DELIVERABLES_GRP.enableNotifications(
397: p_api_version => 1.0,
398: p_init_msg_list => FND_API.G_FALSE,
399: p_commit => FND_API.G_FALSE,
400: p_bus_doc_id => p_new_bid_number,
401: p_bus_doc_type => l_bus_doc_type,
402: p_bus_doc_version => -99,
403: x_msg_data => l_msg_data,

Line 407: IF (l_return_status < FND_API.G_RET_STS_SUCCESS) THEN

403: x_msg_data => l_msg_data,
404: x_msg_count => l_msg_count,
405: x_return_status => l_return_status);
406:
407: IF (l_return_status < FND_API.G_RET_STS_SUCCESS) THEN
408: x_result := FND_API.G_RET_STS_ERROR;
409: x_error_code := '20002';
410: x_error_message := 'ENABLE_NOTIF_FAILED';
411:

Line 408: x_result := FND_API.G_RET_STS_ERROR;

404: x_msg_count => l_msg_count,
405: x_return_status => l_return_status);
406:
407: IF (l_return_status < FND_API.G_RET_STS_SUCCESS) THEN
408: x_result := FND_API.G_RET_STS_ERROR;
409: x_error_code := '20002';
410: x_error_message := 'ENABLE_NOTIF_FAILED';
411:
412: IF (g_fnd_debug = 'Y') THEN

Line 431: p_init_msg_list => FND_API.G_FALSE,

427: IF (p_old_bid_number <>-1 AND l_new_bid_status = 'ACTIVE') THEN
428:
429: OKC_MANAGE_DELIVERABLES_GRP.cancelDeliverables (
430: p_api_version => 1.0,
431: p_init_msg_list => FND_API.G_FALSE,
432: p_commit => FND_API.G_FALSE,
433: p_bus_doc_id => p_old_bid_number,
434: p_bus_doc_type => l_bus_doc_type,
435: p_bus_doc_version => -99,

Line 432: p_commit => FND_API.G_FALSE,

428:
429: OKC_MANAGE_DELIVERABLES_GRP.cancelDeliverables (
430: p_api_version => 1.0,
431: p_init_msg_list => FND_API.G_FALSE,
432: p_commit => FND_API.G_FALSE,
433: p_bus_doc_id => p_old_bid_number,
434: p_bus_doc_type => l_bus_doc_type,
435: p_bus_doc_version => -99,
436: x_msg_data => l_msg_data,

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

436: x_msg_data => l_msg_data,
437: x_msg_count => l_msg_count,
438: x_return_status => l_return_status);
439:
440: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
441:
442: x_result := FND_API.G_RET_STS_ERROR;
443: x_error_code := '20003';
444: x_error_message := 'CANCEL_DELIV_FAILED';

Line 442: x_result := FND_API.G_RET_STS_ERROR;

438: x_return_status => l_return_status);
439:
440: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
441:
442: x_result := FND_API.G_RET_STS_ERROR;
443: x_error_code := '20003';
444: x_error_message := 'CANCEL_DELIV_FAILED';
445:
446: IF (g_fnd_debug = 'Y') THEN

Line 457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

453: END IF;
454:
455: END IF;
456:
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458:
459: END IF; -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
460:
461: END IF; -- if (p_old_bid_number <>-1 AND l_new_bid_status = 'ACTIVE')

Line 459: END IF; -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

455: END IF;
456:
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458:
459: END IF; -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
460:
461: END IF; -- if (p_old_bid_number <>-1 AND l_new_bid_status = 'ACTIVE')
462: --}
463: exception

Line 543: if (is_contracts_installed() = FND_API.G_TRUE) then

539:
540:
541: BEGIN
542:
543: if (is_contracts_installed() = FND_API.G_TRUE) then
544:
545: BEGIN
546:
547: -- get the contract doc type depending on p_doc_type_id

Line 581: p_init_msg_list => FND_API.G_FALSE,

577: -- Call Contracts API for updating negotiation first
578:
579: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables(
580: p_api_version => 1.0,
581: p_init_msg_list => FND_API.G_FALSE,
582: p_commit => FND_API.G_FALSE,
583: p_bus_doc_id => p_auction_header_id,
584: p_bus_doc_type => l_negotiation_doc_type,
585: p_bus_doc_version => -99,

Line 582: p_commit => FND_API.G_FALSE,

578:
579: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables(
580: p_api_version => 1.0,
581: p_init_msg_list => FND_API.G_FALSE,
582: p_commit => FND_API.G_FALSE,
583: p_bus_doc_id => p_auction_header_id,
584: p_bus_doc_type => l_negotiation_doc_type,
585: p_bus_doc_version => -99,
586: p_bus_doc_date_events_tbl => l_bus_doc_dates_tbl,

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

588: x_msg_count => x_msg_count,
589: x_return_status => l_return_status
590: );
591:
592: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
593: IF (g_fnd_debug = 'Y') THEN
594: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
595: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
596: module => g_module_prefix || l_api_name,

Line 612: p_init_msg_list => FND_API.G_FALSE,

608: IF (current_amendment.auction_header_id <> p_auction_header_id) THEN
609:
610: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables(
611: p_api_version => 1.0,
612: p_init_msg_list => FND_API.G_FALSE,
613: p_commit => FND_API.G_FALSE,
614: p_bus_doc_id => current_amendment.auction_header_id,
615: p_bus_doc_type => l_negotiation_doc_type,
616: p_bus_doc_version => -99,

Line 613: p_commit => FND_API.G_FALSE,

609:
610: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables(
611: p_api_version => 1.0,
612: p_init_msg_list => FND_API.G_FALSE,
613: p_commit => FND_API.G_FALSE,
614: p_bus_doc_id => current_amendment.auction_header_id,
615: p_bus_doc_type => l_negotiation_doc_type,
616: p_bus_doc_version => -99,
617: p_bus_doc_date_events_tbl => l_bus_doc_dates_tbl,

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

619: x_msg_count => x_msg_count,
620: x_return_status => l_return_status
621: );
622:
623: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
624: IF (g_fnd_debug = 'Y') THEN
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
626: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
627: module => g_module_prefix || l_api_name,

Line 646: p_init_msg_list => FND_API.G_FALSE,

642: FOR active_bid IN active_bids LOOP
643:
644: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables(
645: p_api_version => 1.0,
646: p_init_msg_list => FND_API.G_FALSE,
647: p_commit => FND_API.G_FALSE,
648: p_bus_doc_id => active_bid.bid_number,
649: p_bus_doc_type => l_response_doc_type,
650: p_bus_doc_version => -99,

Line 647: p_commit => FND_API.G_FALSE,

643:
644: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables(
645: p_api_version => 1.0,
646: p_init_msg_list => FND_API.G_FALSE,
647: p_commit => FND_API.G_FALSE,
648: p_bus_doc_id => active_bid.bid_number,
649: p_bus_doc_type => l_response_doc_type,
650: p_bus_doc_version => -99,
651: p_bus_doc_date_events_tbl => l_bus_doc_dates_tbl,

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

652: x_msg_data => l_msg_data,
653: x_msg_count => x_msg_count,
654: x_return_status => l_return_status
655: );
656: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
657: IF (g_fnd_debug = 'Y') THEN
658: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
659: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
660: module => g_module_prefix || l_api_name,

Line 734: if (is_contracts_installed() = FND_API.G_TRUE) then

730: from pon_auction_headers_all
731: where auction_header_id=p_auction_header_id;
732: end if;
733:
734: if (is_contracts_installed() = FND_API.G_TRUE) then
735:
736: BEGIN
737:
738: select org_id

Line 761: p_init_msg_list => FND_API.G_FALSE,

757:
758: -- Call Contracts API for cancelling negotiation 's delvierablesfirst
759: OKC_MANAGE_DELIVERABLES_GRP.cancelDeliverables(
760: p_api_version => 1.0,
761: p_init_msg_list => FND_API.G_FALSE,
762: p_commit => FND_API.G_FALSE,
763: p_bus_doc_id => p_auction_header_id,
764: p_bus_doc_type => l_negotiation_doc_type,
765: p_bus_doc_version => -99,

Line 762: p_commit => FND_API.G_FALSE,

758: -- Call Contracts API for cancelling negotiation 's delvierablesfirst
759: OKC_MANAGE_DELIVERABLES_GRP.cancelDeliverables(
760: p_api_version => 1.0,
761: p_init_msg_list => FND_API.G_FALSE,
762: p_commit => FND_API.G_FALSE,
763: p_bus_doc_id => p_auction_header_id,
764: p_bus_doc_type => l_negotiation_doc_type,
765: p_bus_doc_version => -99,
766: x_msg_data => l_msg_data,

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

768: x_return_status => l_return_status
769: );
770:
771:
772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
773: IF (g_fnd_debug = 'Y') THEN
774: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
775: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
776: module => g_module_prefix || l_api_name,

Line 785: p_init_msg_list => FND_API.G_FALSE,

781: -- Call Contracts API for cancel Active Bids' deliverables
782: FOR active_bid IN active_bids LOOP
783: OKC_MANAGE_DELIVERABLES_GRP.cancelDeliverables(
784: p_api_version => 1.0,
785: p_init_msg_list => FND_API.G_FALSE,
786: p_commit => FND_API.G_FALSE,
787: p_bus_doc_id => active_bid.bid_number,
788: p_bus_doc_type => l_response_doc_type,
789: p_bus_doc_version => -99,

Line 786: p_commit => FND_API.G_FALSE,

782: FOR active_bid IN active_bids LOOP
783: OKC_MANAGE_DELIVERABLES_GRP.cancelDeliverables(
784: p_api_version => 1.0,
785: p_init_msg_list => FND_API.G_FALSE,
786: p_commit => FND_API.G_FALSE,
787: p_bus_doc_id => active_bid.bid_number,
788: p_bus_doc_type => l_response_doc_type,
789: p_bus_doc_version => -99,
790: x_msg_data => l_msg_data,

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

791: x_msg_count => x_msg_count,
792: x_return_status => l_return_status
793: );
794:
795: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
796: IF (g_fnd_debug = 'Y') THEN
797: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
798: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
799: module => g_module_prefix || l_api_name,

Line 860: if (is_contracts_installed() = FND_API.G_TRUE) then

856: l_org_id NUMBER;
857:
858: BEGIN
859:
860: if (is_contracts_installed() = FND_API.G_TRUE) then
861:
862: BEGIN
863:
864: -- get the contract doc type depending on p_doc_type_id

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

887: x_msg_data => l_msg_data,
888: x_msg_count => x_msg_count,
889: x_return_status => l_return_status
890: );
891: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
892: IF (g_fnd_debug = 'Y') THEN
893: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
894: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
895: module => g_module_prefix || l_api_name,

Line 962: if (is_contracts_installed() = FND_API.G_TRUE) then

958: indx PLS_INTEGER := 0;
959:
960: BEGIN
961:
962: if (is_contracts_installed() = FND_API.G_TRUE) then
963:
964: BEGIN
965:
966: SELECT doctype_id, view_by_Date, open_bidding_date, close_bidding_date, org_id

Line 996: p_init_msg_list => FND_API.G_FALSE,

992: mo_global.set_policy_context('S', l_org_id);
993:
994: OKC_MANAGE_DELIVERABLES_GRP.resolveDeliverables(
995: p_api_version => 1.0,
996: p_init_msg_list => FND_API.G_FALSE,
997: p_commit => FND_API.G_FALSE,
998: p_bus_doc_id => p_auction_header_id,
999: p_bus_doc_type => l_negotiation_doc_type,
1000: p_bus_doc_version => -99,

Line 997: p_commit => FND_API.G_FALSE,

993:
994: OKC_MANAGE_DELIVERABLES_GRP.resolveDeliverables(
995: p_api_version => 1.0,
996: p_init_msg_list => FND_API.G_FALSE,
997: p_commit => FND_API.G_FALSE,
998: p_bus_doc_id => p_auction_header_id,
999: p_bus_doc_type => l_negotiation_doc_type,
1000: p_bus_doc_version => -99,
1001: p_event_code => l_event_name,

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

1005: x_msg_count => x_msg_count,
1006: x_return_status => x_return_status
1007: );
1008:
1009: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1010: IF (g_fnd_debug = 'Y') THEN
1011: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1012: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1013: module => g_module_prefix || l_api_name,

Line 1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1013: module => g_module_prefix || l_api_name,
1014: message => l_msg_data);
1015: END IF;
1016: END IF;
1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1018: END IF;
1019:
1020: --
1021: -- Set the org context back

Line 1053: l_init_msg_list Varchar2(1) := FND_API.G_FALSE ;

1049:
1050: IS
1051:
1052: l_api_version Number := 1.0;
1053: l_init_msg_list Varchar2(1) := FND_API.G_FALSE ;
1054: l_commit Varchar2(1) := FND_API.G_FALSE;
1055:
1056: l_source_doc_type Varchar2(30) := 'AUCTION_RESPONSE'; -- need to get the correct doc type
1057: l_source_doc_id Number := p_source_bid_number;

Line 1054: l_commit Varchar2(1) := FND_API.G_FALSE;

1050: IS
1051:
1052: l_api_version Number := 1.0;
1053: l_init_msg_list Varchar2(1) := FND_API.G_FALSE ;
1054: l_commit Varchar2(1) := FND_API.G_FALSE;
1055:
1056: l_source_doc_type Varchar2(30) := 'AUCTION_RESPONSE'; -- need to get the correct doc type
1057: l_source_doc_id Number := p_source_bid_number;
1058:

Line 1122: p_init_msg_list => FND_API.G_FALSE , --l_init_msg_list ,

1118: mo_global.set_policy_context('S', l_org_id);
1119:
1120: OKC_TERMS_COPY_GRP.COPY_RESPONSE_DOC(
1121: p_api_version => 1.0 , --l_api_version ,
1122: p_init_msg_list => FND_API.G_FALSE , --l_init_msg_list ,
1123: p_commit => FND_API.G_FALSE , --l_commit ,
1124: p_source_doc_type => l_source_doc_type ,
1125: p_source_doc_id => l_source_doc_id ,
1126: p_target_doc_type => l_target_doc_type ,

Line 1123: p_commit => FND_API.G_FALSE , --l_commit ,

1119:
1120: OKC_TERMS_COPY_GRP.COPY_RESPONSE_DOC(
1121: p_api_version => 1.0 , --l_api_version ,
1122: p_init_msg_list => FND_API.G_FALSE , --l_init_msg_list ,
1123: p_commit => FND_API.G_FALSE , --l_commit ,
1124: p_source_doc_type => l_source_doc_type ,
1125: p_source_doc_id => l_source_doc_id ,
1126: p_target_doc_type => l_target_doc_type ,
1127: p_target_doc_id => l_target_doc_id ,

Line 1187: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

1183: l_api_version NUMBER := 1.0;
1184: l_api_name CONSTANT VARCHAR2(30) := 'disqualifyDeliverables';
1185: l_bus_doc_id NUMBER;
1186: l_doc_type_id NUMBER;
1187: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1188: l_bus_doc_type VARCHAR2(30);
1189:
1190: l_event_name VARCHAR2(30) := PON_CONTERMS_UTL_PVT.RESPONSE_RECEIVED;
1191: l_event_date DATE := sysdate;

Line 1203: l_commit VARCHAR2(1) := FND_API.G_FALSE;

1199:
1200: l_msg_data VARCHAR2(250);
1201: l_msg_count NUMBER;
1202: l_return_status VARCHAR2(1);
1203: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1204:
1205: BEGIN
1206:
1207: select b.doctype_id ,

Line 1218: if (is_contracts_installed() = FND_API.G_TRUE) then

1214: and a.auction_header_id = b.auction_header_id;
1215:
1216: l_bus_doc_type := get_response_doc_type(l_doc_type_id);
1217:
1218: if (is_contracts_installed() = FND_API.G_TRUE) then
1219:
1220: begin
1221: -- note that we do not need to cancel all the deliverabls
1222: -- for all the archived bids that will get 'disqualified'

Line 1241: p_init_msg_list => FND_API.G_FALSE,

1237: mo_global.set_policy_context('S', l_org_id);
1238:
1239: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables (
1240: p_api_version => 1.0,
1241: p_init_msg_list => FND_API.G_FALSE,
1242: p_commit => FND_API.G_FALSE,
1243: p_bus_doc_id => p_bid_number,
1244: p_bus_doc_type => l_bus_doc_type,
1245: p_bus_doc_version => -99,

Line 1242: p_commit => FND_API.G_FALSE,

1238:
1239: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables (
1240: p_api_version => 1.0,
1241: p_init_msg_list => FND_API.G_FALSE,
1242: p_commit => FND_API.G_FALSE,
1243: p_bus_doc_id => p_bid_number,
1244: p_bus_doc_type => l_bus_doc_type,
1245: p_bus_doc_version => -99,
1246: x_msg_data => l_msg_data,

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

1246: x_msg_data => l_msg_data,
1247: x_msg_count => l_msg_count,
1248: x_return_status => l_return_status);
1249:
1250: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1251: IF (g_fnd_debug = 'Y') THEN
1252: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1253: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1254: module => g_module_prefix || l_api_name,

Line 1294: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

1290: IS
1291: l_api_version NUMBER := 1.0;
1292: l_bus_doc_id NUMBER;
1293:
1294: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
1295:
1296: -- multi-org related changes
1297: l_old_org_id NUMBER;
1298: l_old_policy VARCHAR2(2);

Line 1305: l_commit VARCHAR2(1) := FND_API.G_FALSE;

1301: -- out parameters for the contracts apis
1302: l_msg_data VARCHAR2(250);
1303: l_msg_count NUMBER;
1304: l_return_status VARCHAR2(1);
1305: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1306: l_response_doc_type VARCHAR2(30);
1307: l_api_name CONSTANT VARCHAR2(30) :='disableDeliverables';
1308:
1309: CURSOR active_bids IS

Line 1318: if (is_contracts_installed() = FND_API.G_TRUE) then

1314:
1315: BEGIN
1316:
1317: l_response_doc_type := get_response_doc_type(p_doc_type_id);
1318: if (is_contracts_installed() = FND_API.G_TRUE) then
1319:
1320: begin
1321:
1322: select org_id

Line 1342: p_init_msg_list => FND_API.G_FALSE,

1338: FOR active_bid IN active_bids LOOP
1339:
1340: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables(
1341: p_api_version => 1.0,
1342: p_init_msg_list => FND_API.G_FALSE,
1343: p_commit => FND_API.G_FALSE,
1344: p_bus_doc_id => active_bid.bid_number,
1345: p_bus_doc_type => l_response_doc_type,
1346: p_bus_doc_version => -99,

Line 1343: p_commit => FND_API.G_FALSE,

1339:
1340: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables(
1341: p_api_version => 1.0,
1342: p_init_msg_list => FND_API.G_FALSE,
1343: p_commit => FND_API.G_FALSE,
1344: p_bus_doc_id => active_bid.bid_number,
1345: p_bus_doc_type => l_response_doc_type,
1346: p_bus_doc_version => -99,
1347: x_msg_data => l_msg_data,

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

1347: x_msg_data => l_msg_data,
1348: x_msg_count => l_msg_count,
1349: x_return_status => l_return_status)
1350: ;
1351: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1352: IF (g_fnd_debug = 'Y') THEN
1353: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN
1354: FND_LOG.string(log_level => FND_LOG.LEVEL_PROCEDURE ,
1355: module => g_module_prefix || l_api_name,

Line 1409: if(l_return_status <> fnd_api.g_ret_sts_success) then

1405: BEGIN
1406:
1407: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);
1408:
1409: if(l_return_status <> fnd_api.g_ret_sts_success) then
1410: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1411: fnd_log.string( fnd_log.level_statement,
1412: 'pon_conterms_utl_pvt',
1413: 'contract_terms_exist() failed for doc_id=' || p_doc_id || ', msg_data=' || l_msg_data

Line 1473: if(l_return_status <> fnd_api.g_ret_sts_success) then

1469: BEGIN
1470:
1471: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);
1472:
1473: if(l_return_status <> fnd_api.g_ret_sts_success) then
1474: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1475: fnd_log.string( fnd_log.level_statement,
1476: 'pon_conterms_utl_pvt',
1477: 'contract_deliverables_exist() failed for doc_id=' || p_doc_id || ', msg_data=' || l_msg_data

Line 1514: if(l_return_status <> fnd_api.g_ret_sts_success) then

1510: BEGIN
1511:
1512: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);
1513:
1514: if(l_return_status <> fnd_api.g_ret_sts_success) then
1515: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1516: fnd_log.string( fnd_log.level_statement,
1517: 'pon_conterms_utl_pvt',
1518: 'contract_terms_or_del_exist() failed for doc_id=' || p_doc_id || ', msg_data=' || l_msg_data

Line 1592: p_init_msg_list => fnd_api.g_false,

1588: mo_global.set_policy_context('S', l_org_id);
1589:
1590: resultout := okc_terms_util_grp.is_article_exist(
1591: p_api_version => 1.0,
1592: p_init_msg_list => fnd_api.g_false,
1593: x_return_status => v_return_status,
1594: x_msg_data => v_msg_data,
1595: x_msg_count => v_msg_count,
1596: p_doc_type => pon_conterms_utl_grp.get_contracts_document_type(v_doc_id, 'N'),

Line 1599: if (v_return_status <> fnd_api.g_ret_sts_success) then

1595: x_msg_count => v_msg_count,
1596: p_doc_type => pon_conterms_utl_grp.get_contracts_document_type(v_doc_id, 'N'),
1597: p_doc_id => v_doc_id);
1598:
1599: if (v_return_status <> fnd_api.g_ret_sts_success) then
1600: resultout := null;
1601:
1602: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1603: fnd_log.string(fnd_log.level_statement,

Line 1666: p_init_msg_list => fnd_api.g_false,

1662: mo_global.set_policy_context('S', l_org_id);
1663:
1664: resultout := okc_terms_util_grp.is_article_amended(
1665: p_api_version => 1.0,
1666: p_init_msg_list => fnd_api.g_false,
1667: x_return_status => v_return_status,
1668: x_msg_data => v_msg_data,
1669: x_msg_count => v_msg_count,
1670: p_doc_type => pon_conterms_utl_grp.get_contracts_document_type(v_doc_id, 'N'),

Line 1673: if (v_return_status <> fnd_api.g_ret_sts_success) then

1669: x_msg_count => v_msg_count,
1670: p_doc_type => pon_conterms_utl_grp.get_contracts_document_type(v_doc_id, 'N'),
1671: p_doc_id => v_doc_id);
1672:
1673: if (v_return_status <> fnd_api.g_ret_sts_success) then
1674: resultout := null;
1675:
1676: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1677: fnd_log.string(fnd_log.level_statement,

Line 1745: p_init_msg_list => fnd_api.g_false,

1741: mo_global.set_policy_context('S', l_org_id);
1742:
1743: resultout := okc_terms_util_grp.is_deliverable_amended(
1744: p_api_version => 1.0,
1745: p_init_msg_list => fnd_api.g_false,
1746: x_return_status => v_return_status,
1747: x_msg_data => v_msg_data,
1748: x_msg_count => v_msg_count,
1749: p_doc_type => pon_conterms_utl_grp.get_contracts_document_type(v_doc_id, 'N'),

Line 1752: if (v_return_status <> fnd_api.g_ret_sts_success) then

1748: x_msg_count => v_msg_count,
1749: p_doc_type => pon_conterms_utl_grp.get_contracts_document_type(v_doc_id, 'N'),
1750: p_doc_id => v_doc_id);
1751:
1752: if (v_return_status <> fnd_api.g_ret_sts_success) then
1753: resultout := null;
1754:
1755: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1756: fnd_log.string(fnd_log.level_statement,

Line 1820: p_init_msg_list => fnd_api.g_false,

1816:
1817:
1818: resultout := okc_terms_util_grp.is_template_expired(
1819: p_api_version => 1.0,
1820: p_init_msg_list => fnd_api.g_false,
1821: x_return_status => v_return_status,
1822: x_msg_data => v_msg_data,
1823: x_msg_count => v_msg_count,
1824: p_doc_type => pon_conterms_utl_grp.get_contracts_document_type(v_doc_id, 'N'),

Line 1827: if (v_return_status <> fnd_api.g_ret_sts_success) then

1823: x_msg_count => v_msg_count,
1824: p_doc_type => pon_conterms_utl_grp.get_contracts_document_type(v_doc_id, 'N'),
1825: p_doc_id => v_doc_id);
1826:
1827: if (v_return_status <> fnd_api.g_ret_sts_success) then
1828: resultout := null;
1829:
1830: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1831: fnd_log.string(fnd_log.level_statement,

Line 1895: p_init_msg_list => fnd_api.g_false,

1891: mo_global.set_policy_context('S', l_org_id);
1892:
1893: resultout := okc_terms_util_grp.deviation_from_standard(
1894: p_api_version => 1.0,
1895: p_init_msg_list => fnd_api.g_false,
1896: x_return_status => v_return_status,
1897: x_msg_data => v_msg_data,
1898: x_msg_count => v_msg_count,
1899: p_doc_type => pon_conterms_utl_grp.get_contracts_document_type(v_doc_id, 'N'),

Line 1902: if (v_return_status <> fnd_api.g_ret_sts_success) then

1898: x_msg_count => v_msg_count,
1899: p_doc_type => pon_conterms_utl_grp.get_contracts_document_type(v_doc_id, 'N'),
1900: p_doc_id => v_doc_id);
1901:
1902: if (v_return_status <> fnd_api.g_ret_sts_success) then
1903: resultout := null;
1904:
1905: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1906: fnd_log.string(fnd_log.level_statement,

Line 1970: p_init_msg_list => fnd_api.g_false,

1966: mo_global.set_policy_context('S', l_org_id);
1967:
1968: resultout := okc_terms_util_grp.is_deliverable_exist(
1969: p_api_version => 1.0,
1970: p_init_msg_list => fnd_api.g_false,
1971: x_return_status => v_return_status,
1972: x_msg_data => v_msg_data,
1973: x_msg_count => v_msg_count,
1974: p_doc_type => pon_conterms_utl_grp.get_contracts_document_type(v_doc_id, 'N'),

Line 1977: if (v_return_status <> fnd_api.g_ret_sts_success) then

1973: x_msg_count => v_msg_count,
1974: p_doc_type => pon_conterms_utl_grp.get_contracts_document_type(v_doc_id, 'N'),
1975: p_doc_id => v_doc_id);
1976:
1977: if (v_return_status <> fnd_api.g_ret_sts_success) then
1978: resultout := null;
1979:
1980: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
1981: fnd_log.string(fnd_log.level_statement,

Line 2014: IF (is_contracts_installed() = FND_API.G_TRUE) THEN --{

2010: l_old_policy VARCHAR2(2);
2011:
2012: BEGIN
2013:
2014: IF (is_contracts_installed() = FND_API.G_TRUE) THEN --{
2015:
2016: BEGIN
2017: --{
2018:

Line 2032: p_init_msg_list => FND_API.G_TRUE,

2028: mo_global.set_policy_context('M', null);
2029:
2030: OKC_MANAGE_DELIVERABLES_GRP.updateExtPartyOnDeliverables
2031: ( p_api_version => 1.0,
2032: p_init_msg_list => FND_API.G_TRUE,
2033: p_commit => FND_API.G_FALSE,
2034: p_document_class => 'SOURCING',
2035: p_from_external_party_id => p_from_vendor_id,
2036: p_from_external_party_site_id => p_from_site_id,

Line 2033: p_commit => FND_API.G_FALSE,

2029:
2030: OKC_MANAGE_DELIVERABLES_GRP.updateExtPartyOnDeliverables
2031: ( p_api_version => 1.0,
2032: p_init_msg_list => FND_API.G_TRUE,
2033: p_commit => FND_API.G_FALSE,
2034: p_document_class => 'SOURCING',
2035: p_from_external_party_id => p_from_vendor_id,
2036: p_from_external_party_site_id => p_from_site_id,
2037: p_to_external_party_id => p_to_vendor_id,

Line 2051: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN --{

2047: mo_global.set_policy_context(l_old_policy, l_old_org_id);
2048:
2049: -- keep logging
2050:
2051: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN --{
2052:
2053: IF (g_fnd_debug = 'Y') THEN --{
2054:
2055: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.g_current_runtime_level) THEN

Line 2067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2063: || ' p_to_external_party_site_id=' || p_to_site_id);
2064: END IF;
2065:
2066: END IF; --}
2067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2068: END IF; --}
2069: END;--}
2070: END IF;--}
2071: EXCEPTION

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

2135: x_msg_count => l_msg_count,
2136: x_return_status => l_return_status);
2137:
2138:
2139: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2140:
2141: x_result := FND_API.G_RET_STS_ERROR;
2142: x_error_code := 'UPDATE_DELIV_AMEND_FAILED';
2143: x_error_message := 'Unable to update deliverables for auction ' || p_auction_header_id_orig;

Line 2141: x_result := FND_API.G_RET_STS_ERROR;

2137:
2138:
2139: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2140:
2141: x_result := FND_API.G_RET_STS_ERROR;
2142: x_error_code := 'UPDATE_DELIV_AMEND_FAILED';
2143: x_error_message := 'Unable to update deliverables for auction ' || p_auction_header_id_orig;
2144:
2145: IF (g_fnd_debug = 'Y') THEN

Line 2152: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2148: module => g_module_prefix || l_api_name,
2149: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2150: END IF;
2151: END IF;
2152: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2153: END IF;
2154: END IF;
2155:
2156: -- finally call disabledeliverables on the previous amendment

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

2160: x_msg_data => l_msg_data,
2161: x_msg_count => l_msg_count,
2162: x_return_status => l_return_status);
2163:
2164: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2165:
2166: x_result := FND_API.G_RET_STS_ERROR;
2167: x_error_code := 'DISABLE_DELIV_AMEND_FAILED';
2168: x_error_message := 'Unable to disable deliverables for auction ' || p_auction_header_id_prev;

Line 2166: x_result := FND_API.G_RET_STS_ERROR;

2162: x_return_status => l_return_status);
2163:
2164: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2165:
2166: x_result := FND_API.G_RET_STS_ERROR;
2167: x_error_code := 'DISABLE_DELIV_AMEND_FAILED';
2168: x_error_message := 'Unable to disable deliverables for auction ' || p_auction_header_id_prev;
2169:
2170: IF (g_fnd_debug = 'Y') THEN

Line 2177: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2173: module => g_module_prefix || l_api_name,
2174: message => l_msg_data || ' ' || x_error_code || ' ' || x_error_message);
2175: END IF;
2176: END IF;
2177: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2178: END IF;
2179:
2180:
2181: EXCEPTION

Line 2185: x_result := FND_API.G_RET_STS_ERROR;

2181: EXCEPTION
2182:
2183: WHEN OTHERS THEN
2184:
2185: x_result := FND_API.G_RET_STS_ERROR;
2186: x_error_code := 'UPDATE_DELIV_AMEND_FAILED_COMPLETELY - ' || SQLCODE;
2187: x_error_message := 'Unable to do anything with deliverables for auction ' || p_auction_header_id_prev || ' ' || SUBSTR(SQLERRM, 1, 100);
2188:
2189: IF (g_fnd_debug = 'Y') THEN