DBA Data[Home] [Help]

APPS.IBE_M_IBC_INT_PVT dependencies on FND_MESSAGE

Line 292: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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;

Line 293: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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

Line 294: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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);

Line 295: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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);

Line 829: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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;

Line 830: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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

Line 831: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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);

Line 832: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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);

Line 1024: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

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;

Line 1025: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

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

Line 1026: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

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);

Line 1027: FND_MESSAGE.Set_Token('REASON', SQLERRM);

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);