94: );
95:
96:
97:
98: FND_MSG_PUB.Count_AND_GET
99: (p_count => x_msg_count, p_data => x_msg_data);
100:
101: EXCEPTION
102:
105: IF (SQLCODE IS NOT NULL) THEN
106: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
107: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
108: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
109: FND_MSG_PUB.Add;
110: END IF;
111: FND_MSG_PUB.Count_AND_GET
112: (p_count => x_msg_count, p_data => x_msg_data);
113:
107: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
108: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
109: FND_MSG_PUB.Add;
110: END IF;
111: FND_MSG_PUB.Count_AND_GET
112: (p_count => x_msg_count, p_data => x_msg_data);
113:
114: END INSERT_ROW;
115:
162: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
163: WHERE CONV_AUDIT_DETAIL_ID = X_CONV_AUDIT_DETAIL_ID;
164:
165:
166: FND_MSG_PUB.Count_AND_GET
167: (p_count => x_msg_count, p_data => x_msg_data);
168:
169: EXCEPTION
170:
173: IF (SQLCODE IS NOT NULL) THEN
174: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
175: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
176: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
177: FND_MSG_PUB.Add;
178: END IF;
179: FND_MSG_PUB.Count_AND_GET
180: (p_count => x_msg_count, p_data => x_msg_data);
181:
175: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
176: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
177: FND_MSG_PUB.Add;
178: END IF;
179: FND_MSG_PUB.Count_AND_GET
180: (p_count => x_msg_count, p_data => x_msg_data);
181:
182:
183: END UPDATE_ROW;