eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GL_POSTING dependencies on FND_MESSAGE

Line 211: FND_MESSAGE.SET_NAME('PQH','PQH_CMMT_XFER_BUDGET');

207:
208: -- If this Budget is marked as 'Transfer Commitments Only' then we cannot Transfer this budget
209: -- In that case we will end log and terminate the program
210: IF (nvl(g_psb_budget_flag,'N') ='Y') THEN
211: FND_MESSAGE.SET_NAME('PQH','PQH_CMMT_XFER_BUDGET');
212: l_message_text := FND_MESSAGE.GET;
213: populate_globals_error
214: (
215: p_message_text => l_message_text

Line 212: l_message_text := FND_MESSAGE.GET;

208: -- If this Budget is marked as 'Transfer Commitments Only' then we cannot Transfer this budget
209: -- In that case we will end log and terminate the program
210: IF (nvl(g_psb_budget_flag,'N') ='Y') THEN
211: FND_MESSAGE.SET_NAME('PQH','PQH_CMMT_XFER_BUDGET');
212: l_message_text := FND_MESSAGE.GET;
213: populate_globals_error
214: (
215: p_message_text => l_message_text
216: );

Line 474: FND_MESSAGE.SET_NAME('PQH','PQH_INV_BDG_VERSION_ID');

470:
471: IF l_budget_versions_rec.budget_version_id IS NULL THEN
472: -- no record fetched i.e invalid budget_version id
473: -- halt the program here
474: FND_MESSAGE.SET_NAME('PQH','PQH_INV_BDG_VERSION_ID');
475: APP_EXCEPTION.RAISE_EXCEPTION;
476: END IF;
477:
478: hr_utility.set_location('Step 2 ',6);

Line 484: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_ALREADY_POSTED');

480: -- check if budget version already posted
481: IF NVL(l_budget_versions_rec.gl_status,'X') = 'POST' THEN
482: -- this budget version is already posted
483: -- halt the program here
484: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_ALREADY_POSTED');
485: APP_EXCEPTION.RAISE_EXCEPTION;
486: END IF;
487:
488: -- set the version number

Line 530: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_GL_SET_BOOKS');

526: -- CHECK : if g_set_of_books_id IS NOT NULL
527: IF g_set_of_books_id IS NULL THEN
528: -- get message text for PQH_INVALID_GL_SET_BOOKS
529: -- message : Set of Books is not defined for the budget
530: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_GL_SET_BOOKS');
531: l_message_text_out := FND_MESSAGE.GET;
532:
533: IF l_error_flag = 'Y' THEN
534: -- there is already an error so append the message

Line 531: l_message_text_out := FND_MESSAGE.GET;

527: IF g_set_of_books_id IS NULL THEN
528: -- get message text for PQH_INVALID_GL_SET_BOOKS
529: -- message : Set of Books is not defined for the budget
530: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_GL_SET_BOOKS');
531: l_message_text_out := FND_MESSAGE.GET;
532:
533: IF l_error_flag = 'Y' THEN
534: -- there is already an error so append the message
535:

Line 556: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_BGT_CURR_CODE');

552: /*
553: commenting the code which used to give error, if currency on budget was null
554: -- get message text for PQH_INVALID_BGT_CURR_CODE
555: -- message : Currency Code is not defined for the budget
556: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_BGT_CURR_CODE');
557: l_message_text_out := FND_MESSAGE.GET;
558:
559: IF l_error_flag = 'Y' THEN
560: -- there is already an error so append the message

Line 557: l_message_text_out := FND_MESSAGE.GET;

553: commenting the code which used to give error, if currency on budget was null
554: -- get message text for PQH_INVALID_BGT_CURR_CODE
555: -- message : Currency Code is not defined for the budget
556: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_BGT_CURR_CODE');
557: l_message_text_out := FND_MESSAGE.GET;
558:
559: IF l_error_flag = 'Y' THEN
560: -- there is already an error so append the message
561:

Line 579: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_TRANSFER_FLAG');

575: IF NVL(l_transfer_to_gl_flag,'N') <> 'Y' THEN
576: -- get message text for PQH_BUDGET_TRANSFER_FLAG
577: -- message : This Budget cannot be transfered to GL. Please check the budget characteristics
578: IF NVL(g_transfer_to_grants_flag,'N') <> 'Y' THEN
579: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_TRANSFER_FLAG');
580: l_message_text_out := FND_MESSAGE.GET;
581: IF l_error_flag = 'Y' THEN
582: -- there is already an error so append the message
583:

Line 580: l_message_text_out := FND_MESSAGE.GET;

576: -- get message text for PQH_BUDGET_TRANSFER_FLAG
577: -- message : This Budget cannot be transfered to GL. Please check the budget characteristics
578: IF NVL(g_transfer_to_grants_flag,'N') <> 'Y' THEN
579: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_TRANSFER_FLAG');
580: l_message_text_out := FND_MESSAGE.GET;
581: IF l_error_flag = 'Y' THEN
582: -- there is already an error so append the message
583:
584: l_message_text := l_message_text||' **** '||l_message_text_out;

Line 604: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_COST_SEGMENT_NULL');

600:
601: -- get message text for PQH_BUDGET_GL_MAP
602: -- message : Some of the GL segments are not mapped with cost segments.
603: -- You must map all the GL segments with cost segments
604: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_COST_SEGMENT_NULL');
605: l_message_text_out := FND_MESSAGE.GET;
606:
607: IF l_error_flag = 'Y' THEN
608: -- there is already an error so append the message

Line 605: l_message_text_out := FND_MESSAGE.GET;

601: -- get message text for PQH_BUDGET_GL_MAP
602: -- message : Some of the GL segments are not mapped with cost segments.
603: -- You must map all the GL segments with cost segments
604: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_COST_SEGMENT_NULL');
605: l_message_text_out := FND_MESSAGE.GET;
606:
607: IF l_error_flag = 'Y' THEN
608: -- there is already an error so append the message
609:

Line 631: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_GL_MAP');

627: -- CHECK : count <> 0 i.e mapping is defined
628: IF NVL(l_count,0) = 0 THEN
629: -- get message text for PQH_BUDGET_GL_MAP
630: -- message : Mapping with GL segments not defined for the budget
631: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_GL_MAP');
632: l_message_text_out := FND_MESSAGE.GET;
633:
634: IF l_error_flag = 'Y' THEN
635: -- there is already an error so append the message

Line 632: l_message_text_out := FND_MESSAGE.GET;

628: IF NVL(l_count,0) = 0 THEN
629: -- get message text for PQH_BUDGET_GL_MAP
630: -- message : Mapping with GL segments not defined for the budget
631: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_GL_MAP');
632: l_message_text_out := FND_MESSAGE.GET;
633:
634: IF l_error_flag = 'Y' THEN
635: -- there is already an error so append the message
636:

Line 659: FND_MESSAGE.SET_NAME('PQH','PQH_GL_BUDGET_INVALID');

655: -- CHECK : if gl_budget_version_id exists else error
656: IF g_gl_budget_version_id IS NULL THEN
657: -- get message text for PQH_GL_BUDGET_INVALID
658: -- message : Budget is not defined in GL
659: FND_MESSAGE.SET_NAME('PQH','PQH_GL_BUDGET_INVALID');
660: l_message_text_out := FND_MESSAGE.GET;
661:
662: IF l_error_flag = 'Y' THEN
663: -- there is already an error so append the message

Line 660: l_message_text_out := FND_MESSAGE.GET;

656: IF g_gl_budget_version_id IS NULL THEN
657: -- get message text for PQH_GL_BUDGET_INVALID
658: -- message : Budget is not defined in GL
659: FND_MESSAGE.SET_NAME('PQH','PQH_GL_BUDGET_INVALID');
660: l_message_text_out := FND_MESSAGE.GET;
661:
662: IF l_error_flag = 'Y' THEN
663: -- there is already an error so append the message
664:

Line 704: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_JE_SOURCE_NAME');

700: -- CHECK : if g_user_je_source_name IS NOT NULL
701: IF g_user_je_source_name IS NULL THEN
702: -- get message text for PQH_INVALID_JE_SOURCE_NAME
703: -- message : Journal Source Name not defined
704: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_JE_SOURCE_NAME');
705: l_message_text_out := FND_MESSAGE.GET;
706:
707: IF l_error_flag = 'Y' THEN
708: -- there is already an error so append the message

Line 705: l_message_text_out := FND_MESSAGE.GET;

701: IF g_user_je_source_name IS NULL THEN
702: -- get message text for PQH_INVALID_JE_SOURCE_NAME
703: -- message : Journal Source Name not defined
704: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_JE_SOURCE_NAME');
705: l_message_text_out := FND_MESSAGE.GET;
706:
707: IF l_error_flag = 'Y' THEN
708: -- there is already an error so append the message
709:

Line 732: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_JE_CATEGORY_NAME');

728: -- CHECK : if g_user_je_category_name IS NOT NULL
729: IF g_user_je_category_name IS NULL THEN
730: -- get message text for PQH_INVALID_JE_CATEGORY_NAME
731: -- message : Journal Category Name not defined
732: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_JE_CATEGORY_NAME');
733: l_message_text_out := FND_MESSAGE.GET;
734:
735: IF l_error_flag = 'Y' THEN
736: -- there is already an error so append the message

Line 733: l_message_text_out := FND_MESSAGE.GET;

729: IF g_user_je_category_name IS NULL THEN
730: -- get message text for PQH_INVALID_JE_CATEGORY_NAME
731: -- message : Journal Category Name not defined
732: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_JE_CATEGORY_NAME');
733: l_message_text_out := FND_MESSAGE.GET;
734:
735: IF l_error_flag = 'Y' THEN
736: -- there is already an error so append the message
737:

Line 795: FND_MESSAGE.SET_NAME('PQH','PQH_EMPTY_BUDGET');

791: -- If the budget has details return 'Y' else 'N'
792:
793: l_budget_detail_result := pqh_gl_posting.chk_budget_details(p_budget_version_id => p_budget_version_id );
794: if l_budget_detail_result = 'N' then
795: FND_MESSAGE.SET_NAME('PQH','PQH_EMPTY_BUDGET');
796: l_message_text := FND_MESSAGE.GET;
797: populate_globals_error( p_message_text => l_message_text);
798: end if;
799:

Line 796: l_message_text := FND_MESSAGE.GET;

792:
793: l_budget_detail_result := pqh_gl_posting.chk_budget_details(p_budget_version_id => p_budget_version_id );
794: if l_budget_detail_result = 'N' then
795: FND_MESSAGE.SET_NAME('PQH','PQH_EMPTY_BUDGET');
796: l_message_text := FND_MESSAGE.GET;
797: populate_globals_error( p_message_text => l_message_text);
798: end if;
799:
800:

Line 1138: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_GL_BUDGET_PERIOD');

1134: );
1135:
1136: -- get message text for PQH_INVALID_GL_BUDGET_PERIOD
1137: -- message : There is no corresponding period in GL for the current Budget Period
1138: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_GL_BUDGET_PERIOD');
1139: l_message_text := FND_MESSAGE.GET;
1140:
1141: -- insert error
1142: pqh_process_batch_log.insert_log

Line 1139: l_message_text := FND_MESSAGE.GET;

1135:
1136: -- get message text for PQH_INVALID_GL_BUDGET_PERIOD
1137: -- message : There is no corresponding period in GL for the current Budget Period
1138: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_GL_BUDGET_PERIOD');
1139: l_message_text := FND_MESSAGE.GET;
1140:
1141: -- insert error
1142: pqh_process_batch_log.insert_log
1143: (

Line 1186: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_GL_BUDGET_ACCOUNT');

1182: );
1183:
1184: -- get message text for PQH_INVALID_GL_BUDGET_ACCOUNT
1185: -- message : There is no corresponding account in GL for the current funding source
1186: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_GL_BUDGET_ACCOUNT');
1187: l_message_text := FND_MESSAGE.GET;
1188:
1189: -- insert error
1190: pqh_process_batch_log.insert_log

Line 1187: l_message_text := FND_MESSAGE.GET;

1183:
1184: -- get message text for PQH_INVALID_GL_BUDGET_ACCOUNT
1185: -- message : There is no corresponding account in GL for the current funding source
1186: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_GL_BUDGET_ACCOUNT');
1187: l_message_text := FND_MESSAGE.GET;
1188:
1189: -- insert error
1190: pqh_process_batch_log.insert_log
1191: (

Line 1827: l_fc_message := fnd_message.get;

1823: -----------------------------------------------------------------
1824: -- STEP 1: Log the Error Message
1825: -----------------------------------------------------------------
1826: -- get the error message which is populated in case of fatal error i.e l_fc_return = T
1827: l_fc_message := fnd_message.get;
1828:
1829: -- if the above error message is null then get from result code
1830: IF l_fc_message IS NULL THEN
1831: OPEN csr_gl_packet_code(p_packet_id => l_packet_id);

Line 2870: message_text = fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED'),

2866: IF l_pqh_process_log_rec.message_type_cd <> 'ERROR'THEN
2867: -- no errors in the batch
2868: UPDATE pqh_process_log
2869: SET message_type_cd = 'COMPLETE',
2870: message_text = fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED'),
2871: txn_table_route_id = g_table_route_id_bvr,
2872: batch_status = l_status,
2873: batch_end_date = sysdate
2874: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

Line 5433: AND fnd.message_name = p_rejection_code

5429: UNION all
5430: SELECT message_text
5431: FROM fnd_new_messages fnd
5432: WHERE language_code = userenv('lang')
5433: AND fnd.message_name = p_rejection_code
5434: AND application_id = 275; -- PA
5435:
5436: l_message fnd_new_messages.message_text%Type;
5437: begin

Line 5501: p_message_text => FND_MESSAGE.get

5497: --
5498: hr_utility.set_message(8302,'PQH_TR_GMS_IMP_FAILED');
5499: populate_globals_error
5500: (
5501: p_message_text => FND_MESSAGE.get
5502: );
5503: RAISE g_error_exception;
5504: --
5505: ELSE

Line 5979: p_message_text => FND_MESSAGE.get

5975: IF not l_call_status THEN
5976: hr_utility.set_message(8302,'PQH_TR_GMS_IMP_FAILED');
5977: populate_globals_error
5978: (
5979: p_message_text => FND_MESSAGE.get
5980: );
5981: RAISE g_error_exception;
5982: END IF;
5983: END IF;

Line 5995: p_message_text => FND_MESSAGE.get

5991: hr_utility.set_message_token('VALUE',l_value);
5992: hr_utility.set_message_token('TABLE',l_table);
5993: populate_globals_error
5994: (
5995: p_message_text => FND_MESSAGE.get
5996: );
5997: RAISE g_error_exception;
5998:
5999: WHEN tran_setup_exception THEN

Line 6022: p_message_text => fnd_message.get

6018: -- insert error
6019: pqh_process_batch_log.insert_log
6020: (
6021: p_message_type_cd => 'ERROR',
6022: p_message_text => fnd_message.get
6023: );
6024: RAISE g_error_exception;
6025: WHEN g_error_exception THEN
6026: RAISE ;