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 281: FND_MESSAGE.set_name('EAM', 'EAM_INVENTORY_NULL');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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