DBA Data[Home] [Help]

APPS.PSA_BC_XLA_PVT dependencies on FND_MESSAGE

Line 210: l_psa_xla_accounting_errors.encoded_msg := fnd_message.get;

206: AND e.entity_id = t.entity_id
207: AND p.event_id = NVL(p_event_id, p.event_id)) LOOP
208:
209: l_psa_xla_accounting_errors.message_code := p_message_code;
210: l_psa_xla_accounting_errors.encoded_msg := fnd_message.get;
211: l_psa_xla_accounting_errors.audsid := g_audsid;
212: l_psa_xla_accounting_errors.creation_date := SYSDATE;
213: l_psa_xla_accounting_errors.created_by := g_user_id;
214: l_psa_xla_accounting_errors.entity_id := event_rec.entity_id;

Line 337: fnd_message.set_name ('XLA','XLA_AP_PAD_INACTIVE');

333: AND r.product_rule_type_code = ru.product_rule_type_code
334: AND e.event_date BETWEEN r.start_date_active AND NVL(r.end_date_active, e.event_date+1)) LOOP
335: psa_utils.debug_other_string(g_state_level,l_path_name, 'compile_status_code='||xla_rec.compile_status_code);
336: IF xla_rec.compile_status_code <> 'Y' THEN
337: fnd_message.set_name ('XLA','XLA_AP_PAD_INACTIVE');
338: fnd_message.set_token ('PAD_NAME', xla_rec.product_rule_name);
339: fnd_message.set_token ('OWNER', xla_lookups_pkg.get_meaning('XLA_OWNER_TYPE',xla_rec.product_rule_owner));
340: fnd_message.set_token ('SUBLEDGER_ACCTG_METHOD', xla_accounting_cache_pkg.GetSessionValueChar
341: (p_source_code => 'XLA_ACCOUNTING_METHOD_NAME'

Line 338: fnd_message.set_token ('PAD_NAME', xla_rec.product_rule_name);

334: AND e.event_date BETWEEN r.start_date_active AND NVL(r.end_date_active, e.event_date+1)) LOOP
335: psa_utils.debug_other_string(g_state_level,l_path_name, 'compile_status_code='||xla_rec.compile_status_code);
336: IF xla_rec.compile_status_code <> 'Y' THEN
337: fnd_message.set_name ('XLA','XLA_AP_PAD_INACTIVE');
338: fnd_message.set_token ('PAD_NAME', xla_rec.product_rule_name);
339: fnd_message.set_token ('OWNER', xla_lookups_pkg.get_meaning('XLA_OWNER_TYPE',xla_rec.product_rule_owner));
340: fnd_message.set_token ('SUBLEDGER_ACCTG_METHOD', xla_accounting_cache_pkg.GetSessionValueChar
341: (p_source_code => 'XLA_ACCOUNTING_METHOD_NAME'
342: ,p_target_ledger_id => xla_rec.ledger_id));

Line 339: fnd_message.set_token ('OWNER', xla_lookups_pkg.get_meaning('XLA_OWNER_TYPE',xla_rec.product_rule_owner));

335: psa_utils.debug_other_string(g_state_level,l_path_name, 'compile_status_code='||xla_rec.compile_status_code);
336: IF xla_rec.compile_status_code <> 'Y' THEN
337: fnd_message.set_name ('XLA','XLA_AP_PAD_INACTIVE');
338: fnd_message.set_token ('PAD_NAME', xla_rec.product_rule_name);
339: fnd_message.set_token ('OWNER', xla_lookups_pkg.get_meaning('XLA_OWNER_TYPE',xla_rec.product_rule_owner));
340: fnd_message.set_token ('SUBLEDGER_ACCTG_METHOD', xla_accounting_cache_pkg.GetSessionValueChar
341: (p_source_code => 'XLA_ACCOUNTING_METHOD_NAME'
342: ,p_target_ledger_id => xla_rec.ledger_id));
343:

Line 340: fnd_message.set_token ('SUBLEDGER_ACCTG_METHOD', xla_accounting_cache_pkg.GetSessionValueChar

336: IF xla_rec.compile_status_code <> 'Y' THEN
337: fnd_message.set_name ('XLA','XLA_AP_PAD_INACTIVE');
338: fnd_message.set_token ('PAD_NAME', xla_rec.product_rule_name);
339: fnd_message.set_token ('OWNER', xla_lookups_pkg.get_meaning('XLA_OWNER_TYPE',xla_rec.product_rule_owner));
340: fnd_message.set_token ('SUBLEDGER_ACCTG_METHOD', xla_accounting_cache_pkg.GetSessionValueChar
341: (p_source_code => 'XLA_ACCOUNTING_METHOD_NAME'
342: ,p_target_ledger_id => xla_rec.ledger_id));
343:
344: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling psa_xla_error');

Line 594: fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');

590: --
591: -- parameter validations
592: --
593: IF p_application_id IS NULL THEN
594: fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');
595: fnd_message.set_token('PARAM_NAME','Application Id');
596: fnd_msg_pub.ADD;
597: RAISE Fnd_Api.G_Exc_Error;
598: END IF;

Line 595: fnd_message.set_token('PARAM_NAME','Application Id');

591: -- parameter validations
592: --
593: IF p_application_id IS NULL THEN
594: fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');
595: fnd_message.set_token('PARAM_NAME','Application Id');
596: fnd_msg_pub.ADD;
597: RAISE Fnd_Api.G_Exc_Error;
598: END IF;
599:

Line 608: Fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');

604: IF (l_bc_mode IS NULL) THEN
605: l_bc_mode :=C_FUNDS_CHECK;
606: ELSE
607: IF (l_bc_mode NOT IN (C_FUNDS_CHECK,C_FUNDS_CHK_FULL,C_FUNDS_RESERVE,C_FUNDS_PARTIAL,C_FUNDS_FORCE_PASS,C_FUNDS_ADVISORY)) THEN
608: Fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');
609: Fnd_Message.Set_Token('PARAM_NAME','Funds Mode');
610: Fnd_Msg_Pub.ADD;
611: psa_utils.debug_other_msg(p_level => g_error_level,
612: p_full_path => l_path_name,

Line 609: Fnd_Message.Set_Token('PARAM_NAME','Funds Mode');

605: l_bc_mode :=C_FUNDS_CHECK;
606: ELSE
607: IF (l_bc_mode NOT IN (C_FUNDS_CHECK,C_FUNDS_CHK_FULL,C_FUNDS_RESERVE,C_FUNDS_PARTIAL,C_FUNDS_FORCE_PASS,C_FUNDS_ADVISORY)) THEN
608: Fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');
609: Fnd_Message.Set_Token('PARAM_NAME','Funds Mode');
610: Fnd_Msg_Pub.ADD;
611: psa_utils.debug_other_msg(p_level => g_error_level,
612: p_full_path => l_path_name,
613: p_remove_from_stack => FALSE);

Line 614: Fnd_file.put_line(fnd_file.log, fnd_message.get);

610: Fnd_Msg_Pub.ADD;
611: psa_utils.debug_other_msg(p_level => g_error_level,
612: p_full_path => l_path_name,
613: p_remove_from_stack => FALSE);
614: Fnd_file.put_line(fnd_file.log, fnd_message.get);
615: RAISE Fnd_Api.G_Exc_Error;
616: END IF;
617: END IF;
618:

Line 623: Fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');

619: IF (l_override_flag IS NULL) THEN
620: l_override_flag := C_NO ;
621: ELSE
622: IF (l_override_flag NOT IN (C_YES,C_NO)) THEN
623: Fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');
624: Fnd_Message.Set_Token('PARAM_NAME','Override Flag');
625: Fnd_Msg_Pub.ADD;
626: psa_utils.debug_other_msg(p_level => g_error_level,
627: p_full_path => l_path_name,

Line 624: Fnd_Message.Set_Token('PARAM_NAME','Override Flag');

620: l_override_flag := C_NO ;
621: ELSE
622: IF (l_override_flag NOT IN (C_YES,C_NO)) THEN
623: Fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');
624: Fnd_Message.Set_Token('PARAM_NAME','Override Flag');
625: Fnd_Msg_Pub.ADD;
626: psa_utils.debug_other_msg(p_level => g_error_level,
627: p_full_path => l_path_name,
628: p_remove_from_stack => FALSE);

Line 629: Fnd_file.put_line(fnd_file.log, fnd_message.get);

625: Fnd_Msg_Pub.ADD;
626: psa_utils.debug_other_msg(p_level => g_error_level,
627: p_full_path => l_path_name,
628: p_remove_from_stack => FALSE);
629: Fnd_file.put_line(fnd_file.log, fnd_message.get);
630:
631: RAISE Fnd_Api.G_Exc_Error;
632: END IF;
633: END IF;

Line 697: fnd_message.set_name('PSA','PSA_XLA_NO_R12_UPG_DATE');

693:
694: IF l_r12_upgrade_date IS NULL THEN
695: x_status_code := 'FATAL';
696:
697: fnd_message.set_name('PSA','PSA_XLA_NO_R12_UPG_DATE');
698: psa_xla_error('PSA_XLA_NO_R12_UPG_DATE');
699:
700: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
701: Fnd_Message.Set_Token('PARAM_NAME','Profile PSA: R12 Upgrade Date does not have a value');

Line 700: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');

696:
697: fnd_message.set_name('PSA','PSA_XLA_NO_R12_UPG_DATE');
698: psa_xla_error('PSA_XLA_NO_R12_UPG_DATE');
699:
700: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
701: Fnd_Message.Set_Token('PARAM_NAME','Profile PSA: R12 Upgrade Date does not have a value');
702: Fnd_Msg_Pub.ADD;
703:
704: Raise FND_API.G_EXC_ERROR;

Line 701: Fnd_Message.Set_Token('PARAM_NAME','Profile PSA: R12 Upgrade Date does not have a value');

697: fnd_message.set_name('PSA','PSA_XLA_NO_R12_UPG_DATE');
698: psa_xla_error('PSA_XLA_NO_R12_UPG_DATE');
699:
700: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
701: Fnd_Message.Set_Token('PARAM_NAME','Profile PSA: R12 Upgrade Date does not have a value');
702: Fnd_Msg_Pub.ADD;
703:
704: Raise FND_API.G_EXC_ERROR;
705: END IF;

Line 712: fnd_message.set_name('PSA','PSA_XLA_INVALID_R12_UPG_DATE');

708: RAISE FND_API.G_EXC_ERROR;
709: WHEN OTHERS THEN
710: x_status_code := 'FATAL';
711:
712: fnd_message.set_name('PSA','PSA_XLA_INVALID_R12_UPG_DATE');
713: psa_xla_error('PSA_XLA_INVALID_R12_UPG_DATE');
714:
715: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
716: Fnd_Message.Set_Token('PARAM_NAME','Format for Value in Profile PSA: R12 Upgrade Date should be MM/DD/YYYY HH24:MI:SS');

Line 715: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');

711:
712: fnd_message.set_name('PSA','PSA_XLA_INVALID_R12_UPG_DATE');
713: psa_xla_error('PSA_XLA_INVALID_R12_UPG_DATE');
714:
715: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
716: Fnd_Message.Set_Token('PARAM_NAME','Format for Value in Profile PSA: R12 Upgrade Date should be MM/DD/YYYY HH24:MI:SS');
717: Fnd_Msg_Pub.ADD;
718:
719: Raise FND_API.G_EXC_ERROR;

Line 716: Fnd_Message.Set_Token('PARAM_NAME','Format for Value in Profile PSA: R12 Upgrade Date should be MM/DD/YYYY HH24:MI:SS');

712: fnd_message.set_name('PSA','PSA_XLA_INVALID_R12_UPG_DATE');
713: psa_xla_error('PSA_XLA_INVALID_R12_UPG_DATE');
714:
715: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
716: Fnd_Message.Set_Token('PARAM_NAME','Format for Value in Profile PSA: R12 Upgrade Date should be MM/DD/YYYY HH24:MI:SS');
717: Fnd_Msg_Pub.ADD;
718:
719: Raise FND_API.G_EXC_ERROR;
720: END;

Line 738: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');

734:
735: IF l_count < 1 THEN
736:
737: x_status_code := 'FATAL';
738: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
739: Fnd_Message.Set_Token('PARAM_NAME','No Events to be processed');
740: Fnd_Msg_Pub.ADD;
741: Raise FND_API.G_EXC_ERROR;
742:

Line 739: Fnd_Message.Set_Token('PARAM_NAME','No Events to be processed');

735: IF l_count < 1 THEN
736:
737: x_status_code := 'FATAL';
738: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
739: Fnd_Message.Set_Token('PARAM_NAME','No Events to be processed');
740: Fnd_Msg_Pub.ADD;
741: Raise FND_API.G_EXC_ERROR;
742:
743: END IF;

Line 835: --Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');

831:
832: IF l_retcode = 2 THEN
833: psa_utils.debug_other_string(g_state_level,l_path_name, 'ERROR returned in SLA Accounting Engine API');
834: l_overall_success := FALSE;
835: --Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
836: --Fnd_Message.Set_Token('PARAM_NAME',l_errbuf);
837: --Fnd_Msg_Pub.ADD;
838: -- update the psa_bc_xla_events_gt event records to
839: -- XLA_ERROR status

Line 836: --Fnd_Message.Set_Token('PARAM_NAME',l_errbuf);

832: IF l_retcode = 2 THEN
833: psa_utils.debug_other_string(g_state_level,l_path_name, 'ERROR returned in SLA Accounting Engine API');
834: l_overall_success := FALSE;
835: --Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
836: --Fnd_Message.Set_Token('PARAM_NAME',l_errbuf);
837: --Fnd_Msg_Pub.ADD;
838: -- update the psa_bc_xla_events_gt event records to
839: -- XLA_ERROR status
840: UPDATE psa_bc_xla_events_gt

Line 906: fnd_message.set_name ('PSA','PSA_XLA_NO_JOURNAL');

902:
903: FOR event_list_rec IN (SELECT *
904: FROM PSA_BC_XLA_EVENTS_GT
905: WHERE upper(result_code) = 'XLA_NO_JOURNAL') LOOP
906: fnd_message.set_name ('PSA','PSA_XLA_NO_JOURNAL');
907: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling psa_xla_error');
908: psa_xla_error
909: (
910: p_message_code => 'PSA_XLA_NO_JOURNAL',

Line 1300: FND_MESSAGE.SET_NAME('PA', 'PA_BC_FUND_CHK_FAIL');

1296: IN l_bc_mode,
1297: OUT l_ret_code;
1298: IF (l_ret_code = 'F') THEN
1299: psa_utils.debug_other_string(g_error_level,l_path_name, 'PA Integration API Failed');
1300: FND_MESSAGE.SET_NAME('PA', 'PA_BC_FUND_CHK_FAIL');
1301: FND_MSG_PUB.ADD;
1302: RAISE FND_API.G_EXC_ERROR;
1303: ELSE
1304: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA Integration API Successful');

Line 1347: FND_MESSAGE.SET_NAME('GMS', 'GMS_FUNDS_CHECK_FAILED');

1343: IN l_partial_resv_flag,
1344: OUT l_ret_code;
1345: IF (l_ret_code = 'F') THEN
1346: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Integration API Failed');
1347: FND_MESSAGE.SET_NAME('GMS', 'GMS_FUNDS_CHECK_FAILED');
1348: FND_MSG_PUB.ADD;
1349: RAISE FND_API.G_EXC_ERROR;
1350: ELSE
1351: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Integration API Successful');