DBA Data[Home] [Help]

APPS.WMS_DOCK_APPOINTMENTS_PUB dependencies on FND_MESSAGE

Line 60: FND_MESSAGE.SET_NAME('WMS', 'WMS_TRIP_STOP_NOT_FOUND');

56: EXCEPTION
57: WHEN no_data_found THEN
58: x_return_status := FND_API.G_RET_STS_ERROR;
59:
60: FND_MESSAGE.SET_NAME('WMS', 'WMS_TRIP_STOP_NOT_FOUND');
61: FND_MSG_PUB.ADD;
62:
63: FND_MSG_PUB.Count_And_Get
64: (p_count => x_msg_count,

Line 131: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_UPDATE_FAIL');

127: WHEN OTHERS THEN
128: ROLLBACK TO update_dock_sp;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130:
131: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_UPDATE_FAIL');
132: FND_MSG_PUB.ADD;
133:
134: FND_MSG_PUB.Count_And_Get
135: (p_count => x_msg_count,

Line 199: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_UPDATE_REP_FAIL');

195: WHEN OTHERS THEN
196: ROLLBACK TO update_rep_dock_sp;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198:
199: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_UPDATE_REP_FAIL');
200: FND_MSG_PUB.ADD;
201:
202: FND_MSG_PUB.Count_And_Get
203: (p_count => x_msg_count,

Line 303: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_INSERT_FAIL');

299: WHEN OTHERS THEN
300: ROLLBACK TO insert_dock_sp;
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302:
303: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_INSERT_FAIL');
304: FND_MSG_PUB.ADD;
305:
306: FND_MSG_PUB.Count_And_Get
307: (p_count => x_msg_count,

Line 407: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_INSERT_REP_FAIL');

403: WHEN OTHERS THEN
404: ROLLBACK TO insert_rep_dock_sp;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406:
407: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_INSERT_REP_FAIL');
408: FND_MSG_PUB.ADD;
409:
410: FND_MSG_PUB.Count_And_Get
411: (p_count => x_msg_count,

Line 442: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_DELETE_FAIL');

438: WHEN OTHERS THEN
439: ROLLBACK TO delete_dock_sp;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441:
442: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_DELETE_FAIL');
443: FND_MSG_PUB.ADD;
444:
445: FND_MSG_PUB.Count_And_Get
446: (p_count => x_msg_count,

Line 479: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_DELETE_REP_FAIL');

475: WHEN OTHERS THEN
476: ROLLBACK TO delete_rep_dock_sp;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478:
479: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_DELETE_REP_FAIL');
480: FND_MSG_PUB.ADD;
481:
482: FND_MSG_PUB.Count_And_Get
483: (p_count => x_msg_count,

Line 614: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

610: open c;
611: fetch c into recinfo;
612: if (c%notfound) then
613: close c;
614: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
615: app_exception.raise_exception;
616: end if;
617: close c;
618: if ( ((recinfo.CARRIER_CODE = X_CARRIER_CODE)

Line 652: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

648: OR ((recinfo.SOURCE_LINE_ID is null) AND (X_SOURCE_LINE_ID is null)))
649: ) then
650: null;
651: else
652: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
653: app_exception.raise_exception;
654: end if;
655:
656: for tlinfo in c1 loop

Line 664: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

660: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
661: ) then
662: null;
663: else
664: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
665: app_exception.raise_exception;
666: end if;
667: end if;
668: end loop;

Line 760: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

756: IF (g_debug = 1) THEN
757: print_debug('Failure in get_wms_dock_appointment_range at level'
758: ||l_progress||'.All the attributes passed are NULL', 4);
759: END IF;
760: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
761: fnd_msg_pub.add;
762: RAISE FND_API.G_EXC_ERROR;
763:
764: --Check if organization id is null

Line 770: fnd_message.set_name('INV', 'INV_ITM_MISS_ORG_ID');

766: IF (g_debug = 1) THEN
767: print_debug('Failure in get_wms_dock_appointment_range at level'
768: ||l_progress||'.Organization ID is null', 4);
769: END IF;
770: fnd_message.set_name('INV', 'INV_ITM_MISS_ORG_ID');
771: fnd_msg_pub.add;
772: RAISE FND_API.G_EXC_ERROR;
773:
774: --Check if p_start_date is null

Line 780: fnd_message.set_name('INV', 'INV_EAM_GEN_NULL_START_DATE');

776: IF (g_debug = 1) THEN
777: print_debug('Failure in get_wms_dock_appointment_range at level'
778: ||l_progress||'.p_start_date is null', 4);
779: END IF;
780: fnd_message.set_name('INV', 'INV_EAM_GEN_NULL_START_DATE');
781: fnd_msg_pub.add;
782: RAISE FND_API.G_EXC_ERROR;
783:
784: -- Check if start date is less than end date

Line 900: fnd_message.set_name('WMS','WMS_UNEXPECTED_ERROR');

896: , p_count => x_msg_count
897: , p_data => x_msg_data );
898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900: fnd_message.set_name('WMS','WMS_UNEXPECTED_ERROR');
901: fnd_msg_pub.add;
902: IF (g_debug = 1) THEN
903: print_debug('Unexpected error occured in get_dock_appointment_range at level:'||l_progress, 4);
904: END IF;

Line 911: fnd_message.set_name('WMS','WMS_UNEXPECTED_ERROR');

907: , p_count => x_msg_count
908: , p_data => x_msg_data );
909: WHEN OTHERS THEN
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: fnd_message.set_name('WMS','WMS_UNEXPECTED_ERROR');
912: fnd_msg_pub.add;
913: IF (g_debug = 1) THEN
914: print_debug('Unexpected error occured in get_dock_appointment_range at level:'||l_progress, 4);
915: END IF;

Line 971: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_APPT_PARAM_REQD');

967: IF p_dock_appt_tab(i).Organization_id IS NULL THEN
968: IF g_debug = 1 THEN
969: print_debug('Organization id is required',4);
970: END IF;
971: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_APPT_PARAM_REQD');
972: FND_MESSAGE.SET_TOKEN('PARAM', 'Organization');
973: FND_MSG_PUB.ADD;
974: RAISE FND_API.G_EXC_ERROR;
975: ELSIF p_dock_appt_tab(i).Trip_Stop_id IS NULL THEN

Line 972: FND_MESSAGE.SET_TOKEN('PARAM', 'Organization');

968: IF g_debug = 1 THEN
969: print_debug('Organization id is required',4);
970: END IF;
971: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_APPT_PARAM_REQD');
972: FND_MESSAGE.SET_TOKEN('PARAM', 'Organization');
973: FND_MSG_PUB.ADD;
974: RAISE FND_API.G_EXC_ERROR;
975: ELSIF p_dock_appt_tab(i).Trip_Stop_id IS NULL THEN
976: IF g_debug = 1 THEN

Line 979: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_APPT_PARAM_REQD');

975: ELSIF p_dock_appt_tab(i).Trip_Stop_id IS NULL THEN
976: IF g_debug = 1 THEN
977: print_debug('Trip Stop id is required',4);
978: END IF;
979: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_APPT_PARAM_REQD');
980: FND_MESSAGE.SET_TOKEN('PARAM', 'Trip Stop');
981: FND_MSG_PUB.ADD;
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;

Line 980: FND_MESSAGE.SET_TOKEN('PARAM', 'Trip Stop');

976: IF g_debug = 1 THEN
977: print_debug('Trip Stop id is required',4);
978: END IF;
979: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_APPT_PARAM_REQD');
980: FND_MESSAGE.SET_TOKEN('PARAM', 'Trip Stop');
981: FND_MSG_PUB.ADD;
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984:

Line 992: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_DOCK_DOOR');

988: OR LENGTH(p_dock_appt_tab(i).Dock_Name) <=5) THEN
989: IF g_debug = 1 THEN
990: print_debug('Dock Door Name is Invalid : '||p_dock_appt_tab(i).Dock_Name ,4);
991: END IF;
992: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_DOCK_DOOR');
993: FND_MESSAGE.SET_TOKEN('DOCK_DOOR', p_dock_appt_tab(i).Dock_Name);
994: FND_MSG_PUB.ADD;
995: RAISE FND_API.G_EXC_ERROR;
996: END IF;

Line 993: FND_MESSAGE.SET_TOKEN('DOCK_DOOR', p_dock_appt_tab(i).Dock_Name);

989: IF g_debug = 1 THEN
990: print_debug('Dock Door Name is Invalid : '||p_dock_appt_tab(i).Dock_Name ,4);
991: END IF;
992: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_DOCK_DOOR');
993: FND_MESSAGE.SET_TOKEN('DOCK_DOOR', p_dock_appt_tab(i).Dock_Name);
994: FND_MSG_PUB.ADD;
995: RAISE FND_API.G_EXC_ERROR;
996: END IF;
997:

Line 1015: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_DOCK_DOOR_ORG');

1011: CLOSE Check_Valid_Locator;
1012: IF g_debug = 1 THEN
1013: print_debug('Dock Door is Invalid for this Organization ', 4);
1014: END IF;
1015: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_DOCK_DOOR_ORG');
1016: FND_MESSAGE.SET_TOKEN('DOCK_DOOR', p_dock_appt_tab(i).Dock_Name);
1017: FND_MSG_PUB.ADD;
1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;

Line 1016: FND_MESSAGE.SET_TOKEN('DOCK_DOOR', p_dock_appt_tab(i).Dock_Name);

1012: IF g_debug = 1 THEN
1013: print_debug('Dock Door is Invalid for this Organization ', 4);
1014: END IF;
1015: FND_MESSAGE.SET_NAME('WMS', 'WMS_INVALID_DOCK_DOOR_ORG');
1016: FND_MESSAGE.SET_TOKEN('DOCK_DOOR', p_dock_appt_tab(i).Dock_Name);
1017: FND_MSG_PUB.ADD;
1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1020: CLOSE Check_Valid_Locator;

Line 1026: FND_MESSAGE.SET_NAME('WMS','WMS_INVALID_DATE');

1022: -- End Date/Time should be greater than Start Date/Time
1023: IF p_dock_appt_tab(i).Start_Time > p_dock_appt_tab(i).End_Time
1024: OR p_dock_appt_tab(i).Start_Time < SYSDATE OR p_dock_appt_tab(i).End_Time < SYSDATE
1025: OR trunc(NVL(l_disable_date, p_dock_appt_tab(i).End_Time + 1)) <= trunc(p_dock_appt_tab(i).End_Time) THEN
1026: FND_MESSAGE.SET_NAME('WMS','WMS_INVALID_DATE');
1027: IF g_debug = 1 THEN
1028: print_debug('Invalid Dates entered', 4);
1029: END IF;
1030: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_APPT_DATE_INVALID');

Line 1030: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_APPT_DATE_INVALID');

1026: FND_MESSAGE.SET_NAME('WMS','WMS_INVALID_DATE');
1027: IF g_debug = 1 THEN
1028: print_debug('Invalid Dates entered', 4);
1029: END IF;
1030: FND_MESSAGE.SET_NAME('WMS', 'WMS_DOCK_APPT_DATE_INVALID');
1031: FND_MSG_PUB.ADD;
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;
1034:

Line 1054: FND_MESSAGE.SET_NAME('WMS','WMS_DOCK_APPT_TRIP');

1050: l_dock_appointments_v_rec.last_update_date := SYSDATE;
1051: l_dock_appointments_v_rec.last_update_login := FND_GLOBAL.Login_Id;
1052:
1053: -- Message text "Dock Appt for OTM Trip Stop "
1054: FND_MESSAGE.SET_NAME('WMS','WMS_DOCK_APPT_TRIP');
1055: FND_MESSAGE.SET_TOKEN('TRIP_STOP',p_dock_appt_tab(i).trip_stop_id);
1056: l_msg := FND_MESSAGE.GET;
1057: l_dock_appointments_v_rec.subject := 'OTM Planned Dock Appointment';
1058: l_dock_appointments_v_rec.description := l_msg;

Line 1055: FND_MESSAGE.SET_TOKEN('TRIP_STOP',p_dock_appt_tab(i).trip_stop_id);

1051: l_dock_appointments_v_rec.last_update_login := FND_GLOBAL.Login_Id;
1052:
1053: -- Message text "Dock Appt for OTM Trip Stop "
1054: FND_MESSAGE.SET_NAME('WMS','WMS_DOCK_APPT_TRIP');
1055: FND_MESSAGE.SET_TOKEN('TRIP_STOP',p_dock_appt_tab(i).trip_stop_id);
1056: l_msg := FND_MESSAGE.GET;
1057: l_dock_appointments_v_rec.subject := 'OTM Planned Dock Appointment';
1058: l_dock_appointments_v_rec.description := l_msg;
1059:

Line 1056: l_msg := FND_MESSAGE.GET;

1052:
1053: -- Message text "Dock Appt for OTM Trip Stop "
1054: FND_MESSAGE.SET_NAME('WMS','WMS_DOCK_APPT_TRIP');
1055: FND_MESSAGE.SET_TOKEN('TRIP_STOP',p_dock_appt_tab(i).trip_stop_id);
1056: l_msg := FND_MESSAGE.GET;
1057: l_dock_appointments_v_rec.subject := 'OTM Planned Dock Appointment';
1058: l_dock_appointments_v_rec.description := l_msg;
1059:
1060: IF Get_Appt_Info%NOTFOUND THEN

Line 1077: FND_MESSAGE.SET_NAME('WMS','WMS_DOCK_APPT_TRIP');

1073: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1074: IF g_debug = 1 THEN
1075: print_debug('Unable to create Dock Door appt, return status : '||l_return_status, 4);
1076: END IF;
1077: FND_MESSAGE.SET_NAME('WMS','WMS_DOCK_APPT_TRIP');
1078: FND_MSG_PUB.ADD;
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081: ELSE

Line 1094: FND_MESSAGE.SET_NAME('WMS','WMS_DOCK_APPT_TRIP');

1090: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1091: IF g_debug = 1 THEN
1092: print_debug('Unable to update Dock Door appt, return status : '||l_return_status, 4);
1093: END IF;
1094: FND_MESSAGE.SET_NAME('WMS','WMS_DOCK_APPT_TRIP');
1095: FND_MSG_PUB.ADD;
1096: RAISE FND_API.G_EXC_ERROR;
1097: END IF;
1098: END IF;

Line 1118: FND_MESSAGE.SET_NAME('WMS','WMS_DOCK_APPT_TRIP');

1114: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1115: IF g_debug = 1 THEN
1116: print_debug('Unable to delete Dock Door appt, return status : '||l_return_status, 4);
1117: END IF;
1118: FND_MESSAGE.SET_NAME('WMS','WMS_DOCK_APPT_TRIP');
1119: FND_MSG_PUB.ADD;
1120: RAISE FND_API.G_EXC_ERROR;
1121: END IF;
1122: END IF;