APPS.FTE_WSH_TRIPS_PVT dependencies on FND_API

Line 12: if (p_return_status = null or p_return_status = FND_API.G_MISS_CHAR) then

8: x_return_status IN OUT NOCOPY VARCHAR2
9: ) is
10: begin
11:
12: if (p_return_status = null or p_return_status = FND_API.G_MISS_CHAR) then
13: return;
14: end if;
15:
16: if (p_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

Line 23: if (x_return_status = null or x_return_status = FND_API.G_MISS_CHAR) then

19: and p_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) then
20: return;
21: end if;
22:
23: if (x_return_status = null or x_return_status = FND_API.G_MISS_CHAR) then
24: x_return_status := p_return_status;
25: return;
26: end if;
27:

Line 155: if (p_sequence = null or p_sequence = FND_API.G_MISS_NUM) then

151: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
152:
153: --validate sequence
154:
155: if (p_sequence = null or p_sequence = FND_API.G_MISS_NUM) then
156: RAISE empty_sequence;
157: end if;
158:
159: OPEN check_sequence(p_fte_trip_id, p_sequence);

Line 757: decode(p_trip_info.FTE_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.FTE_TRIP_ID),

753: ATTRIBUTE15
754: )
755: values
756: (
757: decode(p_trip_info.FTE_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.FTE_TRIP_ID),
758: decode(p_trip_info.WSH_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.WSH_TRIP_ID),
759: decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
760: decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
761: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),

Line 758: decode(p_trip_info.WSH_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.WSH_TRIP_ID),

754: )
755: values
756: (
757: decode(p_trip_info.FTE_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.FTE_TRIP_ID),
758: decode(p_trip_info.WSH_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.WSH_TRIP_ID),
759: decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
760: decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
761: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
762: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),

Line 759: decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),

755: values
756: (
757: decode(p_trip_info.FTE_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.FTE_TRIP_ID),
758: decode(p_trip_info.WSH_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.WSH_TRIP_ID),
759: decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
760: decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
761: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
762: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
763: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),

Line 760: decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),

756: (
757: decode(p_trip_info.FTE_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.FTE_TRIP_ID),
758: decode(p_trip_info.WSH_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.WSH_TRIP_ID),
759: decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
760: decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
761: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
762: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
763: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
764: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),

Line 761: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),

757: decode(p_trip_info.FTE_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.FTE_TRIP_ID),
758: decode(p_trip_info.WSH_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.WSH_TRIP_ID),
759: decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
760: decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
761: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
762: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
763: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
764: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
765: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),

Line 762: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),

758: decode(p_trip_info.WSH_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.WSH_TRIP_ID),
759: decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
760: decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
761: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
762: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
763: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
764: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
765: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
766: decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),

Line 763: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),

759: decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
760: decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
761: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
762: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
763: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
764: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
765: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
766: decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
767: decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),

Line 764: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),

760: decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
761: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
762: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
763: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
764: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
765: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
766: decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
767: decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
768: decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),

Line 765: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),

761: decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
762: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
763: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
764: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
765: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
766: decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
767: decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
768: decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
769: decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),

Line 766: decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),

762: decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
763: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
764: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
765: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
766: decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
767: decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
768: decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
769: decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
770: decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),

Line 767: decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),

763: decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
764: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
765: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
766: decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
767: decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
768: decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
769: decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
770: decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
771: decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),

Line 768: decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),

764: decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
765: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
766: decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
767: decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
768: decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
769: decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
770: decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
771: decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
772: decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),

Line 769: decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),

765: decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
766: decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
767: decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
768: decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
769: decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
770: decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
771: decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
772: decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
773: decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),

Line 770: decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),

766: decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
767: decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
768: decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
769: decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
770: decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
771: decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
772: decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
773: decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
774: decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),

Line 771: decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),

767: decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
768: decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
769: decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
770: decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
771: decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
772: decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
773: decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
774: decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
775: decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),

Line 772: decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),

768: decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
769: decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
770: decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
771: decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
772: decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
773: decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
774: decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
775: decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
776: decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),

Line 773: decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),

769: decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
770: decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
771: decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
772: decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
773: decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
774: decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
775: decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
776: decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
777: decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),

Line 774: decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),

770: decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
771: decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
772: decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
773: decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
774: decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
775: decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
776: decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
777: decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
778: decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),

Line 775: decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),

771: decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
772: decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
773: decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
774: decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
775: decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
776: decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
777: decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
778: decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
779: decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),

Line 776: decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),

772: decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
773: decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
774: decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
775: decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
776: decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
777: decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
778: decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
779: decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
780: decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),

Line 777: decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),

773: decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
774: decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
775: decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
776: decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
777: decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
778: decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
779: decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
780: decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
781: decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),

Line 778: decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),

774: decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
775: decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
776: decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
777: decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
778: decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
779: decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
780: decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
781: decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
782: decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),

Line 779: decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),

775: decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
776: decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
777: decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
778: decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
779: decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
780: decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
781: decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
782: decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
783: decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),

Line 780: decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),

776: decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
777: decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
778: decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
779: decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
780: decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
781: decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
782: decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
783: decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
784: decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)

Line 781: decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),

777: decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
778: decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
779: decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
780: decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
781: decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
782: decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
783: decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
784: decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)
785: );

Line 782: decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),

778: decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
779: decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
780: decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
781: decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
782: decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
783: decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
784: decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)
785: );
786:

Line 783: decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),

779: decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
780: decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
781: decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
782: decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
783: decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
784: decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)
785: );
786:
787: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 784: decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)

780: decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
781: decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
782: decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
783: decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
784: decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)
785: );
786:
787: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
788:

Line 845: SEQUENCE_NUMBER = decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),

841:
842: end if;
843:
844: update fte_wsh_trips set
845: SEQUENCE_NUMBER = decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
846: creation_date = decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
847: created_by = decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
848: last_update_date = decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
849: last_updated_by = decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),

Line 846: creation_date = decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),

842: end if;
843:
844: update fte_wsh_trips set
845: SEQUENCE_NUMBER = decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
846: creation_date = decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
847: created_by = decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
848: last_update_date = decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
849: last_updated_by = decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
850: last_update_login = decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),

Line 847: created_by = decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),

843:
844: update fte_wsh_trips set
845: SEQUENCE_NUMBER = decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
846: creation_date = decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
847: created_by = decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
848: last_update_date = decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
849: last_updated_by = decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
850: last_update_login = decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
851: program_application_id = decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),

Line 848: last_update_date = decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),

844: update fte_wsh_trips set
845: SEQUENCE_NUMBER = decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
846: creation_date = decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
847: created_by = decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
848: last_update_date = decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
849: last_updated_by = decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
850: last_update_login = decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
851: program_application_id = decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
852: program_id = decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),

Line 849: last_updated_by = decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),

845: SEQUENCE_NUMBER = decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
846: creation_date = decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
847: created_by = decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
848: last_update_date = decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
849: last_updated_by = decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
850: last_update_login = decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
851: program_application_id = decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
852: program_id = decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
853: program_update_date = decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),

Line 850: last_update_login = decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),

846: creation_date = decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
847: created_by = decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
848: last_update_date = decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
849: last_updated_by = decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
850: last_update_login = decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
851: program_application_id = decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
852: program_id = decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
853: program_update_date = decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
854: request_id = decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),

Line 851: program_application_id = decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),

847: created_by = decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
848: last_update_date = decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
849: last_updated_by = decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
850: last_update_login = decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
851: program_application_id = decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
852: program_id = decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
853: program_update_date = decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
854: request_id = decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
855: attribute_category = decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),

Line 852: program_id = decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),

848: last_update_date = decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
849: last_updated_by = decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
850: last_update_login = decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
851: program_application_id = decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
852: program_id = decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
853: program_update_date = decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
854: request_id = decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
855: attribute_category = decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
856: attribute1 = decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),

Line 853: program_update_date = decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),

849: last_updated_by = decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
850: last_update_login = decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
851: program_application_id = decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
852: program_id = decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
853: program_update_date = decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
854: request_id = decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
855: attribute_category = decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
856: attribute1 = decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
857: attribute2 = decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),

Line 854: request_id = decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),

850: last_update_login = decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
851: program_application_id = decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
852: program_id = decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
853: program_update_date = decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
854: request_id = decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
855: attribute_category = decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
856: attribute1 = decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
857: attribute2 = decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
858: attribute3 = decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),

Line 855: attribute_category = decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),

851: program_application_id = decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
852: program_id = decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
853: program_update_date = decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
854: request_id = decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
855: attribute_category = decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
856: attribute1 = decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
857: attribute2 = decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
858: attribute3 = decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
859: attribute4 = decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),

Line 856: attribute1 = decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),

852: program_id = decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
853: program_update_date = decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
854: request_id = decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
855: attribute_category = decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
856: attribute1 = decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
857: attribute2 = decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
858: attribute3 = decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
859: attribute4 = decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
860: attribute5 = decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),

Line 857: attribute2 = decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),

853: program_update_date = decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
854: request_id = decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
855: attribute_category = decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
856: attribute1 = decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
857: attribute2 = decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
858: attribute3 = decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
859: attribute4 = decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
860: attribute5 = decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
861: attribute6 = decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),

Line 858: attribute3 = decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),

854: request_id = decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
855: attribute_category = decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
856: attribute1 = decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
857: attribute2 = decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
858: attribute3 = decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
859: attribute4 = decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
860: attribute5 = decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
861: attribute6 = decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
862: attribute7 = decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),

Line 859: attribute4 = decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),

855: attribute_category = decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
856: attribute1 = decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
857: attribute2 = decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
858: attribute3 = decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
859: attribute4 = decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
860: attribute5 = decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
861: attribute6 = decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
862: attribute7 = decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
863: attribute8 = decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),

Line 860: attribute5 = decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),

856: attribute1 = decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
857: attribute2 = decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
858: attribute3 = decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
859: attribute4 = decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
860: attribute5 = decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
861: attribute6 = decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
862: attribute7 = decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
863: attribute8 = decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
864: attribute9 = decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),

Line 861: attribute6 = decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),

857: attribute2 = decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
858: attribute3 = decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
859: attribute4 = decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
860: attribute5 = decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
861: attribute6 = decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
862: attribute7 = decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
863: attribute8 = decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
864: attribute9 = decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
865: attribute10 = decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),

Line 862: attribute7 = decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),

858: attribute3 = decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
859: attribute4 = decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
860: attribute5 = decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
861: attribute6 = decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
862: attribute7 = decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
863: attribute8 = decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
864: attribute9 = decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
865: attribute10 = decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
866: attribute11 = decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),

Line 863: attribute8 = decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),

859: attribute4 = decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
860: attribute5 = decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
861: attribute6 = decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
862: attribute7 = decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
863: attribute8 = decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
864: attribute9 = decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
865: attribute10 = decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
866: attribute11 = decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
867: attribute12 = decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),

Line 864: attribute9 = decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),

860: attribute5 = decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
861: attribute6 = decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
862: attribute7 = decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
863: attribute8 = decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
864: attribute9 = decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
865: attribute10 = decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
866: attribute11 = decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
867: attribute12 = decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
868: attribute13 = decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),

Line 865: attribute10 = decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),

861: attribute6 = decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
862: attribute7 = decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
863: attribute8 = decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
864: attribute9 = decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
865: attribute10 = decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
866: attribute11 = decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
867: attribute12 = decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
868: attribute13 = decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
869: attribute14 = decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),

Line 866: attribute11 = decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),

862: attribute7 = decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
863: attribute8 = decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
864: attribute9 = decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
865: attribute10 = decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
866: attribute11 = decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
867: attribute12 = decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
868: attribute13 = decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
869: attribute14 = decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
870: attribute15 = decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)

Line 867: attribute12 = decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),

863: attribute8 = decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
864: attribute9 = decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
865: attribute10 = decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
866: attribute11 = decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
867: attribute12 = decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
868: attribute13 = decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
869: attribute14 = decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
870: attribute15 = decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)
871: where fte_trip_id = p_trip_info.fte_trip_id and wsh_trip_id = p_trip_info.wsh_trip_id;

Line 868: attribute13 = decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),

864: attribute9 = decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
865: attribute10 = decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
866: attribute11 = decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
867: attribute12 = decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
868: attribute13 = decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
869: attribute14 = decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
870: attribute15 = decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)
871: where fte_trip_id = p_trip_info.fte_trip_id and wsh_trip_id = p_trip_info.wsh_trip_id;
872:

Line 869: attribute14 = decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),

865: attribute10 = decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
866: attribute11 = decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
867: attribute12 = decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
868: attribute13 = decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
869: attribute14 = decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
870: attribute15 = decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)
871: where fte_trip_id = p_trip_info.fte_trip_id and wsh_trip_id = p_trip_info.wsh_trip_id;
872:
873: if (SQL%NOTFOUND) then

Line 870: attribute15 = decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)

866: attribute11 = decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
867: attribute12 = decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
868: attribute13 = decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
869: attribute14 = decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
870: attribute15 = decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15)
871: where fte_trip_id = p_trip_info.fte_trip_id and wsh_trip_id = p_trip_info.wsh_trip_id;
872:
873: if (SQL%NOTFOUND) then
874: RAISE no_trip_found;

Line 900: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

896: --
897:
898: PROCEDURE Validate_Trip_For_Delete
899: (
900: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
901: p_fte_trip_id IN NUMBER,
902: p_wsh_trip_id IN NUMBER,
903: x_msg_count OUT NOCOPY NUMBER,
904: x_msg_data OUT NOCOPY VARCHAR2,

Line 927: IF FND_API.to_Boolean( p_init_msg_list )

923: --
924: -- Initialize message list if p_init_msg_list is set to TRUE.
925: --
926: --
927: IF FND_API.to_Boolean( p_init_msg_list )
928: THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931:

Line 965: , p_encoded => FND_API.G_FALSE

961: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
962: FND_MSG_PUB.Count_And_Get
963: ( p_count => x_msg_count
964: , p_data => x_msg_data
965: , p_encoded => FND_API.G_FALSE
966: );
967: RETURN;
968: END IF;
969:

Line 1003: , p_encoded => FND_API.G_FALSE

999: );
1000: FND_MSG_PUB.Count_And_Get
1001: ( p_count => x_msg_count
1002: , p_data => x_msg_data
1003: , p_encoded => FND_API.G_FALSE
1004: );
1005: RETURN;
1006: END IF;
1007:

Line 1029: , p_encoded => FND_API.G_FALSE

1025: );
1026: FND_MSG_PUB.Count_And_Get
1027: ( p_count => x_msg_count
1028: , p_data => x_msg_data
1029: , p_encoded => FND_API.G_FALSE
1030: );
1031: RETURN;
1032: END IF;
1033:

Line 1052: , p_encoded => FND_API.G_FALSE

1048:
1049: FND_MSG_PUB.Count_And_Get
1050: ( p_count => x_msg_count
1051: , p_data => x_msg_data
1052: , p_encoded => FND_API.G_FALSE
1053: );
1054:
1055: EXCEPTION
1056: WHEN invalid_trip_status THEN

Line 1064: , p_encoded => FND_API.G_FALSE

1060: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1061: FND_MSG_PUB.Count_And_Get
1062: ( p_count => x_msg_count
1063: , p_data => x_msg_data
1064: , p_encoded => FND_API.G_FALSE
1065: );
1066: WHEN others THEN
1067: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip_For_Delete');
1068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1073: , p_encoded => FND_API.G_FALSE

1069: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1070: FND_MSG_PUB.Count_And_Get
1071: ( p_count => x_msg_count
1072: , p_data => x_msg_data
1073: , p_encoded => FND_API.G_FALSE
1074: );
1075:
1076: END Validate_Trip_For_Delete;
1077:

Line 1088: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1084: --
1085:
1086: PROCEDURE Delete_Trip
1087: (
1088: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1089: p_fte_trip_id IN NUMBER,
1090: p_wsh_trip_id IN NUMBER,
1091: x_msg_count OUT NOCOPY NUMBER,
1092: x_msg_data OUT NOCOPY VARCHAR2,

Line 1108: IF FND_API.to_Boolean( p_init_msg_list )

1104: --
1105: -- Initialize message list if p_init_msg_list is set to TRUE.
1106: --
1107: --
1108: IF FND_API.to_Boolean( p_init_msg_list )
1109: THEN
1110: FND_MSG_PUB.initialize;
1111: END IF;
1112:

Line 1128: , p_encoded => FND_API.G_FALSE

1124: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1125: FND_MSG_PUB.Count_And_Get
1126: ( p_count => x_msg_count
1127: , p_data => x_msg_data
1128: , p_encoded => FND_API.G_FALSE
1129: );
1130: RETURN;
1131: END IF;
1132:

Line 1150: , p_encoded => FND_API.G_FALSE

1146:
1147: FND_MSG_PUB.Count_And_Get
1148: ( p_count => x_msg_count
1149: , p_data => x_msg_data
1150: , p_encoded => FND_API.G_FALSE
1151: );
1152:
1153: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
1154: wsh_debug_sv.dpop (c_sdebug);

Line 1166: , p_encoded => FND_API.G_FALSE

1162: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1163: FND_MSG_PUB.Count_And_Get
1164: ( p_count => x_msg_count
1165: , p_data => x_msg_data
1166: , p_encoded => FND_API.G_FALSE
1167: );
1168: WHEN others THEN
1169: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Delete_Trip');
1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1175: , p_encoded => FND_API.G_FALSE

1171: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1172: FND_MSG_PUB.Count_And_Get
1173: ( p_count => x_msg_count
1174: , p_data => x_msg_data
1175: , p_encoded => FND_API.G_FALSE
1176: );
1177:
1178: END Delete_Trip;
1179:

Line 1188: pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1184: --
1185:
1186: PROCEDURE Validate_Trip_Wrapper
1187: (
1188: pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1189: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1190: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1191: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1192: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1189: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1185:
1186: PROCEDURE Validate_Trip_Wrapper
1187: (
1188: pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1189: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1190: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1191: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1192: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1193: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 1190: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1186: PROCEDURE Validate_Trip_Wrapper
1187: (
1188: pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1189: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1190: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1191: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1192: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1193: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1194: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1191: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

1187: (
1188: pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1189: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1190: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1191: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1192: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1193: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1194: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1195: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1192: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1188: pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1189: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1190: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1191: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1192: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1193: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1194: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1195: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1196: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1193: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

1189: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1190: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1191: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1192: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1193: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1194: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1195: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1196: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1197: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1194: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1190: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1191: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1192: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1193: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1194: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1195: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1196: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1197: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1198: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 1195: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1191: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1192: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1193: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1194: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1195: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1196: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1197: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1198: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1199: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1196: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1192: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1193: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1194: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1195: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1196: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1197: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1198: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1199: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1200: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1197: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1193: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1194: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1195: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1196: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1197: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1198: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1199: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1200: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1201: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1198: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

1194: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1195: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1196: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1197: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1198: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1199: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1200: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1201: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1202: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1199: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1195: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1196: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1197: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1198: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1199: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1200: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1201: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1202: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1203: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1200: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1196: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1197: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1198: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1199: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1200: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1201: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1202: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1203: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1204: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1201: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1197: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1198: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1199: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1200: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1201: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1202: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1203: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1204: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1205: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1202: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1198: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1199: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1200: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1201: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1202: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1203: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1204: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1205: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1206: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1203: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1199: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1200: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1201: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1202: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1203: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1204: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1205: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1206: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1207: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1204: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1200: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1201: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1202: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1203: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1204: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1205: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1206: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1207: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1208: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1205: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1201: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1202: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1203: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1204: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1205: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1206: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1207: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1208: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1209: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1206: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1202: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1203: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1204: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1205: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1206: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1207: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1208: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1209: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1210: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1207: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1203: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1204: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1205: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1206: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1207: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1208: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1209: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1210: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1211: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1208: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1204: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1205: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1206: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1207: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1208: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1209: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1210: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1211: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1212: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1209: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1205: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1206: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1207: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1208: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1209: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1210: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1211: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1212: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1213: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1210: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1206: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1207: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1208: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1209: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1210: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1211: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1212: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1213: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1214: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1211: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1207: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1208: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1209: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1210: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1211: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1212: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1213: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1214: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1215: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1212: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1208: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1209: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1210: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1211: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1212: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1213: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1214: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1215: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1216: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1213: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1209: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1210: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1211: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1212: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1213: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1214: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1215: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1216: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1217: p_action_code IN VARCHAR2,

Line 1214: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1210: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1211: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1212: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1213: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1214: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1215: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1216: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1217: p_action_code IN VARCHAR2,
1218: x_msg_count OUT NOCOPY NUMBER,

Line 1215: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1211: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1212: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1213: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1214: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1215: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1216: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1217: p_action_code IN VARCHAR2,
1218: x_msg_count OUT NOCOPY NUMBER,
1219: x_msg_data OUT NOCOPY VARCHAR2,

Line 1216: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1212: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1213: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1214: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1215: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1216: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1217: p_action_code IN VARCHAR2,
1218: x_msg_count OUT NOCOPY NUMBER,
1219: x_msg_data OUT NOCOPY VARCHAR2,
1220: x_return_status OUT NOCOPY VARCHAR2

Line 1234: IF FND_API.to_Boolean( p_init_msg_list )

1230: --
1231: -- Initialize message list if p_init_msg_list is set to TRUE.
1232: --
1233: --
1234: IF FND_API.to_Boolean( p_init_msg_list )
1235: THEN
1236: FND_MSG_PUB.initialize;
1237: END IF;
1238:

Line 1293: , p_encoded => FND_API.G_FALSE

1289:
1290: FND_MSG_PUB.Count_And_Get
1291: ( p_count => x_msg_count
1292: , p_data => x_msg_data
1293: , p_encoded => FND_API.G_FALSE
1294: );
1295:
1296: EXCEPTION
1297: WHEN invalid_action THEN

Line 1305: , p_encoded => FND_API.G_FALSE

1301: wsh_util_core.add_message(x_return_status);
1302: FND_MSG_PUB.Count_And_Get
1303: ( p_count => x_msg_count
1304: , p_data => x_msg_data
1305: , p_encoded => FND_API.G_FALSE
1306: );
1307: WHEN others THEN
1308: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip_Wrapper');
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1305: , p_encoded => FND_API.G_FALSE
1306: );
1307: WHEN others THEN
1308: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip_Wrapper');
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1310: wsh_util_core.add_message(x_return_status);
1311: FND_MSG_PUB.Count_And_Get
1312: ( p_count => x_msg_count
1313: , p_data => x_msg_data

Line 1314: , p_encoded => FND_API.G_FALSE

1310: wsh_util_core.add_message(x_return_status);
1311: FND_MSG_PUB.Count_And_Get
1312: ( p_count => x_msg_count
1313: , p_data => x_msg_data
1314: , p_encoded => FND_API.G_FALSE
1315: );
1316:
1317: END Validate_Trip_Wrapper;
1318:

Line 1327: pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1323: --
1324:
1325: PROCEDURE Create_Update_Trip_Wrapper
1326: (
1327: pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1328: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1329: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1330: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1331: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1328: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1324:
1325: PROCEDURE Create_Update_Trip_Wrapper
1326: (
1327: pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1328: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1329: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1330: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1331: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1332: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 1329: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1325: PROCEDURE Create_Update_Trip_Wrapper
1326: (
1327: pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1328: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1329: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1330: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1331: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1332: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1333: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1330: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

1326: (
1327: pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1328: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1329: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1330: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1331: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1332: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1333: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1334: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1331: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1327: pp_FTE_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1328: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1329: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1330: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1331: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1332: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1333: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1334: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1335: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1332: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

1328: pp_WSH_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1329: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1330: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1331: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1332: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1333: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1334: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1335: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1336: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1333: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1329: pp_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1330: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1331: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1332: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1333: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1334: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1335: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1336: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1337: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 1334: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1330: pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1331: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1332: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1333: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1334: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1335: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1336: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1337: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1338: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 1335: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1331: pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1332: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1333: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1334: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1335: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1336: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1337: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1338: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1339: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1336: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1332: pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1333: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1334: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1335: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1336: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1337: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1338: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1339: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1340: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1337: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,

1333: pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1334: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1335: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1336: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1337: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1338: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1339: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1340: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1341: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1338: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1334: pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1335: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1336: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1337: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1338: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1339: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1340: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1341: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1342: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1339: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1335: pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1336: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1337: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1338: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1339: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1340: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1341: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1342: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1343: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1340: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1336: pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1337: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1338: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1339: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1340: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1341: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1342: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1343: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1344: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1341: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1337: pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
1338: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1339: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1340: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1341: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1342: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1343: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1344: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1345: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1342: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1338: pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1339: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1340: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1341: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1342: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1343: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1344: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1345: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1346: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1343: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1339: pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1340: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1341: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1342: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1343: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1344: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1345: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1346: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1347: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1344: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1340: pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1341: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1342: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1343: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1344: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1345: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1346: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1347: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1348: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1345: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1341: pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1342: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1343: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1344: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1345: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1346: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1347: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1348: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1349: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1346: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1342: pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1343: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1344: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1345: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1346: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1347: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1348: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1349: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1350: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1347: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1343: pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1344: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1345: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1346: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1347: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1348: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1349: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1350: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1351: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1348: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1344: pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1345: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1346: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1347: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1348: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1349: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1350: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1351: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1352: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1349: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1345: pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1346: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1347: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1348: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1349: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1350: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1351: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1352: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1353: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1350: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1346: pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1347: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1348: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1349: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1350: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1351: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1352: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1353: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1354: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 1351: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1347: pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1348: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1349: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1350: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1351: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1352: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1353: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1354: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1355: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 1352: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1348: pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1349: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1350: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1351: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1352: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1353: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1354: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1355: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1356: p_action_code IN VARCHAR2,

Line 1353: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1349: pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1350: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1351: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1352: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1353: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1354: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1355: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1356: p_action_code IN VARCHAR2,
1357: p_validate_flag IN VARCHAR2,

Line 1354: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

1350: pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1351: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1352: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1353: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1354: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1355: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1356: p_action_code IN VARCHAR2,
1357: p_validate_flag IN VARCHAR2,
1358: x_msg_count OUT NOCOPY NUMBER,

Line 1355: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1351: pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1352: pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1353: pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1354: pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
1355: P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1356: p_action_code IN VARCHAR2,
1357: p_validate_flag IN VARCHAR2,
1358: x_msg_count OUT NOCOPY NUMBER,
1359: x_msg_data OUT NOCOPY VARCHAR2,

Line 1382: IF FND_API.to_Boolean( p_init_msg_list )

1378: --
1379: -- Initialize message list if p_init_msg_list is set to TRUE.
1380: --
1381: --
1382: IF FND_API.to_Boolean( p_init_msg_list )
1383: THEN
1384: FND_MSG_PUB.initialize;
1385: END IF;
1386:

Line 1440: , p_encoded => FND_API.G_FALSE

1436:
1437: FND_MSG_PUB.Count_And_Get
1438: ( p_count => x_msg_count
1439: , p_data => x_msg_data
1440: , p_encoded => FND_API.G_FALSE
1441: );
1442:
1443: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
1444: wsh_debug_sv.dpop (c_sdebug);

Line 1456: , p_encoded => FND_API.G_FALSE

1452: wsh_util_core.add_message(x_return_status);
1453: FND_MSG_PUB.Count_And_Get
1454: ( p_count => x_msg_count
1455: , p_data => x_msg_data
1456: , p_encoded => FND_API.G_FALSE
1457: );
1458:
1459: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
1460: wsh_debug_sv.dpop (c_sdebug);

Line 1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1461: wsh_debug_sv.stop_debug;
1462:
1463: WHEN others THEN
1464: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Create_Update_Trip_Wrapper');
1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1466: wsh_util_core.add_message(x_return_status);
1467: FND_MSG_PUB.Count_And_Get
1468: ( p_count => x_msg_count
1469: , p_data => x_msg_data

Line 1470: , p_encoded => FND_API.G_FALSE

1466: wsh_util_core.add_message(x_return_status);
1467: FND_MSG_PUB.Count_And_Get
1468: ( p_count => x_msg_count
1469: , p_data => x_msg_data
1470: , p_encoded => FND_API.G_FALSE
1471: );
1472:
1473: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
1474: wsh_debug_sv.dpop (c_sdebug);