eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_MOVES_PVT dependencies on FND_API

Line 19: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

15: -- COMMENT :
16: --========================================================================
17:
18: PROCEDURE CREATE_MOVE(
19: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20: p_move_info IN MOVE_REC_TYPE,
21: x_move_id OUT NOCOPY NUMBER,
22: x_return_status OUT NOCOPY VARCHAR2
23: ) IS

Line 37: IF FND_API.to_Boolean( p_init_msg_list )

33: BEGIN
34:
35: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
36:
37: IF FND_API.to_Boolean( p_init_msg_list )
38: THEN
39: FND_MSG_PUB.initialize;
40: END IF;
41:

Line 44: p_move_info.move_type_code = FND_API.G_MISS_CHAR) then

40: END IF;
41:
42:
43: if (p_move_info.move_type_code IS NULL or
44: p_move_info.move_type_code = FND_API.G_MISS_CHAR) then
45: RAISE EMPTY_MOVE_TYPE_CODE;
46: end if;
47:
48:

Line 50: p_move_info.PLANNED_FLAG = FND_API.G_MISS_CHAR) then

46: end if;
47:
48:
49: if (p_move_info.PLANNED_FLAG IS null or
50: p_move_info.PLANNED_FLAG = FND_API.G_MISS_CHAR) then
51: RAISE EMPTY_PLANNED_FLAG;
52: end if;
53:
54: OPEN get_next_move;

Line 81: decode(p_move_info.LANE_ID,FND_API.G_MISS_NUM,NULL,p_move_info.LANE_ID),

77: values
78: (
79: x_move_id,
80: p_move_info.MOVE_TYPE_CODE,
81: decode(p_move_info.LANE_ID,FND_API.G_MISS_NUM,NULL,p_move_info.LANE_ID),
82: decode(p_move_info.SERVICE_LEVEL,FND_API.G_MISS_CHAR,NULL,p_move_info.SERVICE_LEVEL),
83: p_move_info.PLANNED_FLAG,
84: decode(p_move_info.TP_PLAN_NAME,FND_API.G_MISS_CHAR,NULL,p_move_info.TP_PLAN_NAME),
85: decode(p_move_info.CM_TRIP_NUMBER,FND_API.G_MISS_NUM,NULL,p_move_info.CM_TRIP_NUMBER),

Line 82: decode(p_move_info.SERVICE_LEVEL,FND_API.G_MISS_CHAR,NULL,p_move_info.SERVICE_LEVEL),

78: (
79: x_move_id,
80: p_move_info.MOVE_TYPE_CODE,
81: decode(p_move_info.LANE_ID,FND_API.G_MISS_NUM,NULL,p_move_info.LANE_ID),
82: decode(p_move_info.SERVICE_LEVEL,FND_API.G_MISS_CHAR,NULL,p_move_info.SERVICE_LEVEL),
83: p_move_info.PLANNED_FLAG,
84: decode(p_move_info.TP_PLAN_NAME,FND_API.G_MISS_CHAR,NULL,p_move_info.TP_PLAN_NAME),
85: decode(p_move_info.CM_TRIP_NUMBER,FND_API.G_MISS_NUM,NULL,p_move_info.CM_TRIP_NUMBER),
86: decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),

Line 84: decode(p_move_info.TP_PLAN_NAME,FND_API.G_MISS_CHAR,NULL,p_move_info.TP_PLAN_NAME),

80: p_move_info.MOVE_TYPE_CODE,
81: decode(p_move_info.LANE_ID,FND_API.G_MISS_NUM,NULL,p_move_info.LANE_ID),
82: decode(p_move_info.SERVICE_LEVEL,FND_API.G_MISS_CHAR,NULL,p_move_info.SERVICE_LEVEL),
83: p_move_info.PLANNED_FLAG,
84: decode(p_move_info.TP_PLAN_NAME,FND_API.G_MISS_CHAR,NULL,p_move_info.TP_PLAN_NAME),
85: decode(p_move_info.CM_TRIP_NUMBER,FND_API.G_MISS_NUM,NULL,p_move_info.CM_TRIP_NUMBER),
86: decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),
87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),

Line 85: decode(p_move_info.CM_TRIP_NUMBER,FND_API.G_MISS_NUM,NULL,p_move_info.CM_TRIP_NUMBER),

81: decode(p_move_info.LANE_ID,FND_API.G_MISS_NUM,NULL,p_move_info.LANE_ID),
82: decode(p_move_info.SERVICE_LEVEL,FND_API.G_MISS_CHAR,NULL,p_move_info.SERVICE_LEVEL),
83: p_move_info.PLANNED_FLAG,
84: decode(p_move_info.TP_PLAN_NAME,FND_API.G_MISS_CHAR,NULL,p_move_info.TP_PLAN_NAME),
85: decode(p_move_info.CM_TRIP_NUMBER,FND_API.G_MISS_NUM,NULL,p_move_info.CM_TRIP_NUMBER),
86: decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),
87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),

Line 86: decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),

82: decode(p_move_info.SERVICE_LEVEL,FND_API.G_MISS_CHAR,NULL,p_move_info.SERVICE_LEVEL),
83: p_move_info.PLANNED_FLAG,
84: decode(p_move_info.TP_PLAN_NAME,FND_API.G_MISS_CHAR,NULL,p_move_info.TP_PLAN_NAME),
85: decode(p_move_info.CM_TRIP_NUMBER,FND_API.G_MISS_NUM,NULL,p_move_info.CM_TRIP_NUMBER),
86: decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),
87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),

Line 87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),

83: p_move_info.PLANNED_FLAG,
84: decode(p_move_info.TP_PLAN_NAME,FND_API.G_MISS_CHAR,NULL,p_move_info.TP_PLAN_NAME),
85: decode(p_move_info.CM_TRIP_NUMBER,FND_API.G_MISS_NUM,NULL,p_move_info.CM_TRIP_NUMBER),
86: decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),
87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),

Line 88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),

84: decode(p_move_info.TP_PLAN_NAME,FND_API.G_MISS_CHAR,NULL,p_move_info.TP_PLAN_NAME),
85: decode(p_move_info.CM_TRIP_NUMBER,FND_API.G_MISS_NUM,NULL,p_move_info.CM_TRIP_NUMBER),
86: decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),
87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),

Line 89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),

85: decode(p_move_info.CM_TRIP_NUMBER,FND_API.G_MISS_NUM,NULL,p_move_info.CM_TRIP_NUMBER),
86: decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),
87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),
93: decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),

Line 90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),

86: decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),
87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),
93: decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),
94: decode(p_move_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_move_info.request_id)

Line 91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),

87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),
93: decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),
94: decode(p_move_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_move_info.request_id)
95: );

Line 92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),

88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),
93: decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),
94: decode(p_move_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_move_info.request_id)
95: );
96:

Line 93: decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),

89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),
93: decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),
94: decode(p_move_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_move_info.request_id)
95: );
96:
97:

Line 94: decode(p_move_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_move_info.request_id)

90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),
93: decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),
94: decode(p_move_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_move_info.request_id)
95: );
96:
97:
98:

Line 123: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

119: -- COMMENT : Updates trip record with p_trip_info information
120: --========================================================================
121:
122: PROCEDURE UPDATE_MOVE(
123: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
124: p_move_info IN move_rec_type,
125: x_return_status OUT NOCOPY VARCHAR2
126: ) IS
127:

Line 131: IF FND_API.to_Boolean( p_init_msg_list )

127:
128:
129: BEGIN
130:
131: IF FND_API.to_Boolean( p_init_msg_list )
132: THEN
133: FND_MSG_PUB.initialize;
134: END IF;
135:

Line 142: FND_API.G_MISS_CHAR,MOVE_TYPE_CODE,

138:
139: UPDATE FTE_MOVES SET
140: MOVE_TYPE_CODE =decode(p_move_info.MOVE_TYPE_CODE,
141: NULL,MOVE_TYPE_CODE,
142: FND_API.G_MISS_CHAR,MOVE_TYPE_CODE,
143: p_move_info.MOVE_TYPE_CODE),
144: LANE_ID =decode(p_move_info.LANE_ID,
145: NULL,LANE_ID,
146: FND_API.G_MISS_NUM,NULL,

Line 146: FND_API.G_MISS_NUM,NULL,

142: FND_API.G_MISS_CHAR,MOVE_TYPE_CODE,
143: p_move_info.MOVE_TYPE_CODE),
144: LANE_ID =decode(p_move_info.LANE_ID,
145: NULL,LANE_ID,
146: FND_API.G_MISS_NUM,NULL,
147: p_move_info.LANE_ID),
148: SERVICE_LEVEL =decode(p_move_info.SERVICE_LEVEL,
149: NULL,SERVICE_LEVEL,
150: FND_API.G_MISS_CHAR,NULL,

Line 150: FND_API.G_MISS_CHAR,NULL,

146: FND_API.G_MISS_NUM,NULL,
147: p_move_info.LANE_ID),
148: SERVICE_LEVEL =decode(p_move_info.SERVICE_LEVEL,
149: NULL,SERVICE_LEVEL,
150: FND_API.G_MISS_CHAR,NULL,
151: p_move_info.SERVICE_LEVEL),
152: PLANNED_FLAG =decode(p_move_info.PLANNED_FLAG,
153: NULL,PLANNED_FLAG,
154: FND_API.G_MISS_CHAR,PLANNED_FLAG,

Line 154: FND_API.G_MISS_CHAR,PLANNED_FLAG,

150: FND_API.G_MISS_CHAR,NULL,
151: p_move_info.SERVICE_LEVEL),
152: PLANNED_FLAG =decode(p_move_info.PLANNED_FLAG,
153: NULL,PLANNED_FLAG,
154: FND_API.G_MISS_CHAR,PLANNED_FLAG,
155: p_move_info.PLANNED_FLAG),
156: TP_PLAN_NAME =decode(p_move_info.TP_PLAN_NAME,
157: NULL,TP_PLAN_NAME,
158: FND_API.G_MISS_CHAR,NULL,

Line 158: FND_API.G_MISS_CHAR,NULL,

154: FND_API.G_MISS_CHAR,PLANNED_FLAG,
155: p_move_info.PLANNED_FLAG),
156: TP_PLAN_NAME =decode(p_move_info.TP_PLAN_NAME,
157: NULL,TP_PLAN_NAME,
158: FND_API.G_MISS_CHAR,NULL,
159: p_move_info.TP_PLAN_NAME),
160: CM_TRIP_NUMBER =decode(p_move_info.CM_TRIP_NUMBER,
161: NULL,CM_TRIP_NUMBER,
162: FND_API.G_MISS_NUM,NULL,

Line 162: FND_API.G_MISS_NUM,NULL,

158: FND_API.G_MISS_CHAR,NULL,
159: p_move_info.TP_PLAN_NAME),
160: CM_TRIP_NUMBER =decode(p_move_info.CM_TRIP_NUMBER,
161: NULL,CM_TRIP_NUMBER,
162: FND_API.G_MISS_NUM,NULL,
163: p_move_info.CM_TRIP_NUMBER),
164: last_update_date = decode(p_move_info.last_update_date,
165: NULL,SYSDATE,
166: FND_API.G_MISS_DATE,SYSDATE,

Line 166: FND_API.G_MISS_DATE,SYSDATE,

162: FND_API.G_MISS_NUM,NULL,
163: p_move_info.CM_TRIP_NUMBER),
164: last_update_date = decode(p_move_info.last_update_date,
165: NULL,SYSDATE,
166: FND_API.G_MISS_DATE,SYSDATE,
167: p_move_info.last_update_date),
168: last_updated_by = decode(p_move_info.last_updated_by,
169: NULL,FND_GLOBAL.USER_ID,
170: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,

Line 170: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,

166: FND_API.G_MISS_DATE,SYSDATE,
167: p_move_info.last_update_date),
168: last_updated_by = decode(p_move_info.last_updated_by,
169: NULL,FND_GLOBAL.USER_ID,
170: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,
171: p_move_info.last_updated_by),
172: last_update_login = decode(p_move_info.last_update_login,
173: NULL,FND_GLOBAL.LOGIN_ID,
174: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,

Line 174: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,

170: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,
171: p_move_info.last_updated_by),
172: last_update_login = decode(p_move_info.last_update_login,
173: NULL,FND_GLOBAL.LOGIN_ID,
174: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,
175: p_move_info.last_update_login),
176: program_application_id = decode(p_move_info.program_application_id,
177: NULL,program_application_id,
178: FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,

Line 178: FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,

174: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,
175: p_move_info.last_update_login),
176: program_application_id = decode(p_move_info.program_application_id,
177: NULL,program_application_id,
178: FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,
179: p_move_info.program_application_id),
180: program_id = decode(p_move_info.program_id,
181: NULL,program_id,FND_API.G_MISS_NUM,
182: FND_GLOBAL.CONC_PROGRAM_ID,

Line 181: NULL,program_id,FND_API.G_MISS_NUM,

177: NULL,program_application_id,
178: FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,
179: p_move_info.program_application_id),
180: program_id = decode(p_move_info.program_id,
181: NULL,program_id,FND_API.G_MISS_NUM,
182: FND_GLOBAL.CONC_PROGRAM_ID,
183: p_move_info.program_id),
184: program_update_date = decode(p_move_info.program_update_date,
185: NULL,program_update_date,

Line 186: FND_API.G_MISS_DATE,SYSDATE,

182: FND_GLOBAL.CONC_PROGRAM_ID,
183: p_move_info.program_id),
184: program_update_date = decode(p_move_info.program_update_date,
185: NULL,program_update_date,
186: FND_API.G_MISS_DATE,SYSDATE,
187: p_move_info.program_update_date),
188: request_id = decode(p_move_info.request_id,
189: NULL,request_id,FND_API.G_MISS_NUM,
190: FND_GLOBAL.CONC_REQUEST_ID,p_move_info.request_id)

Line 189: NULL,request_id,FND_API.G_MISS_NUM,

185: NULL,program_update_date,
186: FND_API.G_MISS_DATE,SYSDATE,
187: p_move_info.program_update_date),
188: request_id = decode(p_move_info.request_id,
189: NULL,request_id,FND_API.G_MISS_NUM,
190: FND_GLOBAL.CONC_REQUEST_ID,p_move_info.request_id)
191: WHERE move_id = p_move_info.move_id;
192:
193: IF (SQL%NOTFOUND) THEN

Line 210: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

206: END UPDATE_MOVE;
207:
208:
209: PROCEDURE DELETE_MOVE(
210: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
211: p_move_id IN NUMBER,
212: p_validate_flag IN VARCHAR2 DEFAULT 'Y',
213: x_return_status OUT NOCOPY VARCHAR2
214: ) IS

Line 219: IF FND_API.to_Boolean( p_init_msg_list )

215:
216:
217: BEGIN
218:
219: IF FND_API.to_Boolean( p_init_msg_list )
220: THEN
221: FND_MSG_PUB.initialize;
222: END IF;
223:

Line 250: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

246: END DELETE_MOVE;
247:
248:
249: PROCEDURE MARK_MOVE_REPRICE_FLAG(
250: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
251: p_MOVE_id IN NUMBER,
252: x_return_status OUT NOCOPY VARCHAR2,
253: x_msg_count OUT NOCOPY VARCHAR2,
254: x_msg_data OUT NOCOPY VARCHAR2

Line 281: IF FND_API.to_Boolean( p_init_msg_list )

277:
278: SAVEPOINT MARK_MOVE_REPRICE_FLAG_PUB;
279:
280:
281: IF FND_API.to_Boolean( p_init_msg_list )
282: THEN
283: FND_MSG_PUB.initialize;
284: END IF;
285:

Line 342: p_encoded => FND_API.G_FALSE

338: FND_MSG_PUB.Count_And_Get
339: (
340: p_count => x_msg_count,
341: p_data => x_msg_data,
342: p_encoded => FND_API.G_FALSE
343: );
344:
345: IF l_debug_on THEN
346: WSH_DEBUG_SV.pop(l_module_name);

Line 352: WHEN FND_API.G_EXC_ERROR THEN

348:
349:
350:
351: EXCEPTION
352: WHEN FND_API.G_EXC_ERROR THEN
353: ROLLBACK TO MARK_MOVE_REPRICE_FLAG_PUB;
354: x_return_status := FND_API.G_RET_STS_ERROR;
355: FND_MSG_PUB.Count_And_Get
356: (

Line 354: x_return_status := FND_API.G_RET_STS_ERROR;

350:
351: EXCEPTION
352: WHEN FND_API.G_EXC_ERROR THEN
353: ROLLBACK TO MARK_MOVE_REPRICE_FLAG_PUB;
354: x_return_status := FND_API.G_RET_STS_ERROR;
355: FND_MSG_PUB.Count_And_Get
356: (
357: p_count => x_msg_count,
358: p_data => x_msg_data,

Line 359: p_encoded => FND_API.G_FALSE

355: FND_MSG_PUB.Count_And_Get
356: (
357: p_count => x_msg_count,
358: p_data => x_msg_data,
359: p_encoded => FND_API.G_FALSE
360: );
361:
362: IF l_debug_on THEN
363: WSH_DEBUG_SV.logmsg(l_module_name,' Error Occured ' ||

Line 368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

364: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
365: WSH_DEBUG_SV.pop(l_module_name);
366: END IF;
367:
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO MARK_MOVE_REPRICE_FLAG_PUB;
370: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
371: FND_MSG_PUB.Count_And_Get
372: (

Line 375: p_encoded => FND_API.G_FALSE

371: FND_MSG_PUB.Count_And_Get
372: (
373: p_count => x_msg_count,
374: p_data => x_msg_data,
375: p_encoded => FND_API.G_FALSE
376: );
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,' Unexpected error Occured ' ||
379: x_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 394: p_encoded => FND_API.G_FALSE

390: FND_MSG_PUB.Count_And_Get
391: (
392: p_count => x_msg_count,
393: p_data => x_msg_data,
394: p_encoded => FND_API.G_FALSE
395: );
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,' SQL Error Occured ' ||
398: SQLCODE||' '||SQLERRM, WSH_DEBUG_SV.C_PROC_LEVEL);