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 OKE_API

Line 6: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;

2: /* $Header: OKEAMGDB.pls 120.1 2005/09/20 10:30:32 ausmani noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL MESSAGE CONSTANTS
5: ---------------------------------------------------------------------------
6: G_FND_APP CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
7: ---------------------------------------------------------------------------
8: -- GLOBAL VARIABLES
9: ---------------------------------------------------------------------------
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_AMG_GRP';

Line 11: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;

7: ---------------------------------------------------------------------------
8: -- GLOBAL VARIABLES
9: ---------------------------------------------------------------------------
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_AMG_GRP';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
12:
13: ------------------------------------------------------------------------------
14: -- GLOBAL CONSTANTS
15: ------------------------------------------------------------------------------

Line 128: oke_api.set_message(p_msg_name => 'OKE_DLV_SHORT_NAME',

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',
129: p_token1 =>'PROJECT_NAME',
130: p_token1_value =>l_project_name,
131: p_token2 =>'DELIVERABLE_NAME',
132: p_token2_value =>l_deliverable_name);

Line 148: oke_api.set_message(p_msg_name => 'OKE_CHECK_DLV_INV',

144: If p_inventory_org_id is not null then
145: Open c_check_inv(p_master_inv_org_id,p_inventory_org_id);
146: Fetch c_check_inv into l_x;
147: If c_check_inv%rowcount = 0 then
148: oke_api.set_message(p_msg_name => 'OKE_CHECK_DLV_INV',
149: p_token1 =>'PROJECT_NAME',
150: p_token1_value =>l_project_name,
151: p_token2 =>'DELIVERABLE_NAME',
152: p_token2_value =>l_deliverable_name);

Line 162: oke_api.set_message(p_msg_name =>'OKE_CHECK_DLV_ITEM',

158: If p_item_id is not null then
159: Open c_check_item(p_item_id,p_inventory_org_id);
160: Fetch c_check_item into l_x;
161: If c_check_item%rowcount = 0 then
162: oke_api.set_message(p_msg_name =>'OKE_CHECK_DLV_ITEM',
163: p_token1 =>'PROJECT_NAME',
164: p_token1_value =>l_project_name,
165: p_token2 =>'DELIVERABLE_NAME',
166: p_token2_value =>l_deliverable_name);

Line 178: oke_api.set_message(p_msg_name =>'OKE_CHECK_DLV_ITEM_MAS',

174: If p_item_id is not null then
175: Open c_check_item(p_item_id,p_master_inv_org_id);
176: Fetch c_check_item into l_x;
177: If c_check_item%rowcount = 0 then
178: oke_api.set_message(p_msg_name =>'OKE_CHECK_DLV_ITEM_MAS',
179: p_token1 =>'PROJECT_NAME',
180: p_token1_value =>l_project_name,
181: p_token2 =>'DELIVERABLE_NAME',
182: p_token2_value =>l_deliverable_name);

Line 195: oke_api.set_message(p_msg_name =>'OKE_CHECK_UOM',

191: If p_item_id is not null then
192: Open c_check_uom(p_item_id ,p_uom_code);
193: Fetch c_check_uom into l_x;
194: If c_check_uom%rowcount = 0 then
195: oke_api.set_message(p_msg_name =>'OKE_CHECK_UOM',
196: p_token1 =>'PROJECT_NAME',
197: p_token1_value =>l_project_name,
198: p_token2 =>'DELIVERABLE_NAME',
199: p_token2_value =>l_deliverable_name);

Line 205: oke_api.set_message(p_msg_name =>'OKE_CHECK_UOM_ENTERABLE',

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',
206: p_token1 =>'PROJECT_NAME',
207: p_token1_value =>l_project_name,
208: p_token2 =>'DELIVERABLE_NAME',
209: p_token2_value =>l_deliverable_name);

Line 225: oke_api.set_message(p_msg_name =>'OKE_CHECK_CURRENCY',

221: If p_currency_code is not null then
222: Open c_check_currency(p_currency_code);
223: Fetch c_check_currency into l_x;
224: If c_check_currency%rowcount = 0 then
225: oke_api.set_message(p_msg_name =>'OKE_CHECK_CURRENCY',
226: p_token1 =>'PROJECT_NAME',
227: p_token1_value =>l_project_name,
228: p_token2 =>'DELIVERABLE_NAME',
229: p_token2_value =>l_deliverable_name);

Line 245: oke_api.set_message(p_msg_name =>'OKE_CHECK_UNIT_NO',

241: If p_item_id is not null then
242: Open c_check_unit_number(p_item_id,p_unit_number);
243: Fetch c_check_unit_number into l_x;
244: If c_check_unit_number%rowcount = 0 then
245: oke_api.set_message(p_msg_name =>'OKE_CHECK_UNIT_NO',
246: p_token1 =>'PROJECT_NAME',
247: p_token1_value =>l_project_name,
248: p_token2 =>'DELIVERABLE_NAME',
249: p_token2_value =>l_deliverable_name);

Line 255: oke_api.set_message(p_msg_name =>'OKE_CHECK_UNIT_NO_ENTERABLE',

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',
256: p_token1 =>'PROJECT_NAME',
257: p_token1_value =>l_project_name,
258: p_token2 =>'DELIVERABLE_NAME',
259: p_token2_value =>l_deliverable_name);

Line 445: oke_api.set_message(p_msg_name =>'OKE_CHECK_CURRENCY',

441: If p_currency_code is not null then
442: Open c_check_currency;
443: fetch c_check_currency into l_x;
444: if c_check_currency%rowcount =0 then
445: oke_api.set_message(p_msg_name =>'OKE_CHECK_CURRENCY',
446: p_token1 =>'PROJECT_NAME',
447: p_token1_value =>l_project_name,
448: p_token2 =>'DELIVERABLE_NAME',
449: p_token2_value =>l_deliverable_name,

Line 463: oke_api.set_message(p_msg_name =>'OKE_CHECK_UOM',

459: If p_uom_code is not null then
460: Open c_check_uom;
461: fetch c_check_uom into l_x;
462: if c_check_uom%rowcount =0 then
463: oke_api.set_message(p_msg_name =>'OKE_CHECK_UOM',
464: p_token1 =>'PROJECT_NAME',
465: p_token1_value =>l_project_name,
466: p_token2 =>'DELIVERABLE_NAME',
467: p_token2_value =>l_deliverable_name

Line 478: oke_api.set_message(p_msg_name =>'OKE_INVALID_DESTINATION_TYPE',

474: -- Check Destinattion Type
475:
476: If p_destination_type_code is not null then
477: If p_destination_type_code not in (G_INV, G_EXP) then
478: oke_api.set_message(p_msg_name =>'OKE_INVALID_DESTINATION_TYPE',
479: p_token1 =>'PROJECT_NAME',
480: p_token1_value =>l_project_name,
481: p_token2 =>'DELIVERABLE_NAME',
482: p_token2_value =>l_deliverable_name,

Line 490: oke_api.set_message(p_msg_name=>'OKE_INVALID_NONITEM_DEST_TYPE',

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',
491: p_token1 =>'PROJECT_NAME',
492: p_token1_value =>l_project_name,
493: p_token2 =>'DELIVERABLE_NAME',
494: p_token2_value =>l_deliverable_name,

Line 505: oke_api.set_message(p_msg_name =>'OKE_SAME_REC_ORG',

501: -- Check Receiving Org
502: If p_ship_to_org_id is not null then
503: If p_item_dlv='Y' then
504: If p_ship_to_org_id <> p_inv_org_id then
505: oke_api.set_message(p_msg_name =>'OKE_SAME_REC_ORG',
506: p_token1 =>'PROJECT_NAME',
507: p_token1_value =>l_project_name,
508: p_token2 =>'DELIVERABLE_NAME',
509: p_token2_value =>l_deliverable_name,

Line 519: oke_api.set_message(p_msg_name =>'OKE_INVALID_REC_ORG',

515: Else
516: Open c_check_rec_org;
517: Fetch c_check_rec_org into l_x;
518: if c_check_rec_org%rowcount =0 then
519: oke_api.set_message(p_msg_name =>'OKE_INVALID_REC_ORG',
520: p_token1 =>'PROJECT_NAME',
521: p_token1_value =>l_project_name,
522: p_token2 =>'DELIVERABLE_NAME',
523: p_token2_value =>l_deliverable_name,

Line 540: oke_api.set_message(p_msg_name =>'OKE_INVALID_RECV_LOC',

536: If p_ship_to_org_id is not null then
537: Open c_check_rec_loc;
538: Fetch c_check_rec_loc into l_x;
539: if c_check_rec_loc%rowcount =0 then
540: oke_api.set_message(p_msg_name =>'OKE_INVALID_RECV_LOC',
541: p_token1 =>'PROJECT_NAME',
542: p_token1_value =>l_project_name,
543: p_token2 =>'DELIVERABLE_NAME',
544: p_token2_value =>l_deliverable_name,

Line 553: oke_api.set_message(p_msg_name =>'OKE_INVALID_RECV_LOC1',

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',
554: p_token1 =>'PROJECT_NAME',
555: p_token1_value =>l_project_name,
556: p_token2 =>'DELIVERABLE_NAME',
557: p_token2_value =>l_deliverable_name,

Line 570: oke_api.set_message(p_msg_name =>'OKE_INVALID_VENDOR',

566: If p_ship_from_org_id is not null then
567: Open c_check_vendor;
568: Fetch c_check_vendor into l_x;
569: if c_check_vendor%rowcount =0 then
570: oke_api.set_message(p_msg_name =>'OKE_INVALID_VENDOR',
571: p_token1 =>'PROJECT_NAME',
572: p_token1_value =>l_project_name,
573: p_token2 =>'DELIVERABLE_NAME',
574: p_token2_value =>l_deliverable_name,

Line 589: oke_api.set_message(p_msg_name =>'OKE_INVALID_VENDOR_SITE',

585: If p_ship_from_org_id is not null then
586: Open c_check_vendor_site;
587: Fetch c_check_vendor_site into l_x;
588: if c_check_vendor_site%rowcount =0 then
589: oke_api.set_message(p_msg_name =>'OKE_INVALID_VENDOR_SITE',
590: p_token1 =>'PROJECT_NAME',
591: p_token1_value =>l_project_name,
592: p_token2 =>'DELIVERABLE_NAME',
593: p_token2_value =>l_deliverable_name,

Line 602: oke_api.set_message(p_msg_name =>'OKE_INVALID_VENDOR_SITE1',

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',
603: p_token1 =>'PROJECT_NAME',
604: p_token1_value =>l_project_name,
605: p_token2 =>'DELIVERABLE_NAME',
606: p_token2_value =>l_deliverable_name,

Line 618: oke_api.set_message(p_msg_name =>'OKE_INVALID_EXCHANGE_TYPE',

614: If p_exchange_rate_type is not null then
615: Open c_check_exchange_type;
616: Fetch c_check_exchange_type into l_x;
617: if c_check_exchange_type%rowcount =0 then
618: oke_api.set_message(p_msg_name =>'OKE_INVALID_EXCHANGE_TYPE',
619: p_token1 =>'PROJECT_NAME',
620: p_token1_value =>l_project_name,
621: p_token2 =>'DELIVERABLE_NAME',
622: p_token2_value =>l_deliverable_name,

Line 633: oke_api.set_message(p_msg_name =>'OKE_INVALID_EXCHANGE_RATE',

629: close c_check_exchange_type;
630: end if;
631: -- Check Exchange rate
632: If p_exchange_rate is not null and p_exchange_rate_type =G_USER then
633: oke_api.set_message(p_msg_name =>'OKE_INVALID_EXCHANGE_RATE',
634: p_token1 =>'PROJECT_NAME',
635: p_token1_value =>l_project_name,
636: p_token2 =>'DELIVERABLE_NAME',
637: p_token2_value =>l_deliverable_name,

Line 646: oke_api.set_message(p_msg_name =>'OKE_INVALID_EXCHANGE_RATE1',

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
646: oke_api.set_message(p_msg_name =>'OKE_INVALID_EXCHANGE_RATE1',
647: p_token1 =>'PROJECT_NAME',
648: p_token1_value =>l_project_name,
649: p_token2 =>'DELIVERABLE_NAME',
650: p_token2_value =>l_deliverable_name,

Line 670: oke_api.set_message(p_msg_name =>'OKE_INVALID_EXPENDITURE_TYPE',

666: If p_expenditure_type is not null then
667: Open c_check_expend_type;
668: Fetch c_check_expend_type into l_x;
669: if c_check_expend_type%rowcount =0 then
670: oke_api.set_message(p_msg_name =>'OKE_INVALID_EXPENDITURE_TYPE',
671: p_token1 =>'PROJECT_NAME',
672: p_token1_value =>l_project_name,
673: p_token2 =>'DELIVERABLE_NAME',
674: p_token2_value =>l_deliverable_name,

Line 688: oke_api.set_message(p_msg_name =>'OKE_INVALID_EXPENDITURE_ORG',

684: If p_expenditure_org_id is not null then
685: Open c_check_expend_org;
686: Fetch c_check_expend_org into l_x;
687: if c_check_expend_org%rowcount =0 then
688: oke_api.set_message(p_msg_name =>'OKE_INVALID_EXPENDITURE_ORG',
689: p_token1 =>'PROJECT_NAME',
690: p_token1_value =>l_project_name,
691: p_token2 =>'DELIVERABLE_NAME',
692: p_token2_value =>l_deliverable_name,

Line 706: oke_api.set_message(p_msg_name =>'OKE_INVALID_REQ_TYPE',

702: If p_requisition_line_type_id is not null then
703: Open c_check_req_type;
704: Fetch c_check_req_type into l_x;
705: if c_check_req_type%rowcount =0 then
706: oke_api.set_message(p_msg_name =>'OKE_INVALID_REQ_TYPE',
707: p_token1 =>'PROJECT_NAME',
708: p_token1_value =>l_project_name,
709: p_token2 =>'DELIVERABLE_NAME',
710: p_token2_value =>l_deliverable_name,

Line 723: oke_api.set_message(p_msg_name =>'OKE_INVALID_CATEGORY',

719: If p_category_id is not null then
720: Open c_check_category;
721: Fetch c_check_category into l_x;
722: if c_check_category%rowcount =0 then
723: oke_api.set_message(p_msg_name =>'OKE_INVALID_CATEGORY',
724: p_token1 =>'PROJECT_NAME',
725: p_token1_value =>l_project_name,
726: p_token2 =>'DELIVERABLE_NAME',
727: p_token2_value =>l_deliverable_name,

Line 765: oke_api.set_message(p_msg_name =>'OKE_CHECK_UOM',

761: If p_uom_code is not null then
762: Open c_check_uom;
763: fetch c_check_uom into l_x;
764: if c_check_uom%rowcount =0 then
765: oke_api.set_message(p_msg_name =>'OKE_CHECK_UOM',
766: p_token1 =>'PROJECT_NAME',
767: p_token1_value =>l_project_name,
768: p_token2 =>'DELIVERABLE_NAME',
769: p_token2_value =>l_deliverable_name

Line 786: oke_api.set_message(p_msg_name =>'OKE_INVALID_DEMAND_SCH',

782: If l_inv is not null then
783: Open c_check_demand_schedule;
784: Fetch c_check_demand_schedule into l_x;
785: If c_check_demand_schedule%rowcount =0 then
786: oke_api.set_message(p_msg_name =>'OKE_INVALID_DEMAND_SCH',
787: p_token1 =>'PROJECT_NAME',
788: p_token1_value =>l_project_name,
789: p_token2 =>'DELIVERABLE_NAME',
790: p_token2_value =>l_deliverable_name,

Line 799: oke_api.set_message(p_msg_name =>'OKE_INV_ORG_B4_PLAN',

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',
800: p_token1 =>'PROJECT_NAME',
801: p_token1_value =>l_project_name,
802: p_token2 =>'DELIVERABLE_NAME',
803: p_token2_value =>l_deliverable_name,

Line 815: oke_api.set_message(p_msg_name =>'OKE_INVALID_SHIP_FROM_ORG',

811: If p_ship_from_org_id is not null then
812: Open c_check_ship_from;
813: Fetch c_check_ship_from into l_x;
814: If c_check_ship_from%rowcount =0 then
815: oke_api.set_message(p_msg_name =>'OKE_INVALID_SHIP_FROM_ORG',
816: p_token1 =>'PROJECT_NAME',
817: p_token1_value =>l_project_name,
818: p_token2 =>'DELIVERABLE_NAME',
819: p_token2_value =>l_deliverable_name,

Line 834: oke_api.set_message(p_msg_name =>'OKE_INVALID_SHIP_FROM_LOC',

830: If p_ship_from_org_id is not null then
831: Open c_check_ship_from_loc;
832: Fetch c_check_ship_from_loc into l_x;
833: If c_check_ship_from_loc%rowcount =0 then
834: oke_api.set_message(p_msg_name =>'OKE_INVALID_SHIP_FROM_LOC',
835: p_token1 =>'PROJECT_NAME',
836: p_token1_value =>l_project_name,
837: p_token2 =>'DELIVERABLE_NAME',
838: p_token2_value =>l_deliverable_name,

Line 847: oke_api.set_message(p_msg_name =>'OKE_INVALID_SHIP_FROM_LOC1',

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',
848: p_token1 =>'PROJECT_NAME',
849: p_token1_value =>l_project_name,
850: p_token2 =>'DELIVERABLE_NAME',
851: p_token2_value =>l_deliverable_name,

Line 864: oke_api.set_message(p_msg_name =>'OKE_INVALID_CUSTOMER',

860: If p_ship_to_org_id is not null then
861: Open c_check_customer;
862: Fetch c_check_customer into l_x;
863: If c_check_customer%rowcount =0 then
864: oke_api.set_message(p_msg_name =>'OKE_INVALID_CUSTOMER',
865: p_token1 =>'PROJECT_NAME',
866: p_token1_value =>l_project_name,
867: p_token2 =>'DELIVERABLE_NAME',
868: p_token2_value =>l_deliverable_name,

Line 883: oke_api.set_message(p_msg_name =>'OKE_INVALID_CUST_ADD',

879: If p_ship_to_org_id is not null then
880: Open c_check_cust_add;
881: Fetch c_check_cust_add into l_x;
882: If c_check_cust_add%rowcount =0 then
883: oke_api.set_message(p_msg_name =>'OKE_INVALID_CUST_ADD',
884: p_token1 =>'PROJECT_NAME',
885: p_token1_value =>l_project_name,
886: p_token2 =>'DELIVERABLE_NAME',
887: p_token2_value =>l_deliverable_name,

Line 896: oke_api.set_message(p_msg_name =>'OKE_INVALID_CUST_ADD1',

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',
897: p_token1 =>'PROJECT_NAME',
898: p_token1_value =>l_project_name,
899: p_token2 =>'DELIVERABLE_NAME',
900: p_token2_value =>l_deliverable_name,

Line 914: oke_api.set_message(p_msg_name =>'OKE_INVALID_VOLUME_UOM',

910: If p_volume_uom is not null then
911: Open c_check_volume_uom;
912: Fetch c_check_volume_uom into l_x;
913: If c_check_volume_uom%rowcount =0 then
914: oke_api.set_message(p_msg_name =>'OKE_INVALID_VOLUME_UOM',
915: p_token1 =>'PROJECT_NAME',
916: p_token1_value =>l_project_name,
917: p_token2 =>'DELIVERABLE_NAME',
918: p_token2_value =>l_deliverable_name,

Line 931: oke_api.set_message(p_msg_name =>'OKE_INVALID_WEIGHT_UOM',

927: If p_weight_uom is not null then
928: Open c_check_weight_uom;
929: Fetch c_check_weight_uom into l_x;
930: If c_check_weight_uom%rowcount =0 then
931: oke_api.set_message(p_msg_name =>'OKE_INVALID_WEIGHT_UOM',
932: p_token1 =>'PROJECT_NAME',
933: p_token1_value =>l_project_name,
934: p_token2 =>'DELIVERABLE_NAME',
935: p_token2_value =>l_deliverable_name,

Line 1009: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,

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',
1011: p_token1_value =>'p_action');
1012: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1013: end if;

Line 1023: oke_api.set_message(p_msg_name =>OKE_API.G_INVALID_VALUE,

1019: Open c_get_dlv_id;
1020: fetch c_get_dlv_id into l_deliverable_id;
1021:
1022: If c_get_dlv_id%notfound then
1023: oke_api.set_message(p_msg_name =>OKE_API.G_INVALID_VALUE,
1024: p_token1 =>'COL_NAME',
1025: p_token1_value =>'source_deliverable_id'
1026: );
1027: close c_get_dlv_id;

Line 1036: oke_api.set_message(p_msg_name =>'OKE_DLV_ACTION_INITIATED',

1032: Open c_check_action(l_deliverable_id);
1033: fetch c_check_action into l_x;
1034:
1035: if c_check_action%found then
1036: oke_api.set_message(p_msg_name =>'OKE_DLV_ACTION_INITIATED',
1037: p_token1 =>'PROJECT_NAME',
1038: p_token1_value =>l_project_name,
1039: p_token2 =>'DELIVERABLE_NAME',
1040: p_token2_value =>l_deliverable_name

Line 1302: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,

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',
1304: p_token1_value =>'p_action');
1305: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1306: end if;

Line 1309: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,

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,
1310: p_token1 =>'COL_NAME',
1311: p_token1_value =>'p_dlv_action_type');
1312: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1313: end if;

Line 1321: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,

1317: decode(p_dlv_action_type,G_SHIP,p_dlv_ship_action_rec.action_name,G_REQ, p_dlv_req_action_rec.action_name,NULL)
1318: into l_pa_action_id,l_pa_deliverable_id,l_action_name from dual;
1319:
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;

Line 1332: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,

1328: Open c_get_actions_ids(l_pa_action_id);
1329: Fetch c_get_actions_ids into l_action_id, l_deliverable_id,l_project_id;
1330:
1331: If l_action_id is null then
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;

Line 1344: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,

1340: Open c_get_del_ids(l_pa_deliverable_id);
1341: Fetch c_get_del_ids into l_deliverable_id,l_project_id;
1342:
1343: If l_deliverable_id is null then
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;

Line 1360: oke_api.set_message(p_msg_name =>'OKE_DLV_ACTION_INITIATED',

1356: If p_action in (G_DEL,G_UPD) then
1357: Open c_get_action_status(l_action_id);
1358: fetch c_get_action_status into l_x;
1359: If c_get_action_status%rowcount > 0 then
1360: oke_api.set_message(p_msg_name =>'OKE_DLV_ACTION_INITIATED',
1361: p_token1 =>'PROJECT_NAME',
1362: p_token1_value =>l_project_name,
1363: p_token2 =>'DELIVERABLE_NAME',
1364: p_token2_value =>l_deliverable_name,

Line 1376: oke_api.set_message(p_msg_name =>'OKE_DLV_ACTION_INITIATED',

1372: If p_action = G_DEL then
1373: If OKE_DELIVERABLE_UTILS_PUB.Action_Deletable_Yn(l_pa_action_id)='Y' then
1374: OKE_DELIVERABLE_ACTIONS_PKG.Delete_action(l_pa_action_id);
1375: else
1376: oke_api.set_message(p_msg_name =>'OKE_DLV_ACTION_INITIATED',
1377: p_token1 =>'PROJECT_NAME',
1378: p_token1_value =>l_project_name,
1379: p_token2 =>'DELIVERABLE_NAME',
1380: p_token2_value =>l_deliverable_name,

Line 1821: oke_api.set_message(p_msg_name => OKE_API.G_INVALID_VALUE,

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',
1823: p_token1_value =>'p_dlv_action_type');
1824: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1825: End if;

Line 1894: oke_api.set_message(p_msg_name => 'OKE_ACTION_NOT_READY',

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',
1896: p_token1_value => l_project_name,
1897: p_token2 => 'DELIVERABLE_NAME',
1898: p_token2_value => l_deliverable_name,

Line 1919: oke_api.set_message(p_msg_name => 'OKE_ACTION_NOT_READY',

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',
1921: p_token1_value => l_project_name,
1922: p_token2 => 'DELIVERABLE_NAME',
1923: p_token2_value => l_deliverable_name,