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.OKE_AMG_GRP dependencies on FND_API

Line 16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

12:
13: ------------------------------------------------------------------------------
14: -- GLOBAL CONSTANTS
15: ------------------------------------------------------------------------------
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18:
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

13: ------------------------------------------------------------------------------
14: -- GLOBAL CONSTANTS
15: ------------------------------------------------------------------------------
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18:
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

15: ------------------------------------------------------------------------------
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18:
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22:
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_UNEXPECTED_ERROR';

Line 20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18:
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22:
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_UNEXPECTED_ERROR';
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18:
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22:
23: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKE_UNEXPECTED_ERROR';
24: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
25: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 51: raise FND_API.G_EXC_UNEXPECTED_ERROR;

47: open c_get_project_name;
48: fetch c_get_project_name into l_name;
49: If c_get_project_name%notfound then
50: close c_get_project_name;
51: raise FND_API.G_EXC_UNEXPECTED_ERROR;
52: end if;
53: close c_get_project_name;
54: return l_name;
55: end;

Line 68: raise FND_API.G_EXC_UNEXPECTED_ERROR;

64: open c_dlv_name;
65: fetch c_dlv_name into l_name;
66: If c_dlv_name%notfound then
67: close c_dlv_name;
68: raise FND_API.G_EXC_UNEXPECTED_ERROR;
69: end if;
70: close c_dlv_name;
71: return l_name;
72: end;

Line 124: x_return_status := FND_API.G_RET_STS_SUCCESS;

120:
121: l_x varchar2(1);
122: begin
123:
124: x_return_status := FND_API.G_RET_STS_SUCCESS;
125:
126: If p_dlv_short_name is null then
127:
128: oke_api.set_message(p_msg_name => 'OKE_DLV_SHORT_NAME',

Line 133: raise FND_API.G_EXC_ERROR;

129: p_token1 =>'PROJECT_NAME',
130: p_token1_value =>l_project_name,
131: p_token2 =>'DELIVERABLE_NAME',
132: p_token2_value =>l_deliverable_name);
133: raise FND_API.G_EXC_ERROR;
134: end if;
135: If p_item_dlv <>'Y' then
136: p_item_id := Null;
137: p_inventory_org_id := Null;

Line 154: raise FND_API.G_EXC_ERROR;

150: p_token1_value =>l_project_name,
151: p_token2 =>'DELIVERABLE_NAME',
152: p_token2_value =>l_deliverable_name);
153: close c_check_inv;
154: raise FND_API.G_EXC_ERROR;
155: end if;
156: close c_check_inv;
157:
158: If p_item_id is not null then

Line 168: raise FND_API.G_EXC_ERROR;

164: p_token1_value =>l_project_name,
165: p_token2 =>'DELIVERABLE_NAME',
166: p_token2_value =>l_deliverable_name);
167: close c_check_item;
168: raise FND_API.G_EXC_ERROR;
169: end if;
170: close c_check_item;
171: end if;
172:

Line 184: raise FND_API.G_EXC_ERROR;

180: p_token1_value =>l_project_name,
181: p_token2 =>'DELIVERABLE_NAME',
182: p_token2_value =>l_deliverable_name);
183: close c_check_item;
184: raise FND_API.G_EXC_ERROR;
185: end if;
186: close c_check_item;
187: end if;
188: end if;

Line 201: raise FND_API.G_EXC_ERROR;

197: p_token1_value =>l_project_name,
198: p_token2 =>'DELIVERABLE_NAME',
199: p_token2_value =>l_deliverable_name);
200: close c_check_uom;
201: raise FND_API.G_EXC_ERROR;
202: End if;
203: Close c_check_uom;
204: Else
205: oke_api.set_message(p_msg_name =>'OKE_CHECK_UOM_ENTERABLE',

Line 211: raise FND_API.G_EXC_ERROR;

207: p_token1_value =>l_project_name,
208: p_token2 =>'DELIVERABLE_NAME',
209: p_token2_value =>l_deliverable_name);
210:
211: raise FND_API.G_EXC_ERROR;
212: End if;
213: else
214: If p_item_id is not null and p_item_dlv = 'Y' then
215: open c_get_primary_uom(p_item_id);

Line 231: raise FND_API.G_EXC_ERROR;

227: p_token1_value =>l_project_name,
228: p_token2 =>'DELIVERABLE_NAME',
229: p_token2_value =>l_deliverable_name);
230: close c_check_currency;
231: raise FND_API.G_EXC_ERROR;
232: End if;
233: Close c_check_currency;
234: else
235: If p_inventory_org_id is not null then

Line 251: raise FND_API.G_EXC_ERROR;

247: p_token1_value =>l_project_name,
248: p_token2 =>'DELIVERABLE_NAME',
249: p_token2_value =>l_deliverable_name);
250: close c_check_unit_number;
251: raise FND_API.G_EXC_ERROR;
252: End if;
253: Close c_check_unit_number;
254: Else
255: oke_api.set_message(p_msg_name =>'OKE_CHECK_UNIT_NO_ENTERABLE',

Line 261: raise FND_API.G_EXC_ERROR;

257: p_token1_value =>l_project_name,
258: p_token2 =>'DELIVERABLE_NAME',
259: p_token2_value =>l_deliverable_name);
260:
261: raise FND_API.G_EXC_ERROR;
262: end if;
263: end if;
264:
265: EXCEPTION

Line 266: WHEN FND_API.G_EXC_ERROR THEN

262: end if;
263: end if;
264:
265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
267: x_return_status := G_RET_STS_ERROR ;
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
267: x_return_status := G_RET_STS_ERROR ;
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270: x_return_status := G_RET_STS_UNEXP_ERROR ;
271:
272: WHEN OTHERS THEN
273: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 425: x_return_status := FND_API.G_RET_STS_SUCCESS;

421: l_function_currency Varchar2(30);
422: l_currency Varchar2(30);
423:
424: Begin
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426: If p_dlv_action_type=G_REQ then
427: p_demand_schedule := Null;
428: p_volume := Null;
429: p_volume_uom := Null;

Line 454: raise FND_API.G_EXC_ERROR;

450: p_token3 =>'ACTION_NAME',
451: p_token3_value =>l_action_name
452: );
453: Close c_check_currency;
454: raise FND_API.G_EXC_ERROR;
455: end if;
456: Close c_check_currency;
457: end if;
458: -- Check UOM

Line 470: raise FND_API.G_EXC_ERROR;

466: p_token2 =>'DELIVERABLE_NAME',
467: p_token2_value =>l_deliverable_name
468: );
469: Close c_check_uom;
470: raise FND_API.G_EXC_ERROR;
471: end if;
472: Close c_check_uom;
473: end if;
474: -- Check Destinattion Type

Line 486: raise FND_API.G_EXC_ERROR;

482: p_token2_value =>l_deliverable_name,
483: p_token3 =>'ACTION_NAME',
484: p_token3_value =>l_action_name
485: );
486: raise FND_API.G_EXC_ERROR;
487: end if;
488:
489: If p_destination_type_code='INVENTORYE' and p_item_dlv<>'Y' then
490: oke_api.set_message(p_msg_name=>'OKE_INVALID_NONITEM_DEST_TYPE',

Line 498: raise FND_API.G_EXC_ERROR;

494: p_token2_value =>l_deliverable_name,
495: p_token3 =>'ACTION_NAME',
496: p_token3_value =>l_action_name
497: );
498: raise FND_API.G_EXC_ERROR;
499: end if;
500: end if;
501: -- Check Receiving Org
502: If p_ship_to_org_id is not null then

Line 513: raise FND_API.G_EXC_ERROR;

509: p_token2_value =>l_deliverable_name,
510: p_token3 =>'ACTION_NAME',
511: p_token3_value =>l_action_name
512: );
513: raise FND_API.G_EXC_ERROR;
514: end if;
515: Else
516: Open c_check_rec_org;
517: Fetch c_check_rec_org into l_x;

Line 528: raise FND_API.G_EXC_ERROR;

524: p_token3 =>'ACTION_NAME',
525: p_token3_value =>l_action_name
526: );
527: close c_check_rec_org;
528: raise FND_API.G_EXC_ERROR;
529: end if;
530: close c_check_rec_org;
531: end if;
532:

Line 549: raise FND_API.G_EXC_ERROR;

545: p_token3 =>'ACTION_NAME',
546: p_token3_value =>l_action_name
547: );
548: close c_check_rec_loc;
549: raise FND_API.G_EXC_ERROR;
550: end if;
551: close c_check_rec_loc;
552: else
553: oke_api.set_message(p_msg_name =>'OKE_INVALID_RECV_LOC1',

Line 562: raise FND_API.G_EXC_ERROR;

558: p_token3 =>'ACTION_NAME',
559: p_token3_value =>l_action_name
560: );
561: close c_check_rec_loc;
562: raise FND_API.G_EXC_ERROR;
563: end if;
564: end if;
565: -- Check Vendor
566: If p_ship_from_org_id is not null then

Line 579: raise FND_API.G_EXC_ERROR;

575: p_token3 =>'ACTION_NAME',
576: p_token3_value =>l_action_name
577: );
578: close c_check_vendor;
579: raise FND_API.G_EXC_ERROR;
580: end if;
581: close c_check_vendor;
582: end if;
583: -- Check Vendor address

Line 598: raise FND_API.G_EXC_ERROR;

594: p_token3 =>'ACTION_NAME',
595: p_token3_value =>l_action_name
596: );
597: close c_check_vendor_site;
598: raise FND_API.G_EXC_ERROR;
599: end if;
600: close c_check_vendor_site;
601: else
602: oke_api.set_message(p_msg_name =>'OKE_INVALID_VENDOR_SITE1',

Line 610: raise FND_API.G_EXC_ERROR;

606: p_token2_value =>l_deliverable_name,
607: p_token3 =>'ACTION_NAME',
608: p_token3_value =>l_action_name
609: );
610: raise FND_API.G_EXC_ERROR;
611: end if;
612: end if;
613: -- Check Exchange rate type
614: If p_exchange_rate_type is not null then

Line 627: raise FND_API.G_EXC_ERROR;

623: p_token3 =>'ACTION_NAME',
624: p_token3_value =>l_action_name
625: );
626: close c_check_exchange_type;
627: raise FND_API.G_EXC_ERROR;
628: end if;
629: close c_check_exchange_type;
630: end if;
631: -- Check Exchange rate

Line 641: raise FND_API.G_EXC_ERROR;

637: p_token2_value =>l_deliverable_name,
638: p_token3 =>'ACTION_NAME',
639: p_token3_value =>l_action_name
640: );
641: raise FND_API.G_EXC_ERROR;
642: end if;
643: If p_exchange_rate is not null then
644: If p_exchange_rate_type <>'User' then
645: If p_exchange_rate_date is NULL or p_ship_to_org_id is null then

Line 654: raise FND_API.G_EXC_ERROR;

650: p_token2_value =>l_deliverable_name,
651: p_token3 =>'ACTION_NAME',
652: p_token3_value =>l_action_name
653: );
654: raise FND_API.G_EXC_ERROR;
655: end if;
656: l_function_currency := OKE_ACTION_VALIDATIONS_PKG.functional_currency(p_ship_to_org_id);
657: Select nvl(p_currency_code,currency_code) into l_currency
658: from oke_deliverables_b

Line 679: raise FND_API.G_EXC_ERROR;

675: p_token3 =>'ACTION_NAME',
676: p_token3_value =>l_action_name
677: );
678: close c_check_expend_type;
679: raise FND_API.G_EXC_ERROR;
680: end if;
681: close c_check_expend_type;
682: end if;
683: -- Check Expenditure org

Line 697: raise FND_API.G_EXC_ERROR;

693: p_token3 =>'ACTION_NAME',
694: p_token3_value =>l_action_name
695: );
696: close c_check_expend_org;
697: raise FND_API.G_EXC_ERROR;
698: end if;
699: close c_check_expend_org;
700: end if;
701: -- Check Requisition Line type

Line 715: raise FND_API.G_EXC_ERROR;

711: p_token3 =>'ACTION_NAME',
712: p_token3_value =>l_action_name
713: );
714: close c_check_req_type;
715: raise FND_API.G_EXC_ERROR;
716: end if;
717: close c_check_req_type;
718: end if;
719: If p_category_id is not null then

Line 732: raise FND_API.G_EXC_ERROR;

728: p_token3 =>'ACTION_NAME',
729: p_token3_value =>l_action_name
730: );
731: close c_check_category;
732: raise FND_API.G_EXC_ERROR;
733: end if;
734: close c_check_category;
735: --Check for Item Category:
736: end if;

Line 772: raise FND_API.G_EXC_ERROR;

768: p_token2 =>'DELIVERABLE_NAME',
769: p_token2_value =>l_deliverable_name
770: );
771: Close c_check_uom;
772: raise FND_API.G_EXC_ERROR;
773: end if;
774: Close c_check_uom;
775: end if;
776: --Check Demand Schedule

Line 795: raise FND_API.G_EXC_ERROR;

791: p_token3 =>'ACTION_NAME',
792: p_token3_value =>l_action_name
793: );
794: close c_check_demand_schedule;
795: raise FND_API.G_EXC_ERROR;
796: end if;
797: close c_check_demand_schedule;
798: else
799: oke_api.set_message(p_msg_name =>'OKE_INV_ORG_B4_PLAN',

Line 807: raise FND_API.G_EXC_ERROR;

803: p_token2_value =>l_deliverable_name,
804: p_token3 =>'ACTION_NAME',
805: p_token3_value =>l_action_name
806: );
807: raise FND_API.G_EXC_ERROR;
808: end if;
809: end if;
810: --Check Ship From org
811: If p_ship_from_org_id is not null then

Line 824: raise FND_API.G_EXC_ERROR;

820: p_token3 =>'ACTION_NAME',
821: p_token3_value =>l_action_name
822: );
823: close c_check_ship_from;
824: raise FND_API.G_EXC_ERROR;
825: end if;
826: close c_check_ship_from;
827: end if;
828: --Check Ship From loc

Line 843: raise FND_API.G_EXC_ERROR;

839: p_token3 =>'ACTION_NAME',
840: p_token3_value =>l_action_name
841: );
842: close c_check_ship_from_loc;
843: raise FND_API.G_EXC_ERROR;
844: end if;
845: close c_check_ship_from_loc;
846: else
847: oke_api.set_message(p_msg_name =>'OKE_INVALID_SHIP_FROM_LOC1',

Line 855: raise FND_API.G_EXC_ERROR;

851: p_token2_value =>l_deliverable_name,
852: p_token3 =>'ACTION_NAME',
853: p_token3_value =>l_action_name
854: );
855: raise FND_API.G_EXC_ERROR;
856: end if;
857: end if;
858: -- Check Custome Account
859:

Line 873: raise FND_API.G_EXC_ERROR;

869: p_token3 =>'ACTION_NAME',
870: p_token3_value =>l_action_name
871: );
872: close c_check_customer;
873: raise FND_API.G_EXC_ERROR;
874: end if;
875: close c_check_customer;
876: end if;
877: --Check Customer Address

Line 892: raise FND_API.G_EXC_ERROR;

888: p_token3 =>'ACTION_NAME',
889: p_token3_value =>l_action_name
890: );
891: close c_check_cust_add;
892: raise FND_API.G_EXC_ERROR;
893: end if;
894: close c_check_cust_add;
895: else
896: oke_api.set_message(p_msg_name =>'OKE_INVALID_CUST_ADD1',

Line 904: raise FND_API.G_EXC_ERROR;

900: p_token2_value =>l_deliverable_name,
901: p_token3 =>'ACTION_NAME',
902: p_token3_value =>l_action_name
903: );
904: raise FND_API.G_EXC_ERROR;
905: end if;
906: end if;
907: If p_volume is not null or p_volume_uom is not null
908: or p_weight is not null or p_weight_uom is not null then

Line 923: raise FND_API.G_EXC_ERROR;

919: p_token3 =>'ACTION_NAME',
920: p_token3_value =>l_action_name
921: );
922: close c_check_volume_uom;
923: raise FND_API.G_EXC_ERROR;
924: end if;
925: close c_check_volume_uom;
926: end if;
927: If p_weight_uom is not null then

Line 940: raise FND_API.G_EXC_ERROR;

936: p_token3 =>'ACTION_NAME',
937: p_token3_value =>l_action_name
938: );
939: close c_check_weight_uom;
940: raise FND_API.G_EXC_ERROR;
941: end if;
942: close c_check_weight_uom;
943: end if;
944: end if;

Line 948: WHEN FND_API.G_EXC_ERROR THEN

944: end if;
945: end if;
946: EXCEPTION
947:
948: WHEN FND_API.G_EXC_ERROR THEN
949: x_return_status := G_RET_STS_ERROR ;
950:
951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
952: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

947:
948: WHEN FND_API.G_EXC_ERROR THEN
949: x_return_status := G_RET_STS_ERROR ;
950:
951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
952: x_return_status := G_RET_STS_UNEXP_ERROR ;
953:
954: WHEN OTHERS THEN
955: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 962: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,

958:
959:
960: Procedure manage_dlv (
961: p_api_version IN Number,
962: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
963: p_commit IN Varchar2 default fnd_api.g_false,
964: p_action IN Varchar2,
965: p_item_dlv IN Varchar2,
966: p_master_inv_org_id IN Number,

Line 963: p_commit IN Varchar2 default fnd_api.g_false,

959:
960: Procedure manage_dlv (
961: p_api_version IN Number,
962: p_init_msg_list IN Varchar2 default FND_API.G_FALSE,
963: p_commit IN Varchar2 default fnd_api.g_false,
964: p_action IN Varchar2,
965: p_item_dlv IN Varchar2,
966: p_master_inv_org_id IN Number,
967: p_dlv_rec IN OUT NOCOPY dlv_rec_type,

Line 996: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

992: -- Standard Start of API savepoint
993: SAVEPOINT manage_dlv;
994:
995: -- Standard call to check for call compatibility.
996: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999:
1000: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

993: SAVEPOINT manage_dlv;
994:
995: -- Standard call to check for call compatibility.
996: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999:
1000: -- Initialize message list if p_init_msg_list is set to TRUE.
1001: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1001: IF FND_API.to_Boolean( p_init_msg_list ) THEN

997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999:
1000: -- Initialize message list if p_init_msg_list is set to TRUE.
1001: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1002: FND_MSG_PUB.initialize;
1003: END IF;
1004:
1005: -- Initialize API return status to success

Line 1006: x_return_status := FND_API.G_RET_STS_SUCCESS;

1002: FND_MSG_PUB.initialize;
1003: END IF;
1004:
1005: -- Initialize API return status to success
1006: x_return_status := FND_API.G_RET_STS_SUCCESS;
1007:
1008: If p_action not in (G_DEL,G_UPD,G_CRT) then
1009: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,
1010: p_token1 =>'COL_NAME',

Line 1012: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1008: If p_action not in (G_DEL,G_UPD,G_CRT) then
1009: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,
1010: p_token1 =>'COL_NAME',
1011: p_token1_value =>'p_action');
1012: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1013: end if;
1014:
1015: l_project_name := get_project_name(p_dlv_rec.project_id);
1016: l_deliverable_name := p_dlv_rec.dlv_short_name;

Line 1028: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1024: p_token1 =>'COL_NAME',
1025: p_token1_value =>'source_deliverable_id'
1026: );
1027: close c_get_dlv_id;
1028: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1029: end if;
1030:
1031: close c_get_dlv_id;
1032: Open c_check_action(l_deliverable_id);

Line 1043: raise FND_API.G_EXC_ERROR;

1039: p_token2 =>'DELIVERABLE_NAME',
1040: p_token2_value =>l_deliverable_name
1041: );
1042: close c_check_action;
1043: raise FND_API.G_EXC_ERROR;
1044: end if;
1045: close c_check_action;
1046: end if;
1047:

Line 1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1063: p_deliverable_id => l_deliverable_id,
1064: x_return_status => x_return_status);
1065:
1066: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1068: elsif (x_return_status = G_RET_STS_ERROR) then
1069: RAISE FND_API.G_EXC_ERROR ;
1070: end if;
1071:

Line 1069: RAISE FND_API.G_EXC_ERROR ;

1065:
1066: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1068: elsif (x_return_status = G_RET_STS_ERROR) then
1069: RAISE FND_API.G_EXC_ERROR ;
1070: end if;
1071:
1072: If p_action = G_CRT then
1073: select oke_k_deliverables_s.nextval into l_deliverable_id from dual;

Line 1136: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1132: LAST_UPDATED_BY = fnd_globaL.user_id,
1133: LAST_UPDATE_LOGIN = fnd_global.login_id
1134: where DELIVERABLE_ID = l_deliverable_id;
1135: if (sql%notfound) then
1136: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1137: end if;
1138:
1139: update OKE_DELIVERABLES_TL set
1140: DESCRIPTION = p_dlv_rec.dlv_description,

Line 1167: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1163: end if;
1164:
1165: if p_action = G_DEL then
1166: if p_dlv_rec.pa_deliverable_id is null then
1167: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1168: end if;
1169: OKE_DELIVERABLE_ACTIONS_PKG.delete_deliverable(p_dlv_rec.pa_deliverable_id);
1170: end if;
1171: If fnd_api.to_boolean( p_commit ) then

Line 1171: If fnd_api.to_boolean( p_commit ) then

1167: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1168: end if;
1169: OKE_DELIVERABLE_ACTIONS_PKG.delete_deliverable(p_dlv_rec.pa_deliverable_id);
1170: end if;
1171: If fnd_api.to_boolean( p_commit ) then
1172: commit work;
1173: end if;
1174:
1175: -- Standard call to get message count and if count is 1, get message info.

Line 1180: WHEN FND_API.G_EXC_ERROR THEN

1176: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1177:
1178: EXCEPTION
1179:
1180: WHEN FND_API.G_EXC_ERROR THEN
1181:
1182: ROLLBACK TO manage_dlv;
1183: x_return_status := G_RET_STS_ERROR ;
1184: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1182: ROLLBACK TO manage_dlv;
1183: x_return_status := G_RET_STS_ERROR ;
1184: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1185:
1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1187:
1188: ROLLBACK TO manage_dlv;
1189: x_return_status := G_RET_STS_UNEXP_ERROR ;
1190: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1204: p_init_msg_list IN Varchar2 default fnd_api.g_false,

1200: END;
1201:
1202: Procedure manage_dlv_action(
1203: p_api_version IN Number,
1204: p_init_msg_list IN Varchar2 default fnd_api.g_false,
1205: p_commit IN Varchar2 default fnd_api.g_false,
1206: p_action IN Varchar2,
1207: p_item_dlv IN Varchar2,
1208: p_master_inv_org_id IN Number,

Line 1205: p_commit IN Varchar2 default fnd_api.g_false,

1201:
1202: Procedure manage_dlv_action(
1203: p_api_version IN Number,
1204: p_init_msg_list IN Varchar2 default fnd_api.g_false,
1205: p_commit IN Varchar2 default fnd_api.g_false,
1206: p_action IN Varchar2,
1207: p_item_dlv IN Varchar2,
1208: p_master_inv_org_id IN Number,
1209: p_dlv_action_type IN Varchar2,

Line 1289: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1285: -- Standard Start of API savepoint
1286: SAVEPOINT manage_dlv_action;
1287:
1288: -- Standard call to check for call compatibility.
1289: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1291: END IF;
1292:
1293: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1286: SAVEPOINT manage_dlv_action;
1287:
1288: -- Standard call to check for call compatibility.
1289: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1291: END IF;
1292:
1293: -- Initialize message list if p_init_msg_list is set to TRUE.
1294: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1294: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1291: END IF;
1292:
1293: -- Initialize message list if p_init_msg_list is set to TRUE.
1294: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1295: FND_MSG_PUB.initialize;
1296: END IF;
1297:
1298: -- Initialize API return status to success

Line 1299: x_return_status := FND_API.G_RET_STS_SUCCESS;

1295: FND_MSG_PUB.initialize;
1296: END IF;
1297:
1298: -- Initialize API return status to success
1299: x_return_status := FND_API.G_RET_STS_SUCCESS;
1300:
1301: If p_action not in (G_CRT,G_DEL,G_UPD) then
1302: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,
1303: p_token1 =>'COL_NAME',

Line 1305: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1301: If p_action not in (G_CRT,G_DEL,G_UPD) then
1302: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,
1303: p_token1 =>'COL_NAME',
1304: p_token1_value =>'p_action');
1305: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1306: end if;
1307:
1308: If p_dlv_action_type not in (G_SHIP,G_REQ) then
1309: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,

Line 1312: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1308: If p_dlv_action_type not in (G_SHIP,G_REQ) then
1309: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,
1310: p_token1 =>'COL_NAME',
1311: p_token1_value =>'p_dlv_action_type');
1312: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1313: end if;
1314:
1315: Select decode(p_dlv_action_type,G_SHIP,p_dlv_ship_action_rec.pa_action_id,G_REQ, p_dlv_req_action_rec.pa_action_id,NULL),
1316: decode(p_dlv_action_type,G_SHIP,p_dlv_ship_action_rec.pa_deliverable_id,G_REQ, p_dlv_req_action_rec.pa_deliverable_id,NULL),

Line 1324: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1320: If l_pa_action_id is null then
1321: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,
1322: p_token1 =>'COL_NAME',
1323: p_token1_value =>'pa_action_id');
1324: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1325: end if;
1326:
1327: If p_action in (G_DEL,G_UPD) then
1328: Open c_get_actions_ids(l_pa_action_id);

Line 1336: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1332: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,
1333: p_token1 =>'COL_NAME',
1334: p_token1_value =>'pa_action_id');
1335: close c_get_actions_ids;
1336: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1337: end if;
1338: close c_get_actions_ids;
1339: else
1340: Open c_get_del_ids(l_pa_deliverable_id);

Line 1348: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1344: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,
1345: p_token1 =>'COL_NAME',
1346: p_token1_value =>'pa_deliverable_id');
1347: close c_get_del_ids;
1348: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1349: end if;
1350: close c_get_del_ids;
1351: end if;
1352:

Line 1368: raise FND_API.G_EXC_ERROR;

1364: p_token2_value =>l_deliverable_name,
1365: p_token3 =>'ACTION_NAME',
1366: p_token3_value =>l_action_name
1367: );
1368: raise FND_API.G_EXC_ERROR;
1369: end if;
1370: close c_get_action_status;
1371:
1372: If p_action = G_DEL then

Line 1384: raise FND_API.G_EXC_ERROR;

1380: p_token2_value =>l_deliverable_name,
1381: p_token3 =>'ACTION_NAME',
1382: p_token3_value =>l_action_name
1383: );
1384: raise FND_API.G_EXC_ERROR;
1385: end if;
1386: end if;
1387: end if;
1388:

Line 1486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1482: p_unit_price => l_unit_price,
1483: x_return_status => x_return_status);
1484:
1485: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1487: elsif (x_return_status = G_RET_STS_ERROR) then
1488: RAISE FND_API.G_EXC_ERROR ;
1489: end if;
1490:

Line 1488: RAISE FND_API.G_EXC_ERROR ;

1484:
1485: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1487: elsif (x_return_status = G_RET_STS_ERROR) then
1488: RAISE FND_API.G_EXC_ERROR ;
1489: end if;
1490:
1491: If p_action=G_CRT then
1492:

Line 1650: raise FND_API.G_EXC_ERROR ;

1646: LAST_UPDATE_LOGIN = fnd_global.login_id,
1647: READY_FLAG = 'Y'
1648: where action_id=l_action_id;
1649: else
1650: raise FND_API.G_EXC_ERROR ;
1651: end if;
1652: end if;
1653: If p_dlv_action_type =G_SHIP and p_dlv_ship_action_rec.ready_to_ship_flag='Y' then
1654: If OKE_ACTION_VALIDATIONS_PKG.Validate_Wsh( P_Action_ID => l_action_id

Line 1676: raise FND_API.G_EXC_ERROR ;

1672: LAST_UPDATE_LOGIN = fnd_global.login_id,
1673: READY_FLAG = 'Y'
1674: where action_id=l_action_id;
1675: else
1676: raise FND_API.G_EXC_ERROR ;
1677: end if;
1678: end if;
1679: If p_dlv_action_type =G_SHIP then
1680: If p_dlv_ship_action_rec.initiate_planning_flag ='Y' then

Line 1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1685: x_return_status => x_return_status,
1686: x_msg_data => x_msg_data,
1687: x_msg_count => x_msg_count);
1688: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1690: elsif (x_return_status = G_RET_STS_ERROR) then
1691: RAISE FND_API.G_EXC_ERROR ;
1692: end if;
1693: end if;

Line 1691: RAISE FND_API.G_EXC_ERROR ;

1687: x_msg_count => x_msg_count);
1688: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1690: elsif (x_return_status = G_RET_STS_ERROR) then
1691: RAISE FND_API.G_EXC_ERROR ;
1692: end if;
1693: end if;
1694: If p_dlv_ship_action_rec.initiate_shipping_flag ='Y' then
1695: initiate_dlv_action (

Line 1703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1699: x_return_status => x_return_status,
1700: x_msg_data => x_msg_data,
1701: x_msg_count => x_msg_count);
1702: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1704: elsif (x_return_status = G_RET_STS_ERROR) then
1705: RAISE FND_API.G_EXC_ERROR ;
1706: end if;
1707: end if;

Line 1705: RAISE FND_API.G_EXC_ERROR ;

1701: x_msg_count => x_msg_count);
1702: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1704: elsif (x_return_status = G_RET_STS_ERROR) then
1705: RAISE FND_API.G_EXC_ERROR ;
1706: end if;
1707: end if;
1708: end if;
1709: If p_dlv_action_type =G_REQ and p_dlv_req_action_rec.initiate_procure_flag ='Y' then

Line 1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1714: x_return_status => x_return_status,
1715: x_msg_data => x_msg_data,
1716: x_msg_count => x_msg_count);
1717: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1719: elsif (x_return_status = G_RET_STS_ERROR) then
1720: RAISE FND_API.G_EXC_ERROR ;
1721: end if;
1722: end if;

Line 1720: RAISE FND_API.G_EXC_ERROR ;

1716: x_msg_count => x_msg_count);
1717: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1719: elsif (x_return_status = G_RET_STS_ERROR) then
1720: RAISE FND_API.G_EXC_ERROR ;
1721: end if;
1722: end if;
1723: end if;
1724: If fnd_api.to_boolean( p_commit ) then

Line 1724: If fnd_api.to_boolean( p_commit ) then

1720: RAISE FND_API.G_EXC_ERROR ;
1721: end if;
1722: end if;
1723: end if;
1724: If fnd_api.to_boolean( p_commit ) then
1725: commit work;
1726: end if;
1727:
1728: -- Standard call to get message count and if count is 1, get message info.

Line 1732: WHEN FND_API.G_EXC_ERROR THEN

1728: -- Standard call to get message count and if count is 1, get message info.
1729: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1730: EXCEPTION
1731:
1732: WHEN FND_API.G_EXC_ERROR THEN
1733:
1734: ROLLBACK TO manage_dlv_action;
1735: x_return_status := G_RET_STS_ERROR ;
1736: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1734: ROLLBACK TO manage_dlv_action;
1735: x_return_status := G_RET_STS_ERROR ;
1736: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1737:
1738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1739:
1740: ROLLBACK TO manage_dlv_action;
1741: x_return_status := G_RET_STS_UNEXP_ERROR ;
1742: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1758: p_init_msg_list IN Varchar2 default fnd_api.g_false,

1754:
1755:
1756: Procedure initiate_dlv_action(
1757: p_api_version IN Number,
1758: p_init_msg_list IN Varchar2 default fnd_api.g_false,
1759: p_commit IN Varchar2 default fnd_api.g_false,
1760: p_pa_action_id IN Number,
1761: p_dlv_action_type IN Varchar2,
1762: x_return_status OUT NOCOPY Varchar2,

Line 1759: p_commit IN Varchar2 default fnd_api.g_false,

1755:
1756: Procedure initiate_dlv_action(
1757: p_api_version IN Number,
1758: p_init_msg_list IN Varchar2 default fnd_api.g_false,
1759: p_commit IN Varchar2 default fnd_api.g_false,
1760: p_pa_action_id IN Number,
1761: p_dlv_action_type IN Varchar2,
1762: x_return_status OUT NOCOPY Varchar2,
1763: x_msg_data OUT NOCOPY Varchar2,

Line 1808: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1804: BEGIN
1805:
1806: SAVEPOINT initiate_dlv_action;
1807: -- Standard call to check for call compatibility.
1808: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: END IF;
1811:
1812: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1805:
1806: SAVEPOINT initiate_dlv_action;
1807: -- Standard call to check for call compatibility.
1808: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: END IF;
1811:
1812: -- Initialize message list if p_init_msg_list is set to TRUE.
1813: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1813: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1810: END IF;
1811:
1812: -- Initialize message list if p_init_msg_list is set to TRUE.
1813: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1814: FND_MSG_PUB.initialize;
1815: END IF;
1816:
1817: -- Initialize API return status to success

Line 1818: x_return_status := FND_API.G_RET_STS_SUCCESS;

1814: FND_MSG_PUB.initialize;
1815: END IF;
1816:
1817: -- Initialize API return status to success
1818: x_return_status := FND_API.G_RET_STS_SUCCESS;
1819:
1820: If p_dlv_action_type not in (G_SHIP,G_REQ,G_MDS) then
1821: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,
1822: p_token1 =>'COL_NAME',

Line 1824: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1820: If p_dlv_action_type not in (G_SHIP,G_REQ,G_MDS) then
1821: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,
1822: p_token1 =>'COL_NAME',
1823: p_token1_value =>'p_dlv_action_type');
1824: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1825: End if;
1826:
1827: Open c_get_detail(p_pa_action_id );
1828: Fetch c_get_detail into l_deliverable_id,

Line 1844: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1840: l_quantity,
1841: l_uom_code ;
1842: If c_get_detail%rowcount=0 then
1843: close c_get_detail;
1844: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1845: end if;
1846: close c_get_detail;
1847:
1848: l_deliverable_name := get_dlv_name(l_deliverable_id);

Line 1865: P_Init_Msg_List => fnd_api.g_false,

1861: P_quantity => l_quantity,
1862: P_uom_code => l_uom_code)='Y' then
1863:
1864: OKE_DELIVERABLE_ACTIONS_PKG.Create_Demand( P_Action_ID => l_action_id,
1865: P_Init_Msg_List => fnd_api.g_false,
1866: X_ID => l_out_id,
1867: X_Return_Status => x_return_status,
1868: X_Msg_Count => x_msg_count,
1869: X_Msg_Data => x_msg_data );

Line 1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1867: X_Return_Status => x_return_status,
1868: X_Msg_Count => x_msg_count,
1869: X_Msg_Data => x_msg_data );
1870: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1872: elsif (x_return_status = G_RET_STS_ERROR) then
1873: RAISE FND_API.G_EXC_ERROR ;
1874: end if;
1875: else

Line 1873: RAISE FND_API.G_EXC_ERROR ;

1869: X_Msg_Data => x_msg_data );
1870: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1872: elsif (x_return_status = G_RET_STS_ERROR) then
1873: RAISE FND_API.G_EXC_ERROR ;
1874: end if;
1875: else
1876: RAISE FND_API.G_EXC_ERROR ;
1877: end if;

Line 1876: RAISE FND_API.G_EXC_ERROR ;

1872: elsif (x_return_status = G_RET_STS_ERROR) then
1873: RAISE FND_API.G_EXC_ERROR ;
1874: end if;
1875: else
1876: RAISE FND_API.G_EXC_ERROR ;
1877: end if;
1878:
1879: end if;
1880: If p_dlv_action_type =G_REQ then

Line 1883: P_Init_Msg_List => fnd_api.g_false,

1879: end if;
1880: If p_dlv_action_type =G_REQ then
1881: If l_ready_flag='Y' then
1882: OKE_DELIVERABLE_ACTIONS_PKG.Create_Requisition( P_Action_ID => l_action_id,
1883: P_Init_Msg_List => fnd_api.g_false,
1884: X_ID => l_out_id,
1885: X_Return_Status => x_return_status,
1886: X_Msg_Count => x_msg_count,
1887: X_Msg_Data => x_msg_data );

Line 1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1885: X_Return_Status => x_return_status,
1886: X_Msg_Count => x_msg_count,
1887: X_Msg_Data => x_msg_data );
1888: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1890: elsif (x_return_status = G_RET_STS_ERROR) then
1891: RAISE FND_API.G_EXC_ERROR ;
1892: end if;
1893: else

Line 1891: RAISE FND_API.G_EXC_ERROR ;

1887: X_Msg_Data => x_msg_data );
1888: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1890: elsif (x_return_status = G_RET_STS_ERROR) then
1891: RAISE FND_API.G_EXC_ERROR ;
1892: end if;
1893: else
1894: oke_api.set_message(p_msg_name => 'OKE_ACTION_NOT_READY',
1895: p_token1 => 'PROJECT_NAME',

Line 1902: raise FND_API.G_EXC_ERROR;

1898: p_token2_value => l_deliverable_name,
1899: p_token3 => 'ACTION_NAME',
1900: p_token3_value => l_action_name
1901: );
1902: raise FND_API.G_EXC_ERROR;
1903: end if;
1904: end if;
1905: If p_dlv_action_type =G_SHIP then
1906: If l_ready_flag='Y' then

Line 1908: P_Init_Msg_List => fnd_api.g_false,

1904: end if;
1905: If p_dlv_action_type =G_SHIP then
1906: If l_ready_flag='Y' then
1907: OKE_DELIVERABLE_ACTIONS_PKG.create_Shipment( P_Action_ID => l_action_id,
1908: P_Init_Msg_List => fnd_api.g_false,
1909: X_ID => l_out_id,
1910: X_Return_Status => x_return_status,
1911: X_Msg_Count => x_msg_count,
1912: X_Msg_Data => x_msg_data );

Line 1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1910: X_Return_Status => x_return_status,
1911: X_Msg_Count => x_msg_count,
1912: X_Msg_Data => x_msg_data );
1913: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1915: elsif (x_return_status = G_RET_STS_ERROR) then
1916: RAISE FND_API.G_EXC_ERROR ;
1917: end if;
1918: else

Line 1916: RAISE FND_API.G_EXC_ERROR ;

1912: X_Msg_Data => x_msg_data );
1913: If (x_return_status = G_RET_STS_UNEXP_ERROR) then
1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1915: elsif (x_return_status = G_RET_STS_ERROR) then
1916: RAISE FND_API.G_EXC_ERROR ;
1917: end if;
1918: else
1919: oke_api.set_message(p_msg_name => 'OKE_ACTION_NOT_READY',
1920: p_token1 => 'PROJECT_NAME',

Line 1927: raise FND_API.G_EXC_ERROR;

1923: p_token2_value => l_deliverable_name,
1924: p_token3 => 'ACTION_NAME',
1925: p_token3_value => l_action_name
1926: );
1927: raise FND_API.G_EXC_ERROR;
1928: end if;
1929: end if;
1930:
1931: If fnd_api.to_boolean( p_commit ) then

Line 1931: If fnd_api.to_boolean( p_commit ) then

1927: raise FND_API.G_EXC_ERROR;
1928: end if;
1929: end if;
1930:
1931: If fnd_api.to_boolean( p_commit ) then
1932: commit work;
1933: end if;
1934:
1935: -- Standard call to get message count and if count is 1, get message info.

Line 1939: WHEN FND_API.G_EXC_ERROR THEN

1935: -- Standard call to get message count and if count is 1, get message info.
1936: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1937: EXCEPTION
1938:
1939: WHEN FND_API.G_EXC_ERROR THEN
1940:
1941: ROLLBACK TO initiate_dlv_action ;
1942: x_return_status := G_RET_STS_ERROR ;
1943: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1941: ROLLBACK TO initiate_dlv_action ;
1942: x_return_status := G_RET_STS_ERROR ;
1943: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1944:
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946:
1947: ROLLBACK TO initiate_dlv_action ;
1948: x_return_status := G_RET_STS_UNEXP_ERROR ;
1949: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );