DBA Data[Home] [Help]

APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on FND_MESSAGE

Line 18: FND_MESSAGE.set_name('EAM', 'EAM_INVALID_TXN_TYPE');

14: BEGIN
15: IF p_x_return_status = FND_API.G_RET_STS_SUCCESS THEN
16: IF (NOT p_transaction_type = G_TXN_TYPE_COMPLETE) AND (NOT p_transaction_type = G_TXN_TYPE_UNCOMPLETE) THEN
17: -- validate transaction type
18: FND_MESSAGE.set_name('EAM', 'EAM_INVALID_TXN_TYPE');
19: p_x_return_status := FND_API.G_RET_STS_ERROR;
20: ELSIF p_transaction_date > sysdate THEN
21: -- validate transaction_date
22: FND_MESSAGE.set_name('EAM', 'EAM_TXN_LATER_THAN_TODAY');

Line 22: FND_MESSAGE.set_name('EAM', 'EAM_TXN_LATER_THAN_TODAY');

18: FND_MESSAGE.set_name('EAM', 'EAM_INVALID_TXN_TYPE');
19: p_x_return_status := FND_API.G_RET_STS_ERROR;
20: ELSIF p_transaction_date > sysdate THEN
21: -- validate transaction_date
22: FND_MESSAGE.set_name('EAM', 'EAM_TXN_LATER_THAN_TODAY');
23: p_x_return_status := FND_API.G_RET_STS_ERROR;
24: END IF;
25: END IF;
26: END Validate_Transaction;

Line 49: FND_MESSAGE.set_name('EAM', 'EAM_MISSING_DATE_INFO');

45: ELSIF p_x_actual_duration is not null THEN
46: p_x_actual_end_date := p_x_actual_start_date + p_x_actual_duration;
47: ELSE
48: -- missing both end_date and duration
49: FND_MESSAGE.set_name('EAM', 'EAM_MISSING_DATE_INFO');
50: p_x_return_status := FND_API.G_RET_STS_ERROR;
51: END IF;
52: ELSIF p_x_actual_end_date is not null THEN
53: IF p_x_actual_duration is not null THEN

Line 57: FND_MESSAGE.set_name('EAM', 'EAM_MISSING_DATE_INFO');

53: IF p_x_actual_duration is not null THEN
54: p_x_actual_start_date := p_x_actual_end_date - p_x_actual_duration;
55: ELSE
56: -- missing both start_date and duration
57: FND_MESSAGE.set_name('EAM', 'EAM_MISSING_DATE_INFO');
58: p_x_return_status := FND_API.G_RET_STS_ERROR;
59: END IF;
60: ELSE
61: -- missing both start and end dates

Line 62: FND_MESSAGE.set_name('EAM', 'EAM_MISSING_DATE_INFO');

58: p_x_return_status := FND_API.G_RET_STS_ERROR;
59: END IF;
60: ELSE
61: -- missing both start and end dates
62: FND_MESSAGE.set_name('EAM', 'EAM_MISSING_DATE_INFO');
63: p_x_return_status := FND_API.G_RET_STS_ERROR;
64: END IF;
65: END IF;
66: IF p_x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 68: FND_MESSAGE.set_name('EAM', 'EAM_END_BEFORE_START');

64: END IF;
65: END IF;
66: IF p_x_return_status = FND_API.G_RET_STS_SUCCESS THEN
67: IF p_x_actual_start_date > p_x_actual_end_date THEN
68: FND_MESSAGE.set_name('EAM', 'EAM_END_BEFORE_START');
69: p_x_return_status := FND_API.G_RET_STS_ERROR;
70: ELSIF p_x_actual_end_date > sysdate THEN
71: FND_MESSAGE.set_name('EAM', 'EAM_END_LATER_THAN_TODAY');
72: p_x_return_status := FND_API.G_RET_STS_ERROR;

Line 71: FND_MESSAGE.set_name('EAM', 'EAM_END_LATER_THAN_TODAY');

67: IF p_x_actual_start_date > p_x_actual_end_date THEN
68: FND_MESSAGE.set_name('EAM', 'EAM_END_BEFORE_START');
69: p_x_return_status := FND_API.G_RET_STS_ERROR;
70: ELSIF p_x_actual_end_date > sysdate THEN
71: FND_MESSAGE.set_name('EAM', 'EAM_END_LATER_THAN_TODAY');
72: p_x_return_status := FND_API.G_RET_STS_ERROR;
73: END IF;
74: END IF;
75: END Validate_Start_End_Dates;

Line 100: FND_MESSAGE.set_name('EAM', 'EAM_WORK_ORDER_MISSING_INFO');

96: IF NOT p_x_return_status = FND_API.G_RET_STS_SUCCESS THEN
97: return;
98: END IF;
99: IF (p_wip_entity_id is null or p_transaction_type is null or p_transaction_date is null) THEN
100: FND_MESSAGE.set_name('EAM', 'EAM_WORK_ORDER_MISSING_INFO');
101: p_x_return_status := FND_API.G_RET_STS_ERROR;
102: return;
103: END IF;
104:

Line 111: FND_MESSAGE.set_name('EAM', 'EAM_NOT_OPEN_EAM_JOB');

107: from wip_entities
108: where wip_entity_id = p_wip_entity_id;
109: if (NOT l_entity_type = 6) then
110: -- not an open eam job
111: FND_MESSAGE.set_name('EAM', 'EAM_NOT_OPEN_EAM_JOB');
112: p_x_return_status := FND_API.G_RET_STS_ERROR;
113: return;
114: END IF;
115:

Line 142: FND_MESSAGE.set_name('EAM', 'EAM_NOT_RELEASED_STATUS');

138: x_rebuild_jobs := 'Y';
139: end if;
140:
141: if p_transaction_type = G_TXN_TYPE_COMPLETE and (NOT l_status_type = 3) then
142: FND_MESSAGE.set_name('EAM', 'EAM_NOT_RELEASED_STATUS');
143: p_x_return_status := FND_API.G_RET_STS_ERROR;
144: elsif p_transaction_type = G_TXN_TYPE_UNCOMPLETE and (NOT l_status_type = 4) then
145: FND_MESSAGE.set_name('EAM', 'EAM_NOT_COMPLETED_STATUS');
146: p_x_return_status := FND_API.G_RET_STS_ERROR;

Line 145: FND_MESSAGE.set_name('EAM', 'EAM_NOT_COMPLETED_STATUS');

141: if p_transaction_type = G_TXN_TYPE_COMPLETE and (NOT l_status_type = 3) then
142: FND_MESSAGE.set_name('EAM', 'EAM_NOT_RELEASED_STATUS');
143: p_x_return_status := FND_API.G_RET_STS_ERROR;
144: elsif p_transaction_type = G_TXN_TYPE_UNCOMPLETE and (NOT l_status_type = 4) then
145: FND_MESSAGE.set_name('EAM', 'EAM_NOT_COMPLETED_STATUS');
146: p_x_return_status := FND_API.G_RET_STS_ERROR;
147: end if;
148: END Validate_Required_Information;
149:

Line 179: FND_MESSAGE.set_name('EAM', 'EAM_WO_ACTUAL_END_DATE');

175:
176: IF (l_max_op_end_date is not null AND
177: p_actual_end_date is not null AND
178: l_max_op_end_date > p_actual_end_date) then
179: FND_MESSAGE.set_name('EAM', 'EAM_WO_ACTUAL_END_DATE');
180: p_x_return_status := FND_API.G_RET_STS_ERROR;
181: return;
182: end IF;
183:

Line 187: FND_MESSAGE.set_name('EAM', 'EAM_WO_ACTUAL_START_DATE');

183:
184: IF (l_min_op_start_date is not null AND
185: p_actual_start_date is not null AND
186: l_min_op_start_date < p_actual_start_date) then
187: FND_MESSAGE.set_name('EAM', 'EAM_WO_ACTUAL_START_DATE');
188: p_x_return_status := FND_API.G_RET_STS_ERROR;
189: end IF;
190: END Validate_Actl_Dates_vs_Optns;
191:

Line 212: FND_MESSAGE.set_name('EAM', 'EAM_MIN_WO_ACTUAL_START_DATE');

208: from org_acct_periods
209: where organization_id = p_organization_id
210: and open_flag = 'Y';
211: if (p_actual_start_date < l_min_open_period_start_date) then
212: FND_MESSAGE.set_name('EAM', 'EAM_MIN_WO_ACTUAL_START_DATE');
213: p_x_return_status := FND_API.G_RET_STS_ERROR;
214: end if;
215: END Validate_Date_vs_Acct_Periods;*/
216:

Line 234: FND_MESSAGE.set_name('EAM', 'EAM_TRANSACTION_DATE_INVALID');

230: from org_acct_periods
231: where organization_id = p_organization_id
232: and open_flag = 'Y';
233: if (p_transaction_date < l_min_open_period_start_date) then
234: FND_MESSAGE.set_name('EAM', 'EAM_TRANSACTION_DATE_INVALID');
235: p_x_return_status := FND_API.G_RET_STS_ERROR;
236: end if;
237: END Validate_Date_vs_Acct_Periods;
238:

Line 279: FND_MESSAGE.set_name('EAM', 'EAM_INVENTORY_NULL');

275: IF NOT p_x_return_status = FND_API.G_RET_STS_SUCCESS THEN
276: return;
277: END IF;
278: IF (p_inventory_item_info.COUNT = 0) THEN
279: FND_MESSAGE.set_name('EAM', 'EAM_INVENTORY_NULL');
280: p_x_return_status := FND_API.G_RET_STS_ERROR;
281: RETURN;
282: END IF;
283:

Line 286: FND_MESSAGE.set_name('EAM', 'EAM_INVENTORY_NULL');

282: END IF;
283:
284: FOR i IN 1..p_inventory_item_info.COUNT LOOP
285: IF p_inventory_item_info(i).subinventory IS NULL THEN
286: FND_MESSAGE.set_name('EAM', 'EAM_INVENTORY_NULL');
287: p_x_return_status := FND_API.G_RET_STS_ERROR;
288: RETURN;
289: END IF;
290: END LOOP;

Line 295: FND_MESSAGE.set_name('EAM', 'EAM_MULTIPLE_INVENTORY');

291:
292: -- p_inventory_item_info can have multi-lines only if if this is service work order
293: if (p_instance_id is null) then
294: if (p_inventory_item_info.COUNT > 1) then
295: FND_MESSAGE.set_name('EAM', 'EAM_MULTIPLE_INVENTORY');
296: p_x_return_status := FND_API.G_RET_STS_ERROR;
297: return;
298: else
299: -- check for expense inventory

Line 305: FND_MESSAGE.set_name('EAM', 'EAM_EXPENSE_SUBINVENTORY');

301: from mtl_secondary_inventories
302: where secondary_inventory_name = p_inventory_item_info(1).subinventory
303: and organization_id = p_organization_id;
304: IF (NOT l_asset_inventory = 2) THEN
305: FND_MESSAGE.set_name('EAM', 'EAM_EXPENSE_SUBINVENTORY');
306: p_x_return_status := FND_API.G_RET_STS_ERROR;
307: return;
308: END IF;
309: end if;

Line 353: FND_MESSAGE.set_name('EAM', 'EAM_LOCATOR_ID_IS_NULL');

349:
350: if (l_location_control_code in (2,3) or l_locator_type in (2,3)
351: or l_stock_locator_control_code in (2,3)) then
352: if l_locator is null then
353: FND_MESSAGE.set_name('EAM', 'EAM_LOCATOR_ID_IS_NULL');
354: p_x_return_status := FND_API.G_RET_STS_ERROR;
355: return;
356: end if;
357: end if;

Line 363: FND_MESSAGE.set_name('EAM', 'EAM_NOT_VALID_LOCATOR_ID');

359: select count(*) into l_count
360: from mtl_item_locations
361: where organization_id = p_organization_id and inventory_location_id = l_locator and subinventory_code = l_subinventory;
362: if (l_count = 0) then
363: FND_MESSAGE.set_name('EAM', 'EAM_NOT_VALID_LOCATOR_ID');
364: p_x_return_status := FND_API.G_RET_STS_ERROR;
365: return;
366: end if;
367: end if;

Line 599: FND_MESSAGE.set_name('EAM', 'EAM_INTERNAL_ERROR');

595:
596: -- dbms_output.put_line('caught error in call to eam_completion.complete_work_order');
597: -- dbms_output.put_line('errMsg: '||l_errMsg);
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: FND_MESSAGE.set_name('EAM', 'EAM_INTERNAL_ERROR');
600: end if;
601: end if;
602:
603: if (x_return_status = FND_API.G_RET_STS_ERROR) then

Line 612: -- dbms_output.put_line('unexpected error :'||FND_MESSAGE.get);

608: end if;
609: EXCEPTION
610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
611: -- dbms_output.put_line('unexpected error :'||FND_MSG_PUB.Get);
612: -- dbms_output.put_line('unexpected error :'||FND_MESSAGE.get);
613: ROLLBACK TO Complete_Work_Order_PVT;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: FND_MSG_PUB.Count_And_Get(
616: p_count => x_msg_count,

Line 620: -- dbms_output.put_line('unexpected error :'||FND_MESSAGE.get);

616: p_count => x_msg_count,
617: p_data => x_msg_data);
618: WHEN NO_DATA_FOUND THEN
619: -- dbms_output.put_line('unexpected error :'||FND_MSG_PUB.Get);
620: -- dbms_output.put_line('unexpected error :'||FND_MESSAGE.get);
621: -- dbms_output.put_line('no data found');
622: ROLLBACK TO Complete_Work_Order_PVT;
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: FND_MSG_PUB.Count_And_Get(

Line 629: -- dbms_output.put_line('unexpected error :'||FND_MESSAGE.get);

625: p_count => x_msg_count,
626: p_data => x_msg_data);
627: WHEN OTHERS THEN
628: -- dbms_output.put_line('unexpected error :'||FND_MSG_PUB.Get);
629: -- dbms_output.put_line('unexpected error :'||FND_MESSAGE.get);
630: ROLLBACK TO Complete_Work_Order_PVT;
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
633: FND_MSG_PUB.Add_Exc_Msg(

Line 716: FND_MESSAGE.set_name('EAM', 'EAM_TXN_LATER_THAN_TODAY');

712: if (p_transaction_date is not null) then
713:
714: if p_transaction_date > sysdate then
715:
716: FND_MESSAGE.set_name('EAM', 'EAM_TXN_LATER_THAN_TODAY');
717: FND_MSG_PUB.Add;
718: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_TXN_LATER_THAN_TODAY');
719: x_return_status := FND_API.G_RET_STS_ERROR;
720: end if;

Line 767: FND_MESSAGE.set_name('EAM', 'EAM_INVALID_TXN_TYPE');

763: if (p_operation_seq_num is not NULL) THEN
764:
765: if (l_operation_completed='Y') and (p_transaction_type =1) then
766:
767: FND_MESSAGE.set_name('EAM', 'EAM_INVALID_TXN_TYPE');
768: FND_MSG_PUB.Add;
769: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_INVALID_TXN_TYPE') ;
770: x_return_status := FND_API.G_RET_STS_ERROR;
771:

Line 774: FND_MESSAGE.set_name('EAM', 'EAM_INVALID_TXN_TYPE');

770: x_return_status := FND_API.G_RET_STS_ERROR;
771:
772: elsif ((l_operation_completed <> 'Y') and (p_transaction_type =2)) then
773:
774: FND_MESSAGE.set_name('EAM', 'EAM_INVALID_TXN_TYPE');
775: FND_MSG_PUB.Add;
776: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_INVALID_TXN_TYPE') ;
777: x_return_status := FND_API.G_RET_STS_ERROR;
778:

Line 816: FND_MESSAGE.set_name('EAM', 'EAM_INCORRECT_DURATION');

812: --l_actual_duration := round(24 * (
813: -- to_date(to_char(l_actual_end_date, 'DD-MON-YY HH24:MI:SS'),'DD-MON-YY HH24:MI:SS')
814: -- - to_date(to_char(l_actual_start_date, 'DD-MON-YY HH24:MI:SS'),'DD-MON-YY HH24:MI:SS')), 3);
815: if (p_actual_duration is not null) and (p_actual_duration <> l_actual_duration ) then
816: FND_MESSAGE.set_name('EAM', 'EAM_INCORRECT_DURATION');
817: FND_MSG_PUB.Add;
818: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_INCORRECT_DURATION') ;
819: x_return_status := FND_API.G_RET_STS_ERROR;
820:

Line 834: FND_MESSAGE.set_name('EAM', 'EAM_NEGATIVE_DURATION');

830: ---------------------------------------------------------------------------------
831:
832: if (l_actual_duration is not null) then
833: if l_actual_duration < 0 then
834: FND_MESSAGE.set_name('EAM', 'EAM_NEGATIVE_DURATION');
835: FND_MSG_PUB.Add;
836: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NEGATIVE_DURATION') ;
837: x_return_status := FND_API.G_RET_STS_ERROR;
838:

Line 853: FND_MESSAGE.set_name('EAM', 'EAM_END_LATER_THAN_TODAY');

849:
850: if (l_actual_start_date is not null) then
851:
852: if l_actual_end_date > sysdate then
853: FND_MESSAGE.set_name('EAM', 'EAM_END_LATER_THAN_TODAY');
854: FND_MSG_PUB.Add;
855: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_END_LATER_THAN_TODAY ') ;
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: end if;

Line 860: FND_MESSAGE.set_name('EAM', 'EAM_MIN_OP_ACTUAL_START_DATE');

856: x_return_status := FND_API.G_RET_STS_ERROR;
857: end if;
858:
859: if (l_actual_start_date < l_open_acct_per_date) then
860: FND_MESSAGE.set_name('EAM', 'EAM_MIN_OP_ACTUAL_START_DATE');
861: FND_MSG_PUB.Add;
862: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_MIN_OP_ACTUAL_START_DATE') ;
863: x_return_status := FND_API.G_RET_STS_ERROR;
864:

Line 889: FND_MESSAGE.set_name('EAM', 'EAM_INCORRECT_SHUT_DUR');

885: -- l_shutdown_duration := round(24 * (
886: -- to_date(to_char(l_actual_end_date, 'DD-MON-YY HH24:MI:SS'),'DD-MON-YY HH24:MI:SS')
887: -- - to_date(to_char(l_actual_start_date, 'DD-MON-YY HH24:MI:SS'),'DD-MON-YY HH24:MI:SS')), 3);
888: if (p_shutdown_duration is not null) and (p_shutdown_duration <> l_shutdown_duration ) then
889: FND_MESSAGE.set_name('EAM', 'EAM_INCORRECT_SHUT_DUR');
890: FND_MSG_PUB.Add;
891: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_INCORRECT_SHUT_DUR') ;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893:

Line 908: FND_MESSAGE.set_name('EAM', 'EAM_SHUTDOWN_DUR_NEGATIVE');

904: ---------------------------------------------------------------------------------
905:
906: if (l_shutdown_duration is not null) then
907: if l_shutdown_duration < 0 then
908: FND_MESSAGE.set_name('EAM', 'EAM_SHUTDOWN_DUR_NEGATIVE');
909: FND_MSG_PUB.Add;
910: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_SHUTDOWN_DUR_NEGATIVE') ;
911: x_return_status := FND_API.G_RET_STS_ERROR;
912:

Line 919: FND_MESSAGE.set_name('EAM', 'EAM_SHUT_GREATER_SYSDATE');

915:
916: if (l_shutdown_end_date is not null) then
917:
918: if l_shutdown_end_date > sysdate then
919: FND_MESSAGE.set_name('EAM', 'EAM_SHUT_GREATER_SYSDATE');
920: FND_MSG_PUB.Add;
921: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_SHUT_GREATER_SYSDATE ') ;
922: x_return_status := FND_API.G_RET_STS_ERROR;
923: end if;

Line 936: FND_MESSAGE.set_name('EAM', 'EAM_SHUT_END_BEFORE_START');

932:
933:
934: if ((l_shutdown_start_date is not null) and (l_shutdown_end_date is not null)
935: and (l_shutdown_end_date < l_shutdown_start_date)) then
936: FND_MESSAGE.set_name('EAM', 'EAM_SHUT_END_BEFORE_START');
937: FND_MSG_PUB.Add;
938: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_SHUT_END_BEFORE_START ') ;
939:
940: