73: X_LAST_UPDATE_DATE,
74: X_LAST_UPDATE_LOGIN
75: );
76:
77: FND_MSG_PUB.Count_AND_GET
78: (p_count => x_msg_count, p_data => x_msg_data);
79:
80: EXCEPTION
81:
84: IF (SQLCODE IS NOT NULL) THEN
85: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
86: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
87: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
88: FND_MSG_PUB.Add;
89: END IF;
90: FND_MSG_PUB.Count_AND_GET
91: (p_count => x_msg_count, p_data => x_msg_data);
92:
86: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
87: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
88: FND_MSG_PUB.Add;
89: END IF;
90: FND_MSG_PUB.Count_AND_GET
91: (p_count => x_msg_count, p_data => x_msg_data);
92:
93: END INSERT_ROW;
94:
129: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
130: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
131: WHERE CONV_AUDIT_ID = X_CONV_AUDIT_ID;
132:
133: FND_MSG_PUB.Count_AND_GET
134: (p_count => x_msg_count, p_data => x_msg_data);
135:
136: EXCEPTION
137:
141: IF (SQLCODE IS NOT NULL) THEN
142: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
143: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
144: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
145: FND_MSG_PUB.Add;
146: END IF;
147: FND_MSG_PUB.Count_AND_GET
148: (p_count => x_msg_count, p_data => x_msg_data);
149:
143: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
144: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
145: FND_MSG_PUB.Add;
146: END IF;
147: FND_MSG_PUB.Count_AND_GET
148: (p_count => x_msg_count, p_data => x_msg_data);
149:
150:
151: END UPDATE_ROW;