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.CSF_DEBRIEF_HEADERS_PKG dependencies on FND_API

Line 103: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

99: x_return_status => l_return_status,
100: x_msg_count => l_msg_count,
101: x_msg_data => l_msg_data
102: ) ;
103: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
104: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
105: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
106: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
107: FND_MSG_PUB.Add;

Line 108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

104: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
105: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
106: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
107: FND_MSG_PUB.Add;
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110: END IF;
111: END IF;
112:

Line 126: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

122: x_msg_count => l_msg_count,
123: x_msg_data => l_msg_data
124: ) ;
125:
126: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
127: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
128: FND_MESSAGE.Set_Name('CS', 'CSF_API_ERR_PRE_VERT_USR_HK');
129: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
130: FND_MSG_PUB.Add;

Line 131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

127: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
128: FND_MESSAGE.Set_Name('CS', 'CSF_API_ERR_PRE_VERT_USR_HK');
129: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
130: FND_MSG_PUB.Add;
131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
132: END IF;
133: END IF;
134: csf_debrief_headers_iuhk.Create_debrief_header_Pre
135: ( x_return_status => l_return_status

Line 138: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

134: csf_debrief_headers_iuhk.Create_debrief_header_Pre
135: ( x_return_status => l_return_status
136: ) ;
137:
138: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
139: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
140: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
141: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
142: FND_MSG_PUB.Add;

Line 143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

139: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
140: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
141: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
142: FND_MSG_PUB.Add;
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: IF l_dml_mode = 'BOTH' THEN
147: If (l_debrief_header.DEBRIEF_HEADER_ID IS NULL) OR (l_debrief_header.DEBRIEF_HEADER_ID = FND_API.G_MISS_NUM) then

Line 147: If (l_debrief_header.DEBRIEF_HEADER_ID IS NULL) OR (l_debrief_header.DEBRIEF_HEADER_ID = FND_API.G_MISS_NUM) then

143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145:
146: IF l_dml_mode = 'BOTH' THEN
147: If (l_debrief_header.DEBRIEF_HEADER_ID IS NULL) OR (l_debrief_header.DEBRIEF_HEADER_ID = FND_API.G_MISS_NUM) then
148: OPEN C2;
149: FETCH C2 INTO px_DEBRIEF_HEADER_ID;
150: CLOSE C2;
151: End If;

Line 192: decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_header.DEBRIEF_NUMBER),

188: TRAVEL_DISTANCE_IN_KM,
189: PROCESSED_FLAG
190: ) VALUES (
191: px_DEBRIEF_HEADER_ID,
192: decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_header.DEBRIEF_NUMBER),
193: decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.DEBRIEF_DATE),
194: decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.DEBRIEF_STATUS_ID),
195: decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.TASK_ASSIGNMENT_ID),
196: decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.CREATED_BY),

Line 193: decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.DEBRIEF_DATE),

189: PROCESSED_FLAG
190: ) VALUES (
191: px_DEBRIEF_HEADER_ID,
192: decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_header.DEBRIEF_NUMBER),
193: decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.DEBRIEF_DATE),
194: decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.DEBRIEF_STATUS_ID),
195: decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.TASK_ASSIGNMENT_ID),
196: decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.CREATED_BY),
197: decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.CREATION_DATE),

Line 194: decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.DEBRIEF_STATUS_ID),

190: ) VALUES (
191: px_DEBRIEF_HEADER_ID,
192: decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_header.DEBRIEF_NUMBER),
193: decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.DEBRIEF_DATE),
194: decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.DEBRIEF_STATUS_ID),
195: decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.TASK_ASSIGNMENT_ID),
196: decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.CREATED_BY),
197: decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.CREATION_DATE),
198: decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.LAST_UPDATED_BY),

Line 195: decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.TASK_ASSIGNMENT_ID),

191: px_DEBRIEF_HEADER_ID,
192: decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_header.DEBRIEF_NUMBER),
193: decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.DEBRIEF_DATE),
194: decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.DEBRIEF_STATUS_ID),
195: decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.TASK_ASSIGNMENT_ID),
196: decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.CREATED_BY),
197: decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.CREATION_DATE),
198: decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.LAST_UPDATED_BY),
199: decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.LAST_UPDATE_DATE),

Line 196: decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.CREATED_BY),

192: decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, NULL, l_debrief_header.DEBRIEF_NUMBER),
193: decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.DEBRIEF_DATE),
194: decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.DEBRIEF_STATUS_ID),
195: decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.TASK_ASSIGNMENT_ID),
196: decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.CREATED_BY),
197: decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.CREATION_DATE),
198: decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.LAST_UPDATED_BY),
199: decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.LAST_UPDATE_DATE),
200: decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_header.LAST_UPDATE_LOGIN),

Line 197: decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.CREATION_DATE),

193: decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.DEBRIEF_DATE),
194: decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.DEBRIEF_STATUS_ID),
195: decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.TASK_ASSIGNMENT_ID),
196: decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.CREATED_BY),
197: decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.CREATION_DATE),
198: decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.LAST_UPDATED_BY),
199: decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.LAST_UPDATE_DATE),
200: decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_header.LAST_UPDATE_LOGIN),
201: decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE1),

Line 198: decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.LAST_UPDATED_BY),

194: decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.DEBRIEF_STATUS_ID),
195: decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.TASK_ASSIGNMENT_ID),
196: decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.CREATED_BY),
197: decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.CREATION_DATE),
198: decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.LAST_UPDATED_BY),
199: decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.LAST_UPDATE_DATE),
200: decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_header.LAST_UPDATE_LOGIN),
201: decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE1),
202: decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE2),

Line 199: decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.LAST_UPDATE_DATE),

195: decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_debrief_header.TASK_ASSIGNMENT_ID),
196: decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.CREATED_BY),
197: decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.CREATION_DATE),
198: decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.LAST_UPDATED_BY),
199: decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.LAST_UPDATE_DATE),
200: decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_header.LAST_UPDATE_LOGIN),
201: decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE1),
202: decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE2),
203: decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE3),

Line 200: decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_header.LAST_UPDATE_LOGIN),

196: decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.CREATED_BY),
197: decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.CREATION_DATE),
198: decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.LAST_UPDATED_BY),
199: decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.LAST_UPDATE_DATE),
200: decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_header.LAST_UPDATE_LOGIN),
201: decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE1),
202: decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE2),
203: decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE3),
204: decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE4),

Line 201: decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE1),

197: decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.CREATION_DATE),
198: decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.LAST_UPDATED_BY),
199: decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.LAST_UPDATE_DATE),
200: decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_header.LAST_UPDATE_LOGIN),
201: decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE1),
202: decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE2),
203: decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE3),
204: decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE4),
205: decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE5),

Line 202: decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE2),

198: decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, fnd_global.user_id, l_debrief_header.LAST_UPDATED_BY),
199: decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.LAST_UPDATE_DATE),
200: decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_header.LAST_UPDATE_LOGIN),
201: decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE1),
202: decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE2),
203: decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE3),
204: decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE4),
205: decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE5),
206: decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE6),

Line 203: decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE3),

199: decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, sysdate, l_debrief_header.LAST_UPDATE_DATE),
200: decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_header.LAST_UPDATE_LOGIN),
201: decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE1),
202: decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE2),
203: decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE3),
204: decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE4),
205: decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE5),
206: decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE6),
207: decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE7),

Line 204: decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE4),

200: decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, fnd_global.conc_login_id, l_debrief_header.LAST_UPDATE_LOGIN),
201: decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE1),
202: decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE2),
203: decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE3),
204: decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE4),
205: decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE5),
206: decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE6),
207: decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE7),
208: decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE8),

Line 205: decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE5),

201: decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE1),
202: decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE2),
203: decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE3),
204: decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE4),
205: decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE5),
206: decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE6),
207: decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE7),
208: decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE8),
209: decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE9),

Line 206: decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE6),

202: decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE2),
203: decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE3),
204: decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE4),
205: decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE5),
206: decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE6),
207: decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE7),
208: decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE8),
209: decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE9),
210: decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE10),

Line 207: decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE7),

203: decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE3),
204: decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE4),
205: decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE5),
206: decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE6),
207: decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE7),
208: decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE8),
209: decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE9),
210: decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE10),
211: decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE11),

Line 208: decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE8),

204: decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE4),
205: decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE5),
206: decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE6),
207: decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE7),
208: decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE8),
209: decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE9),
210: decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE10),
211: decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE11),
212: decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE12),

Line 209: decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE9),

205: decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE5),
206: decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE6),
207: decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE7),
208: decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE8),
209: decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE9),
210: decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE10),
211: decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE11),
212: decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE12),
213: decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE13),

Line 210: decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE10),

206: decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE6),
207: decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE7),
208: decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE8),
209: decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE9),
210: decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE10),
211: decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE11),
212: decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE12),
213: decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE13),
214: decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE14),

Line 211: decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE11),

207: decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE7),
208: decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE8),
209: decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE9),
210: decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE10),
211: decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE11),
212: decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE12),
213: decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE13),
214: decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE14),
215: decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE15),

Line 212: decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE12),

208: decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE8),
209: decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE9),
210: decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE10),
211: decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE11),
212: decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE12),
213: decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE13),
214: decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE14),
215: decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE15),
216: decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE_CATEGORY),

Line 213: decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE13),

209: decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE9),
210: decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE10),
211: decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE11),
212: decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE12),
213: decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE13),
214: decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE14),
215: decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE15),
216: decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE_CATEGORY),
217: decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,l_debrief_header.OBJECT_VERSION_NUMBER),

Line 214: decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE14),

210: decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE10),
211: decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE11),
212: decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE12),
213: decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE13),
214: decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE14),
215: decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE15),
216: decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE_CATEGORY),
217: decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,l_debrief_header.OBJECT_VERSION_NUMBER),
218: decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_START_TIME),

Line 215: decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE15),

211: decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE11),
212: decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE12),
213: decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE13),
214: decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE14),
215: decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE15),
216: decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE_CATEGORY),
217: decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,l_debrief_header.OBJECT_VERSION_NUMBER),
218: decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_START_TIME),
219: decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_END_TIME),

Line 216: decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE_CATEGORY),

212: decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE12),
213: decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE13),
214: decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE14),
215: decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE15),
216: decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE_CATEGORY),
217: decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,l_debrief_header.OBJECT_VERSION_NUMBER),
218: decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_START_TIME),
219: decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_END_TIME),
220: decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, NULL, l_debrief_header.TRAVEL_DISTANCE_IN_KM),

Line 217: decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,l_debrief_header.OBJECT_VERSION_NUMBER),

213: decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE13),
214: decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE14),
215: decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE15),
216: decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE_CATEGORY),
217: decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,l_debrief_header.OBJECT_VERSION_NUMBER),
218: decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_START_TIME),
219: decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_END_TIME),
220: decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, NULL, l_debrief_header.TRAVEL_DISTANCE_IN_KM),
221: 'UNPROCESSED'

Line 218: decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_START_TIME),

214: decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE14),
215: decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE15),
216: decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE_CATEGORY),
217: decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,l_debrief_header.OBJECT_VERSION_NUMBER),
218: decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_START_TIME),
219: decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_END_TIME),
220: decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, NULL, l_debrief_header.TRAVEL_DISTANCE_IN_KM),
221: 'UNPROCESSED'
222: );

Line 219: decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_END_TIME),

215: decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE15),
216: decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE_CATEGORY),
217: decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,l_debrief_header.OBJECT_VERSION_NUMBER),
218: decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_START_TIME),
219: decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_END_TIME),
220: decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, NULL, l_debrief_header.TRAVEL_DISTANCE_IN_KM),
221: 'UNPROCESSED'
222: );
223: END IF;

Line 220: decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, NULL, l_debrief_header.TRAVEL_DISTANCE_IN_KM),

216: decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_debrief_header.ATTRIBUTE_CATEGORY),
217: decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,l_debrief_header.OBJECT_VERSION_NUMBER),
218: decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_START_TIME),
219: decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, to_date(null), l_debrief_header.TRAVEL_END_TIME),
220: decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, NULL, l_debrief_header.TRAVEL_DISTANCE_IN_KM),
221: 'UNPROCESSED'
222: );
223: END IF;
224:

Line 236: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

232: x_return_status => l_return_status,
233: x_msg_count => l_msg_count,
234: x_msg_data => l_msg_data
235: ) ;
236: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
237: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
238: FND_MESSAGE.Set_Name('CS', 'CS_ERR_POST_CUST_USR_HK');
239: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
240: FND_MSG_PUB.Add;

Line 241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

237: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
238: FND_MESSAGE.Set_Name('CS', 'CS_ERR_POST_CUST_USR_HK');
239: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
240: FND_MSG_PUB.Add;
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243: END IF;
244: END IF;
245:

Line 259: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

255: x_msg_count => l_msg_count,
256: x_msg_data => l_msg_data
257: ) ;
258:
259: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
260: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
261: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
262: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
263: FND_MSG_PUB.Add;

Line 264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

260: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
261: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
262: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
263: FND_MSG_PUB.Add;
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266: END IF;
267: csf_debrief_headers_iuhk.Create_debrief_header_post
268: ( x_return_status => l_return_status

Line 271: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

267: csf_debrief_headers_iuhk.Create_debrief_header_post
268: ( x_return_status => l_return_status
269: ) ;
270:
271: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
272: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
273: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_INT_USR_HK');
274: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
275: FND_MSG_PUB.Add;

Line 276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

272: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
273: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_INT_USR_HK');
274: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
275: FND_MSG_PUB.Add;
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278:
279: -- added for bug 3565704
280: -- Standard check of p_commit

Line 283: l_commit := FND_API.G_FALSE;

279: -- added for bug 3565704
280: -- Standard check of p_commit
281:
282: if p_commit is null then
283: l_commit := FND_API.G_FALSE;
284: else
285: l_commit := p_commit;
286: end if;
287:

Line 289: --IF FND_API.To_Boolean(l_commit) THEN

285: l_commit := p_commit;
286: end if;
287:
288: -- Commented for bug 5067610
289: --IF FND_API.To_Boolean(l_commit) THEN
290: --COMMIT WORK;
291: --END IF;
292: -- Till here for bug 5067610
293:

Line 384: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

380: x_return_status => l_return_status,
381: x_msg_count => l_msg_count,
382: x_msg_data => l_msg_data
383: ) ;
384: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
385: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
386: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
387: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
388: FND_MSG_PUB.Add;

Line 389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

385: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
386: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
387: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
388: FND_MSG_PUB.Add;
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391: END IF;
392: END IF;
393:

Line 407: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

403: x_msg_count => l_msg_count,
404: x_msg_data => l_msg_data
405: ) ;
406:
407: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
408: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
409: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
410: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
411: FND_MSG_PUB.Add;

Line 412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

408: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
409: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
410: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
411: FND_MSG_PUB.Add;
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;
414: END IF;
415: user_hooks_rec.DEBRIEF_HEADER_ID := l_debrief_header.DEBRIEF_HEADER_ID;
416: csf_debrief_headers_iuhk.update_debrief_header_Pre

Line 420: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

416: csf_debrief_headers_iuhk.update_debrief_header_Pre
417: ( x_return_status => l_return_status
418: ) ;
419:
420: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
421: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
422: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
423: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
424: FND_MSG_PUB.Add;

Line 425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

421: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
422: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
423: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
424: FND_MSG_PUB.Add;
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: if l_dml_mode = 'BOTH' then
429:

Line 432: DEBRIEF_NUMBER = decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, DEBRIEF_NUMBER, l_debrief_header.DEBRIEF_NUMBER),

428: if l_dml_mode = 'BOTH' then
429:
430: Update CSF_DEBRIEF_HEADERS
431: SET
432: DEBRIEF_NUMBER = decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, DEBRIEF_NUMBER, l_debrief_header.DEBRIEF_NUMBER),
433: DEBRIEF_DATE = decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, DEBRIEF_DATE, l_debrief_header.DEBRIEF_DATE),
434: DEBRIEF_STATUS_ID = decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_STATUS_ID, l_debrief_header.DEBRIEF_STATUS_ID),
435: TASK_ASSIGNMENT_ID = decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_debrief_header.TASK_ASSIGNMENT_ID),
436: CREATED_BY = decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_header.CREATED_BY),

Line 433: DEBRIEF_DATE = decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, DEBRIEF_DATE, l_debrief_header.DEBRIEF_DATE),

429:
430: Update CSF_DEBRIEF_HEADERS
431: SET
432: DEBRIEF_NUMBER = decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, DEBRIEF_NUMBER, l_debrief_header.DEBRIEF_NUMBER),
433: DEBRIEF_DATE = decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, DEBRIEF_DATE, l_debrief_header.DEBRIEF_DATE),
434: DEBRIEF_STATUS_ID = decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_STATUS_ID, l_debrief_header.DEBRIEF_STATUS_ID),
435: TASK_ASSIGNMENT_ID = decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_debrief_header.TASK_ASSIGNMENT_ID),
436: CREATED_BY = decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_header.CREATED_BY),
437: CREATION_DATE = decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_debrief_header.CREATION_DATE),

Line 434: DEBRIEF_STATUS_ID = decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_STATUS_ID, l_debrief_header.DEBRIEF_STATUS_ID),

430: Update CSF_DEBRIEF_HEADERS
431: SET
432: DEBRIEF_NUMBER = decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, DEBRIEF_NUMBER, l_debrief_header.DEBRIEF_NUMBER),
433: DEBRIEF_DATE = decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, DEBRIEF_DATE, l_debrief_header.DEBRIEF_DATE),
434: DEBRIEF_STATUS_ID = decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_STATUS_ID, l_debrief_header.DEBRIEF_STATUS_ID),
435: TASK_ASSIGNMENT_ID = decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_debrief_header.TASK_ASSIGNMENT_ID),
436: CREATED_BY = decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_header.CREATED_BY),
437: CREATION_DATE = decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_debrief_header.CREATION_DATE),
438: LAST_UPDATED_BY = decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_header.LAST_UPDATED_BY),

Line 435: TASK_ASSIGNMENT_ID = decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_debrief_header.TASK_ASSIGNMENT_ID),

431: SET
432: DEBRIEF_NUMBER = decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, DEBRIEF_NUMBER, l_debrief_header.DEBRIEF_NUMBER),
433: DEBRIEF_DATE = decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, DEBRIEF_DATE, l_debrief_header.DEBRIEF_DATE),
434: DEBRIEF_STATUS_ID = decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_STATUS_ID, l_debrief_header.DEBRIEF_STATUS_ID),
435: TASK_ASSIGNMENT_ID = decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_debrief_header.TASK_ASSIGNMENT_ID),
436: CREATED_BY = decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_header.CREATED_BY),
437: CREATION_DATE = decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_debrief_header.CREATION_DATE),
438: LAST_UPDATED_BY = decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_header.LAST_UPDATED_BY),
439: LAST_UPDATE_DATE = decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_debrief_header.LAST_UPDATE_DATE),

Line 436: CREATED_BY = decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_header.CREATED_BY),

432: DEBRIEF_NUMBER = decode( l_debrief_header.DEBRIEF_NUMBER, FND_API.G_MISS_CHAR, DEBRIEF_NUMBER, l_debrief_header.DEBRIEF_NUMBER),
433: DEBRIEF_DATE = decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, DEBRIEF_DATE, l_debrief_header.DEBRIEF_DATE),
434: DEBRIEF_STATUS_ID = decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_STATUS_ID, l_debrief_header.DEBRIEF_STATUS_ID),
435: TASK_ASSIGNMENT_ID = decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_debrief_header.TASK_ASSIGNMENT_ID),
436: CREATED_BY = decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_header.CREATED_BY),
437: CREATION_DATE = decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_debrief_header.CREATION_DATE),
438: LAST_UPDATED_BY = decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_header.LAST_UPDATED_BY),
439: LAST_UPDATE_DATE = decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_debrief_header.LAST_UPDATE_DATE),
440: LAST_UPDATE_LOGIN = decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_header.LAST_UPDATE_LOGIN),

Line 437: CREATION_DATE = decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_debrief_header.CREATION_DATE),

433: DEBRIEF_DATE = decode( l_debrief_header.DEBRIEF_DATE, FND_API.G_MISS_DATE, DEBRIEF_DATE, l_debrief_header.DEBRIEF_DATE),
434: DEBRIEF_STATUS_ID = decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_STATUS_ID, l_debrief_header.DEBRIEF_STATUS_ID),
435: TASK_ASSIGNMENT_ID = decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_debrief_header.TASK_ASSIGNMENT_ID),
436: CREATED_BY = decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_header.CREATED_BY),
437: CREATION_DATE = decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_debrief_header.CREATION_DATE),
438: LAST_UPDATED_BY = decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_header.LAST_UPDATED_BY),
439: LAST_UPDATE_DATE = decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_debrief_header.LAST_UPDATE_DATE),
440: LAST_UPDATE_LOGIN = decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_header.LAST_UPDATE_LOGIN),
441: ATTRIBUTE1 = decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_header.ATTRIBUTE1),

Line 438: LAST_UPDATED_BY = decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_header.LAST_UPDATED_BY),

434: DEBRIEF_STATUS_ID = decode( l_debrief_header.DEBRIEF_STATUS_ID, FND_API.G_MISS_NUM, DEBRIEF_STATUS_ID, l_debrief_header.DEBRIEF_STATUS_ID),
435: TASK_ASSIGNMENT_ID = decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_debrief_header.TASK_ASSIGNMENT_ID),
436: CREATED_BY = decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_header.CREATED_BY),
437: CREATION_DATE = decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_debrief_header.CREATION_DATE),
438: LAST_UPDATED_BY = decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_header.LAST_UPDATED_BY),
439: LAST_UPDATE_DATE = decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_debrief_header.LAST_UPDATE_DATE),
440: LAST_UPDATE_LOGIN = decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_header.LAST_UPDATE_LOGIN),
441: ATTRIBUTE1 = decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_header.ATTRIBUTE1),
442: ATTRIBUTE2 = decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_header.ATTRIBUTE2),

Line 439: LAST_UPDATE_DATE = decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_debrief_header.LAST_UPDATE_DATE),

435: TASK_ASSIGNMENT_ID = decode( l_debrief_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_debrief_header.TASK_ASSIGNMENT_ID),
436: CREATED_BY = decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_header.CREATED_BY),
437: CREATION_DATE = decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_debrief_header.CREATION_DATE),
438: LAST_UPDATED_BY = decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_header.LAST_UPDATED_BY),
439: LAST_UPDATE_DATE = decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_debrief_header.LAST_UPDATE_DATE),
440: LAST_UPDATE_LOGIN = decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_header.LAST_UPDATE_LOGIN),
441: ATTRIBUTE1 = decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_header.ATTRIBUTE1),
442: ATTRIBUTE2 = decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_header.ATTRIBUTE2),
443: ATTRIBUTE3 = decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_header.ATTRIBUTE3),

Line 440: LAST_UPDATE_LOGIN = decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_header.LAST_UPDATE_LOGIN),

436: CREATED_BY = decode( l_debrief_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_debrief_header.CREATED_BY),
437: CREATION_DATE = decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_debrief_header.CREATION_DATE),
438: LAST_UPDATED_BY = decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_header.LAST_UPDATED_BY),
439: LAST_UPDATE_DATE = decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_debrief_header.LAST_UPDATE_DATE),
440: LAST_UPDATE_LOGIN = decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_header.LAST_UPDATE_LOGIN),
441: ATTRIBUTE1 = decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_header.ATTRIBUTE1),
442: ATTRIBUTE2 = decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_header.ATTRIBUTE2),
443: ATTRIBUTE3 = decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_header.ATTRIBUTE3),
444: ATTRIBUTE4 = decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_header.ATTRIBUTE4),

Line 441: ATTRIBUTE1 = decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_header.ATTRIBUTE1),

437: CREATION_DATE = decode( l_debrief_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_debrief_header.CREATION_DATE),
438: LAST_UPDATED_BY = decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_header.LAST_UPDATED_BY),
439: LAST_UPDATE_DATE = decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_debrief_header.LAST_UPDATE_DATE),
440: LAST_UPDATE_LOGIN = decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_header.LAST_UPDATE_LOGIN),
441: ATTRIBUTE1 = decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_header.ATTRIBUTE1),
442: ATTRIBUTE2 = decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_header.ATTRIBUTE2),
443: ATTRIBUTE3 = decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_header.ATTRIBUTE3),
444: ATTRIBUTE4 = decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_header.ATTRIBUTE4),
445: ATTRIBUTE5 = decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_header.ATTRIBUTE5),

Line 442: ATTRIBUTE2 = decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_header.ATTRIBUTE2),

438: LAST_UPDATED_BY = decode( l_debrief_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_debrief_header.LAST_UPDATED_BY),
439: LAST_UPDATE_DATE = decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_debrief_header.LAST_UPDATE_DATE),
440: LAST_UPDATE_LOGIN = decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_header.LAST_UPDATE_LOGIN),
441: ATTRIBUTE1 = decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_header.ATTRIBUTE1),
442: ATTRIBUTE2 = decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_header.ATTRIBUTE2),
443: ATTRIBUTE3 = decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_header.ATTRIBUTE3),
444: ATTRIBUTE4 = decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_header.ATTRIBUTE4),
445: ATTRIBUTE5 = decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_header.ATTRIBUTE5),
446: ATTRIBUTE6 = decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_header.ATTRIBUTE6),

Line 443: ATTRIBUTE3 = decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_header.ATTRIBUTE3),

439: LAST_UPDATE_DATE = decode( l_debrief_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_debrief_header.LAST_UPDATE_DATE),
440: LAST_UPDATE_LOGIN = decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_header.LAST_UPDATE_LOGIN),
441: ATTRIBUTE1 = decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_header.ATTRIBUTE1),
442: ATTRIBUTE2 = decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_header.ATTRIBUTE2),
443: ATTRIBUTE3 = decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_header.ATTRIBUTE3),
444: ATTRIBUTE4 = decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_header.ATTRIBUTE4),
445: ATTRIBUTE5 = decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_header.ATTRIBUTE5),
446: ATTRIBUTE6 = decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_header.ATTRIBUTE6),
447: ATTRIBUTE7 = decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_header.ATTRIBUTE7),

Line 444: ATTRIBUTE4 = decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_header.ATTRIBUTE4),

440: LAST_UPDATE_LOGIN = decode( l_debrief_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_debrief_header.LAST_UPDATE_LOGIN),
441: ATTRIBUTE1 = decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_header.ATTRIBUTE1),
442: ATTRIBUTE2 = decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_header.ATTRIBUTE2),
443: ATTRIBUTE3 = decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_header.ATTRIBUTE3),
444: ATTRIBUTE4 = decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_header.ATTRIBUTE4),
445: ATTRIBUTE5 = decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_header.ATTRIBUTE5),
446: ATTRIBUTE6 = decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_header.ATTRIBUTE6),
447: ATTRIBUTE7 = decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_header.ATTRIBUTE7),
448: ATTRIBUTE8 = decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_header.ATTRIBUTE8),

Line 445: ATTRIBUTE5 = decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_header.ATTRIBUTE5),

441: ATTRIBUTE1 = decode( l_debrief_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_debrief_header.ATTRIBUTE1),
442: ATTRIBUTE2 = decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_header.ATTRIBUTE2),
443: ATTRIBUTE3 = decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_header.ATTRIBUTE3),
444: ATTRIBUTE4 = decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_header.ATTRIBUTE4),
445: ATTRIBUTE5 = decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_header.ATTRIBUTE5),
446: ATTRIBUTE6 = decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_header.ATTRIBUTE6),
447: ATTRIBUTE7 = decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_header.ATTRIBUTE7),
448: ATTRIBUTE8 = decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_header.ATTRIBUTE8),
449: ATTRIBUTE9 = decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_header.ATTRIBUTE9),

Line 446: ATTRIBUTE6 = decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_header.ATTRIBUTE6),

442: ATTRIBUTE2 = decode( l_debrief_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_debrief_header.ATTRIBUTE2),
443: ATTRIBUTE3 = decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_header.ATTRIBUTE3),
444: ATTRIBUTE4 = decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_header.ATTRIBUTE4),
445: ATTRIBUTE5 = decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_header.ATTRIBUTE5),
446: ATTRIBUTE6 = decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_header.ATTRIBUTE6),
447: ATTRIBUTE7 = decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_header.ATTRIBUTE7),
448: ATTRIBUTE8 = decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_header.ATTRIBUTE8),
449: ATTRIBUTE9 = decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_header.ATTRIBUTE9),
450: ATTRIBUTE10 = decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_header.ATTRIBUTE10),

Line 447: ATTRIBUTE7 = decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_header.ATTRIBUTE7),

443: ATTRIBUTE3 = decode( l_debrief_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_debrief_header.ATTRIBUTE3),
444: ATTRIBUTE4 = decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_header.ATTRIBUTE4),
445: ATTRIBUTE5 = decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_header.ATTRIBUTE5),
446: ATTRIBUTE6 = decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_header.ATTRIBUTE6),
447: ATTRIBUTE7 = decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_header.ATTRIBUTE7),
448: ATTRIBUTE8 = decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_header.ATTRIBUTE8),
449: ATTRIBUTE9 = decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_header.ATTRIBUTE9),
450: ATTRIBUTE10 = decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_header.ATTRIBUTE10),
451: ATTRIBUTE11 = decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_header.ATTRIBUTE11),

Line 448: ATTRIBUTE8 = decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_header.ATTRIBUTE8),

444: ATTRIBUTE4 = decode( l_debrief_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_debrief_header.ATTRIBUTE4),
445: ATTRIBUTE5 = decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_header.ATTRIBUTE5),
446: ATTRIBUTE6 = decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_header.ATTRIBUTE6),
447: ATTRIBUTE7 = decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_header.ATTRIBUTE7),
448: ATTRIBUTE8 = decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_header.ATTRIBUTE8),
449: ATTRIBUTE9 = decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_header.ATTRIBUTE9),
450: ATTRIBUTE10 = decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_header.ATTRIBUTE10),
451: ATTRIBUTE11 = decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_header.ATTRIBUTE11),
452: ATTRIBUTE12 = decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_header.ATTRIBUTE12),

Line 449: ATTRIBUTE9 = decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_header.ATTRIBUTE9),

445: ATTRIBUTE5 = decode( l_debrief_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_debrief_header.ATTRIBUTE5),
446: ATTRIBUTE6 = decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_header.ATTRIBUTE6),
447: ATTRIBUTE7 = decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_header.ATTRIBUTE7),
448: ATTRIBUTE8 = decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_header.ATTRIBUTE8),
449: ATTRIBUTE9 = decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_header.ATTRIBUTE9),
450: ATTRIBUTE10 = decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_header.ATTRIBUTE10),
451: ATTRIBUTE11 = decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_header.ATTRIBUTE11),
452: ATTRIBUTE12 = decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_header.ATTRIBUTE12),
453: ATTRIBUTE13 = decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_header.ATTRIBUTE13),

Line 450: ATTRIBUTE10 = decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_header.ATTRIBUTE10),

446: ATTRIBUTE6 = decode( l_debrief_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_debrief_header.ATTRIBUTE6),
447: ATTRIBUTE7 = decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_header.ATTRIBUTE7),
448: ATTRIBUTE8 = decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_header.ATTRIBUTE8),
449: ATTRIBUTE9 = decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_header.ATTRIBUTE9),
450: ATTRIBUTE10 = decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_header.ATTRIBUTE10),
451: ATTRIBUTE11 = decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_header.ATTRIBUTE11),
452: ATTRIBUTE12 = decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_header.ATTRIBUTE12),
453: ATTRIBUTE13 = decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_header.ATTRIBUTE13),
454: ATTRIBUTE14 = decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_header.ATTRIBUTE14),

Line 451: ATTRIBUTE11 = decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_header.ATTRIBUTE11),

447: ATTRIBUTE7 = decode( l_debrief_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_debrief_header.ATTRIBUTE7),
448: ATTRIBUTE8 = decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_header.ATTRIBUTE8),
449: ATTRIBUTE9 = decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_header.ATTRIBUTE9),
450: ATTRIBUTE10 = decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_header.ATTRIBUTE10),
451: ATTRIBUTE11 = decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_header.ATTRIBUTE11),
452: ATTRIBUTE12 = decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_header.ATTRIBUTE12),
453: ATTRIBUTE13 = decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_header.ATTRIBUTE13),
454: ATTRIBUTE14 = decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_header.ATTRIBUTE14),
455: ATTRIBUTE15 = decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_header.ATTRIBUTE15),

Line 452: ATTRIBUTE12 = decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_header.ATTRIBUTE12),

448: ATTRIBUTE8 = decode( l_debrief_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_debrief_header.ATTRIBUTE8),
449: ATTRIBUTE9 = decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_header.ATTRIBUTE9),
450: ATTRIBUTE10 = decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_header.ATTRIBUTE10),
451: ATTRIBUTE11 = decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_header.ATTRIBUTE11),
452: ATTRIBUTE12 = decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_header.ATTRIBUTE12),
453: ATTRIBUTE13 = decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_header.ATTRIBUTE13),
454: ATTRIBUTE14 = decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_header.ATTRIBUTE14),
455: ATTRIBUTE15 = decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_header.ATTRIBUTE15),
456: ATTRIBUTE_CATEGORY = decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_header.ATTRIBUTE_CATEGORY),

Line 453: ATTRIBUTE13 = decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_header.ATTRIBUTE13),

449: ATTRIBUTE9 = decode( l_debrief_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_debrief_header.ATTRIBUTE9),
450: ATTRIBUTE10 = decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_header.ATTRIBUTE10),
451: ATTRIBUTE11 = decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_header.ATTRIBUTE11),
452: ATTRIBUTE12 = decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_header.ATTRIBUTE12),
453: ATTRIBUTE13 = decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_header.ATTRIBUTE13),
454: ATTRIBUTE14 = decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_header.ATTRIBUTE14),
455: ATTRIBUTE15 = decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_header.ATTRIBUTE15),
456: ATTRIBUTE_CATEGORY = decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_header.ATTRIBUTE_CATEGORY),
457: OBJECT_VERSION_NUMBER = decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_debrief_header.OBJECT_VERSION_NUMBER),

Line 454: ATTRIBUTE14 = decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_header.ATTRIBUTE14),

450: ATTRIBUTE10 = decode( l_debrief_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_debrief_header.ATTRIBUTE10),
451: ATTRIBUTE11 = decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_header.ATTRIBUTE11),
452: ATTRIBUTE12 = decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_header.ATTRIBUTE12),
453: ATTRIBUTE13 = decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_header.ATTRIBUTE13),
454: ATTRIBUTE14 = decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_header.ATTRIBUTE14),
455: ATTRIBUTE15 = decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_header.ATTRIBUTE15),
456: ATTRIBUTE_CATEGORY = decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_header.ATTRIBUTE_CATEGORY),
457: OBJECT_VERSION_NUMBER = decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_debrief_header.OBJECT_VERSION_NUMBER),
458: TRAVEL_START_TIME = decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, TRAVEL_START_TIME, l_debrief_header.TRAVEL_START_TIME),

Line 455: ATTRIBUTE15 = decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_header.ATTRIBUTE15),

451: ATTRIBUTE11 = decode( l_debrief_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_debrief_header.ATTRIBUTE11),
452: ATTRIBUTE12 = decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_header.ATTRIBUTE12),
453: ATTRIBUTE13 = decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_header.ATTRIBUTE13),
454: ATTRIBUTE14 = decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_header.ATTRIBUTE14),
455: ATTRIBUTE15 = decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_header.ATTRIBUTE15),
456: ATTRIBUTE_CATEGORY = decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_header.ATTRIBUTE_CATEGORY),
457: OBJECT_VERSION_NUMBER = decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_debrief_header.OBJECT_VERSION_NUMBER),
458: TRAVEL_START_TIME = decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, TRAVEL_START_TIME, l_debrief_header.TRAVEL_START_TIME),
459: TRAVEL_END_TIME = decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, TRAVEL_END_TIME, l_debrief_header.TRAVEL_END_TIME),

Line 456: ATTRIBUTE_CATEGORY = decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_header.ATTRIBUTE_CATEGORY),

452: ATTRIBUTE12 = decode( l_debrief_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_debrief_header.ATTRIBUTE12),
453: ATTRIBUTE13 = decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_header.ATTRIBUTE13),
454: ATTRIBUTE14 = decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_header.ATTRIBUTE14),
455: ATTRIBUTE15 = decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_header.ATTRIBUTE15),
456: ATTRIBUTE_CATEGORY = decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_header.ATTRIBUTE_CATEGORY),
457: OBJECT_VERSION_NUMBER = decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_debrief_header.OBJECT_VERSION_NUMBER),
458: TRAVEL_START_TIME = decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, TRAVEL_START_TIME, l_debrief_header.TRAVEL_START_TIME),
459: TRAVEL_END_TIME = decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, TRAVEL_END_TIME, l_debrief_header.TRAVEL_END_TIME),
460: TRAVEL_DISTANCE_IN_KM = decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, TRAVEL_DISTANCE_IN_KM, l_debrief_header.TRAVEL_DISTANCE_IN_KM)

Line 457: OBJECT_VERSION_NUMBER = decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_debrief_header.OBJECT_VERSION_NUMBER),

453: ATTRIBUTE13 = decode( l_debrief_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_debrief_header.ATTRIBUTE13),
454: ATTRIBUTE14 = decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_header.ATTRIBUTE14),
455: ATTRIBUTE15 = decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_header.ATTRIBUTE15),
456: ATTRIBUTE_CATEGORY = decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_header.ATTRIBUTE_CATEGORY),
457: OBJECT_VERSION_NUMBER = decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_debrief_header.OBJECT_VERSION_NUMBER),
458: TRAVEL_START_TIME = decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, TRAVEL_START_TIME, l_debrief_header.TRAVEL_START_TIME),
459: TRAVEL_END_TIME = decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, TRAVEL_END_TIME, l_debrief_header.TRAVEL_END_TIME),
460: TRAVEL_DISTANCE_IN_KM = decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, TRAVEL_DISTANCE_IN_KM, l_debrief_header.TRAVEL_DISTANCE_IN_KM)
461:

Line 458: TRAVEL_START_TIME = decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, TRAVEL_START_TIME, l_debrief_header.TRAVEL_START_TIME),

454: ATTRIBUTE14 = decode( l_debrief_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_debrief_header.ATTRIBUTE14),
455: ATTRIBUTE15 = decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_header.ATTRIBUTE15),
456: ATTRIBUTE_CATEGORY = decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_header.ATTRIBUTE_CATEGORY),
457: OBJECT_VERSION_NUMBER = decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_debrief_header.OBJECT_VERSION_NUMBER),
458: TRAVEL_START_TIME = decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, TRAVEL_START_TIME, l_debrief_header.TRAVEL_START_TIME),
459: TRAVEL_END_TIME = decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, TRAVEL_END_TIME, l_debrief_header.TRAVEL_END_TIME),
460: TRAVEL_DISTANCE_IN_KM = decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, TRAVEL_DISTANCE_IN_KM, l_debrief_header.TRAVEL_DISTANCE_IN_KM)
461:
462: where DEBRIEF_HEADER_ID = l_debrief_header.DEBRIEF_HEADER_ID;

Line 459: TRAVEL_END_TIME = decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, TRAVEL_END_TIME, l_debrief_header.TRAVEL_END_TIME),

455: ATTRIBUTE15 = decode( l_debrief_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_debrief_header.ATTRIBUTE15),
456: ATTRIBUTE_CATEGORY = decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_header.ATTRIBUTE_CATEGORY),
457: OBJECT_VERSION_NUMBER = decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_debrief_header.OBJECT_VERSION_NUMBER),
458: TRAVEL_START_TIME = decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, TRAVEL_START_TIME, l_debrief_header.TRAVEL_START_TIME),
459: TRAVEL_END_TIME = decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, TRAVEL_END_TIME, l_debrief_header.TRAVEL_END_TIME),
460: TRAVEL_DISTANCE_IN_KM = decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, TRAVEL_DISTANCE_IN_KM, l_debrief_header.TRAVEL_DISTANCE_IN_KM)
461:
462: where DEBRIEF_HEADER_ID = l_debrief_header.DEBRIEF_HEADER_ID;
463:

Line 460: TRAVEL_DISTANCE_IN_KM = decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, TRAVEL_DISTANCE_IN_KM, l_debrief_header.TRAVEL_DISTANCE_IN_KM)

456: ATTRIBUTE_CATEGORY = decode( l_debrief_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_debrief_header.ATTRIBUTE_CATEGORY),
457: OBJECT_VERSION_NUMBER = decode( l_debrief_header.OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,l_debrief_header.OBJECT_VERSION_NUMBER),
458: TRAVEL_START_TIME = decode( l_debrief_header.TRAVEL_START_TIME, FND_API.G_MISS_DATE, TRAVEL_START_TIME, l_debrief_header.TRAVEL_START_TIME),
459: TRAVEL_END_TIME = decode( l_debrief_header.TRAVEL_END_TIME, FND_API.G_MISS_DATE, TRAVEL_END_TIME, l_debrief_header.TRAVEL_END_TIME),
460: TRAVEL_DISTANCE_IN_KM = decode( l_debrief_header.TRAVEL_DISTANCE_IN_KM, FND_API.G_MISS_NUM, TRAVEL_DISTANCE_IN_KM, l_debrief_header.TRAVEL_DISTANCE_IN_KM)
461:
462: where DEBRIEF_HEADER_ID = l_debrief_header.DEBRIEF_HEADER_ID;
463:
464: If (SQL%NOTFOUND) then

Line 480: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

476: x_return_status => l_return_status,
477: x_msg_count => l_msg_count,
478: x_msg_data => l_msg_data
479: ) ;
480: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
481: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
482: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
483: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
484: FND_MSG_PUB.Add;

Line 485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

481: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
482: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
483: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
484: FND_MSG_PUB.Add;
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487: END IF;
488: END IF;
489:

Line 503: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

499: x_msg_count => l_msg_count,
500: x_msg_data => l_msg_data
501: ) ;
502:
503: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
504: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
505: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
506: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
507: FND_MSG_PUB.Add;

Line 508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

504: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
505: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
506: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
507: FND_MSG_PUB.Add;
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;
510: END IF;
511: csf_debrief_headers_iuhk.update_debrief_header_post
512: ( x_return_status => l_return_status

Line 515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

511: csf_debrief_headers_iuhk.update_debrief_header_post
512: ( x_return_status => l_return_status
513: ) ;
514:
515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
516: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
517: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_INT_USR_HK');
518: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
519: FND_MSG_PUB.Add;

Line 520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

516: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
517: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_INT_USR_HK');
518: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
519: FND_MSG_PUB.Add;
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522: END Update_Row;
523:
524: PROCEDURE Delete_Row(

Line 550: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

546: x_return_status => l_return_status,
547: x_msg_count => l_msg_count,
548: x_msg_data => l_msg_data
549: ) ;
550: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
551: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
552: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
553: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
554: FND_MSG_PUB.Add;

Line 555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

551: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
552: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_CUST_USR_HK');
553: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
554: FND_MSG_PUB.Add;
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556: END IF;
557: END IF;
558: END IF;
559:

Line 572: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

568: x_msg_count => l_msg_count,
569: x_msg_data => l_msg_data
570: ) ;
571:
572: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
573: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
574: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
575: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
576: FND_MSG_PUB.Add;

Line 577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

573: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
574: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_VERT_USR_HK');
575: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
576: FND_MSG_PUB.Add;
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: END IF;
579: END IF;
580: user_hooks_rec.DEBRIEF_HEADER_ID := p_DEBRIEF_HEADER_ID;
581: csf_debrief_headers_iuhk.delete_debrief_header_Pre

Line 585: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

581: csf_debrief_headers_iuhk.delete_debrief_header_Pre
582: ( x_return_status => l_return_status
583: ) ;
584:
585: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
586: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
587: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
588: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
589: FND_MSG_PUB.Add;

Line 590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

586: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
587: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_PRE_INT_USR_HK');
588: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
589: FND_MSG_PUB.Add;
590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
591: END IF;
592:
593: if l_dml_mode = 'BOTH' then
594: DELETE FROM CSF_DEBRIEF_HEADERS

Line 612: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

608: x_return_status => l_return_status,
609: x_msg_count => l_msg_count,
610: x_msg_data => l_msg_data
611: ) ;
612: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
613: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
614: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
615: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
616: FND_MSG_PUB.Add;

Line 617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

613: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
614: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_CUST_USR_HK');
615: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
616: FND_MSG_PUB.Add;
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619: END IF;
620: END IF;
621:

Line 635: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

631: x_msg_count => l_msg_count,
632: x_msg_data => l_msg_data
633: ) ;
634:
635: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
636: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
637: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
638: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
639: FND_MSG_PUB.Add;

Line 640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

636: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
637: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_VERT_USR_HK');
638: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
639: FND_MSG_PUB.Add;
640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
641: END IF;
642: END IF;
643: csf_debrief_headers_iuhk.Delete_debrief_header_post
644: ( x_return_status => l_return_status

Line 647: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

643: csf_debrief_headers_iuhk.Delete_debrief_header_post
644: ( x_return_status => l_return_status
645: ) ;
646:
647: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
648: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
649: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_INT_USR_HK');
650: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
651: FND_MSG_PUB.Add;

Line 652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

648: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
649: FND_MESSAGE.Set_Name('CS', 'CSF_ERR_POST_INT_USR_HK');
650: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
651: FND_MSG_PUB.Add;
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654: END Delete_Row;
655:
656: PROCEDURE Lock_Row(