100: X_PROGRAM_UPDATE_DATE
101: );
102:
103:
104: FND_MSG_PUB.Count_AND_GET
105: (p_count => x_msg_count, p_data => x_msg_data);
106:
107: EXCEPTION
108:
112: IF (SQLCODE IS NOT NULL) THEN
113: FND_MESSAGE.SET_NAME('GMI','GMI_LOTC_SQL_ERROR');
114: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
115: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
116: FND_MSG_PUB.Add;
117: END IF;
118: FND_MSG_PUB.Count_AND_GET
119: (p_count => x_msg_count, p_data => x_msg_data);
120:
114: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
115: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
116: FND_MSG_PUB.Add;
117: END IF;
118: FND_MSG_PUB.Count_AND_GET
119: (p_count => x_msg_count, p_data => x_msg_data);
120:
121:
122: END INSERT_ROW;
173: PROGRAM_ID = X_PROGRAM_ID,
174: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
175: WHERE CONVERSION_ID = X_CONVERSION_ID;
176:
177: FND_MSG_PUB.Count_AND_GET
178: (p_count => x_msg_count, p_data => x_msg_data);
179:
180: EXCEPTION
181:
184: IF (SQLCODE IS NOT NULL) THEN
185: FND_MESSAGE.SET_NAME('GMI','GMI_LOTC_SQL_ERROR');
186: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
187: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
188: FND_MSG_PUB.Add;
189: END IF;
190: FND_MSG_PUB.Count_AND_GET
191: (p_count => x_msg_count, p_data => x_msg_data);
192:
186: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
187: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
188: FND_MSG_PUB.Add;
189: END IF;
190: FND_MSG_PUB.Count_AND_GET
191: (p_count => x_msg_count, p_data => x_msg_data);
192:
193: END UPDATE_ROW;
194:
223: PROGRAM_ID = X_PROGRAM_ID,
224: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
225: WHERE CONVERSION_ID = X_CONVERSION_ID;
226:
227: FND_MSG_PUB.Count_AND_GET
228: (p_count => x_msg_count, p_data => x_msg_data);
229:
230: EXCEPTION
231:
235: IF (SQLCODE IS NOT NULL) THEN
236: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
237: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
238: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
239: FND_MSG_PUB.Add;
240: END IF;
241: FND_MSG_PUB.Count_AND_GET
242: (p_count => x_msg_count, p_data => x_msg_data);
243:
237: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
238: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
239: FND_MSG_PUB.Add;
240: END IF;
241: FND_MSG_PUB.Count_AND_GET
242: (p_count => x_msg_count, p_data => x_msg_data);
243:
244: END DELETE_ROW;
245: