DBA Data[Home] [Help]

APPS.PSP_NON_ORCL_RLBK_PKG dependencies on FND_MESSAGE

Line 43: fnd_message.set_name('PSP','PSP_NON_ORCL_RLBK');

39: retcode := FND_API.G_RET_STS_SUCCESS;
40: PSP_MESSAGE_S.Print_Success;
41: --dbms_output.put_line('after calling the change_record procedure');
42: ELSE
43: fnd_message.set_name('PSP','PSP_NON_ORCL_RLBK');
44: fnd_message.set_token('BATCH_NAME',p_Batch_Name);
45: fnd_msg_pub.add;
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: --dbms_output.put_line('......The BAtch Name Does not exists');

Line 44: fnd_message.set_token('BATCH_NAME',p_Batch_Name);

40: PSP_MESSAGE_S.Print_Success;
41: --dbms_output.put_line('after calling the change_record procedure');
42: ELSE
43: fnd_message.set_name('PSP','PSP_NON_ORCL_RLBK');
44: fnd_message.set_token('BATCH_NAME',p_Batch_Name);
45: fnd_msg_pub.add;
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: --dbms_output.put_line('......The BAtch Name Does not exists');
48: END IF;

Line 53: fnd_message.set_name('PSP','PSP_NON_ORCL_RLBK_EXCP');

49: END LOOP;
50:
51: EXCEPTION
52: WHEN NO_DATA_FOUND THEN
53: fnd_message.set_name('PSP','PSP_NON_ORCL_RLBK_EXCP');
54: fnd_message.set_token('BATCH_NAME',p_Batch_Name);
55: fnd_msg_pub.add;
56: --dbms_output.put_line('No data found for the particular batch_name');
57:

Line 54: fnd_message.set_token('BATCH_NAME',p_Batch_Name);

50:
51: EXCEPTION
52: WHEN NO_DATA_FOUND THEN
53: fnd_message.set_name('PSP','PSP_NON_ORCL_RLBK_EXCP');
54: fnd_message.set_token('BATCH_NAME',p_Batch_Name);
55: fnd_msg_pub.add;
56: --dbms_output.put_line('No data found for the particular batch_name');
57:
58: retcode := 2;

Line 64: fnd_message.set_name('PSP','PSP_NON_ORCL_RLBK_EXCP');

60: p_print_header => FND_API.G_TRUE);
61: return;
62:
63: WHEN OTHERS THEN
64: fnd_message.set_name('PSP','PSP_NON_ORCL_RLBK_EXCP');
65: fnd_message.set_token('BATCH_NAME',p_Batch_Name);
66: fnd_msg_pub.add;
67: --dbms_output.put_line('Query raised unhandled exceptions');
68:

Line 65: fnd_message.set_token('BATCH_NAME',p_Batch_Name);

61: return;
62:
63: WHEN OTHERS THEN
64: fnd_message.set_name('PSP','PSP_NON_ORCL_RLBK_EXCP');
65: fnd_message.set_token('BATCH_NAME',p_Batch_Name);
66: fnd_msg_pub.add;
67: --dbms_output.put_line('Query raised unhandled exceptions');
68:
69: retcode := 2;