288: p_data => x_msg_data,
289: p_encoded => 'F');
290: WHEN OTHERS THEN
291: ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
292: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
293: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
294: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
295: FND_MESSAGE.Set_Token('REASON', SQLERRM);
296: FND_MSG_PUB.Add;
289: p_encoded => 'F');
290: WHEN OTHERS THEN
291: ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
292: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
293: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
294: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
295: FND_MESSAGE.Set_Token('REASON', SQLERRM);
296: FND_MSG_PUB.Add;
297: IF (l_debug = 'Y') THEN
290: WHEN OTHERS THEN
291: ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
292: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
293: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
294: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
295: FND_MESSAGE.Set_Token('REASON', SQLERRM);
296: FND_MSG_PUB.Add;
297: IF (l_debug = 'Y') THEN
298: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
291: ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
292: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
293: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
294: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
295: FND_MESSAGE.Set_Token('REASON', SQLERRM);
296: FND_MSG_PUB.Add;
297: IF (l_debug = 'Y') THEN
298: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
299: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
825: p_data => x_msg_data,
826: p_encoded => 'F');
827: WHEN OTHERS THEN
828: ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
829: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
830: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
831: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
832: FND_MESSAGE.Set_Token('REASON', SQLERRM);
833: FND_MSG_PUB.Add;
826: p_encoded => 'F');
827: WHEN OTHERS THEN
828: ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
829: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
830: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
831: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
832: FND_MESSAGE.Set_Token('REASON', SQLERRM);
833: FND_MSG_PUB.Add;
834: IF (l_debug = 'Y') THEN
827: WHEN OTHERS THEN
828: ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
829: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
830: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
831: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
832: FND_MESSAGE.Set_Token('REASON', SQLERRM);
833: FND_MSG_PUB.Add;
834: IF (l_debug = 'Y') THEN
835: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
828: ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
829: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
830: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
831: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
832: FND_MESSAGE.Set_Token('REASON', SQLERRM);
833: FND_MSG_PUB.Add;
834: IF (l_debug = 'Y') THEN
835: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
836: IBE_UTIL.debug('SQLERRM:'||SQLERRM);
1020: p_data => x_msg_data,
1021: p_encoded => 'F');
1022: WHEN OTHERS THEN
1023: ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
1024: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1025: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1026: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1027: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1028: FND_MSG_PUB.Add;
1021: p_encoded => 'F');
1022: WHEN OTHERS THEN
1023: ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
1024: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1025: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1026: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1027: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1028: FND_MSG_PUB.Add;
1029: IF (l_debug = 'Y') THEN
1022: WHEN OTHERS THEN
1023: ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
1024: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1025: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1026: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1027: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1028: FND_MSG_PUB.Add;
1029: IF (l_debug = 'Y') THEN
1030: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
1023: ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
1024: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1025: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1026: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1027: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1028: FND_MSG_PUB.Add;
1029: IF (l_debug = 'Y') THEN
1030: IBE_UTIL.debug('SQLCODE:'||SQLCODE);
1031: IBE_UTIL.debug('SQLERRM:'||SQLERRM);