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.WMS_DOCK_APPOINTMENTS_PUB dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.ADD;

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,
65: p_data => x_msg_data

Line 63: FND_MSG_PUB.Count_And_Get

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,
65: p_data => x_msg_data
66: );
67:

Line 132: FND_MSG_PUB.ADD;

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,
136: p_data => x_msg_data

Line 134: FND_MSG_PUB.Count_And_Get

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,
136: p_data => x_msg_data
137: );
138:

Line 200: FND_MSG_PUB.ADD;

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,
204: p_data => x_msg_data

Line 202: FND_MSG_PUB.Count_And_Get

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,
204: p_data => x_msg_data
205: );
206:

Line 304: FND_MSG_PUB.ADD;

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,
308: p_data => x_msg_data

Line 306: FND_MSG_PUB.Count_And_Get

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,
308: p_data => x_msg_data
309: );
310: END insert_dock_appointment;

Line 408: FND_MSG_PUB.ADD;

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,
412: p_data => x_msg_data

Line 410: FND_MSG_PUB.Count_And_Get

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,
412: p_data => x_msg_data
413: );
414: END insert_rep_dock_appointments;

Line 443: FND_MSG_PUB.ADD;

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,
447: p_data => x_msg_data

Line 445: FND_MSG_PUB.Count_And_Get

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,
447: p_data => x_msg_data
448: );
449: END delete_dock_appointment;

Line 480: FND_MSG_PUB.ADD;

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,
484: p_data => x_msg_data

Line 482: FND_MSG_PUB.Count_And_Get

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,
484: p_data => x_msg_data
485: );
486: END delete_rep_dock_appointment;

Line 716: fnd_msg_pub.initialize;

712: x_return_status := FND_API.G_RET_STS_SUCCESS;
713:
714: -- Initialize message list to clear any existing messages if p_init_msg_list is set to TRUE
715: IF fnd_api.To_Boolean(p_init_msg_list) THEN
716: fnd_msg_pub.initialize;
717: END IF;
718:
719: l_progress := 20;
720:

Line 761: fnd_msg_pub.add;

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
765: ELSIF( p_organization_id IS NULL ) THEN

Line 771: fnd_msg_pub.add;

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
775: ELSIF( p_start_date IS NULL ) THEN

Line 781: fnd_msg_pub.add;

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
785: ELSIF( p_end_date is not null AND p_start_date > p_end_date ) THEN

Line 894: fnd_msg_pub.count_and_get (

890: x_return_status := FND_API.G_RET_STS_ERROR;
891: IF (g_debug = 1) THEN
892: print_debug('Execution error occured in get_dock_appointment_range at level:'||l_progress, 4);
893: END IF;
894: fnd_msg_pub.count_and_get (
895: p_encoded => FND_API.G_FALSE
896: , p_count => x_msg_count
897: , p_data => x_msg_data );
898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 901: fnd_msg_pub.add;

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;
905: fnd_msg_pub.count_and_get (

Line 905: fnd_msg_pub.count_and_get (

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;
905: fnd_msg_pub.count_and_get (
906: p_encoded => FND_API.G_FALSE
907: , p_count => x_msg_count
908: , p_data => x_msg_data );
909: WHEN OTHERS THEN

Line 912: fnd_msg_pub.add;

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;
916: fnd_msg_pub.count_and_get (

Line 916: fnd_msg_pub.count_and_get (

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;
916: fnd_msg_pub.count_and_get (
917: p_encoded => FND_API.G_FALSE
918: , p_count => x_msg_count
919: , p_data => x_msg_data );
920: END get_dock_appointment_range;

Line 973: FND_MSG_PUB.ADD;

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
977: print_debug('Trip Stop id is required',4);

Line 981: FND_MSG_PUB.ADD;

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:
985: -- Check for Valid dock name

Line 994: FND_MSG_PUB.ADD;

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:
998: -- Extract Locator_id from Dock Name and validate the locator

Line 1017: FND_MSG_PUB.ADD;

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;
1021:

Line 1031: FND_MSG_PUB.ADD;

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:
1035: -- Check if appointment exists for the Locator

Line 1078: FND_MSG_PUB.ADD;

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
1082: IF g_debug = 1 THEN

Line 1095: FND_MSG_PUB.ADD;

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;
1099: CLOSE Get_Appt_Info;

Line 1119: FND_MSG_PUB.ADD;

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;
1123: END IF;

Line 1144: FND_MSG_PUB.Count_And_Get

1140: IF g_debug = 1 THEN
1141: print_debug('Expected error occurred, Exiting OTM_Dock_Door_Appointment API', 4);
1142: END IF;
1143: x_return_status := FND_API.G_RET_STS_ERROR;
1144: FND_MSG_PUB.Count_And_Get
1145: (p_count => x_msg_count,
1146: p_data => x_msg_data);
1147: WHEN OTHERS THEN
1148: ROLLBACK TO OTM_DOCK_SP;

Line 1160: FND_MSG_PUB.Count_And_Get

1156: print_debug('Unexpected error occurred, Exiting OTM_Dock_Door_Appointment API', 4);
1157: print_debug(SQLERRM, 4);
1158: END IF;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1160: FND_MSG_PUB.Count_And_Get
1161: (p_count => x_msg_count,
1162: p_data => x_msg_data);
1163: END OTM_Dock_Appointment;
1164: