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.PSA_BC_XLA_PVT dependencies on FND_API

Line 88: -- p_init_msg_list IN VARCHAR2 optional Default FND_API.G_FALSE

84: -- Description : Call SLA engine for BCPSA
85: --
86: -- Parameters :
87: -- IN : p_api_version IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 optional Default FND_API.G_FALSE
89: -- p_commit IN VARCHAR2 optional Default FND_API.G_FALSE
90: -- p_application_id IN NUMBER Required
91: -- p_bc_mode IN NUMBER optional Possible values:Check(C ) /Reserve(R )
92: -- p_bc_override_flag VARCHAR2 optional Possible values: Y/N

Line 89: -- p_commit IN VARCHAR2 optional Default FND_API.G_FALSE

85: --
86: -- Parameters :
87: -- IN : p_api_version IN NUMBER Required
88: -- p_init_msg_list IN VARCHAR2 optional Default FND_API.G_FALSE
89: -- p_commit IN VARCHAR2 optional Default FND_API.G_FALSE
90: -- p_application_id IN NUMBER Required
91: -- p_bc_mode IN NUMBER optional Possible values:Check(C ) /Reserve(R )
92: -- p_bc_override_flag VARCHAR2 optional Possible values: Y/N
93: -- p_user_id IN NUMBER optional

Line 261: IF (FND_API.to_boolean(p_init_msg_list)) THEN

257: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);
258: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);
259: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);
260:
261: IF (FND_API.to_boolean(p_init_msg_list)) THEN
262: FND_MSG_PUB.initialize;
263: END IF;
264:
265:

Line 282: RAISE Fnd_Api.G_Exc_Error;

278: IF p_application_id IS NULL THEN
279: fnd_message.set_name('PSA','PSA_BC_PARAMETERS_ERROR');
280: fnd_message.set_token('PARAM_NAME','Application Id');
281: fnd_msg_pub.ADD;
282: RAISE Fnd_Api.G_Exc_Error;
283: END IF;
284:
285: -- Currently the packetid is set to -1 , will change after SLA enhancement for PSA
286: x_packet_id := -1;

Line 300: RAISE Fnd_Api.G_Exc_Error;

296: psa_utils.debug_other_msg(p_level => g_error_level,
297: p_full_path => l_path_name,
298: p_remove_from_stack => FALSE);
299: Fnd_file.put_line(fnd_file.log, fnd_message.get);
300: RAISE Fnd_Api.G_Exc_Error;
301: END IF;
302: END IF;
303:
304: IF (l_override_flag IS NULL) THEN

Line 316: RAISE Fnd_Api.G_Exc_Error;

312: p_full_path => l_path_name,
313: p_remove_from_stack => FALSE);
314: Fnd_file.put_line(fnd_file.log, fnd_message.get);
315:
316: RAISE Fnd_Api.G_Exc_Error;
317: END IF;
318: END IF;
319:
320: psa_utils.debug_other_string(g_state_level,l_path_name,'End of Parameter Validation');

Line 353: x_return_status := FND_API.G_RET_STS_SUCCESS;

349: -- Get the entity details ,
350: --- For each entity id SLA Accounting engine is invoked
351: --
352: l_accounting_events := FALSE;
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354: l_overall_success := TRUE;
355:
356:
357: SELECT count(*) INTO l_count

Line 392: Raise FND_API.G_EXC_ERROR;

388: x_status_code := 'FATAL';
389: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
390: Fnd_Message.Set_Token('PARAM_NAME','No Events to be processed');
391: Fnd_Msg_Pub.ADD;
392: Raise FND_API.G_EXC_ERROR;
393:
394: END IF;
395:
396: --

Line 590: x_return_status := IGC_CBC_GL_FC_PKG.glzcbc(p_mode => p_bc_mode, p_conc_proc => FND_API.G_FALSE);

586: IF p_application_id = 201 AND IGI_GEN.is_req_installed('CBC') = TRUE THEN
587: psa_utils.debug_other_string(g_state_level,l_path_name, 'CBC Installed');
588:
589: IF (x_status_code IN('SUCCESS','ADVISORY')) THEN
590: x_return_status := IGC_CBC_GL_FC_PKG.glzcbc(p_mode => p_bc_mode, p_conc_proc => FND_API.G_FALSE);
591:
592: IF x_return_status <> 1 THEN
593: IF x_return_status = -1 THEN
594: x_status_code := 'XLA_ERROR';

Line 602: x_return_status := IGC_CBC_GL_FC_PKG.glzcbc(p_mode => 'M', p_conc_proc => FND_API.G_FALSE);

598: psa_funds_checker_pkg.sync_xla_errors(p_failed_ldgr_array => null, p_failed_evnt_array => l_failed_evnt_array);
599: END IF;
600:
601: ELSIF x_status_code IN('FAIL','PARTIAL') THEN
602: x_return_status := IGC_CBC_GL_FC_PKG.glzcbc(p_mode => 'M', p_conc_proc => FND_API.G_FALSE);
603: END IF;
604:
605: END IF;
606:

Line 619: WHEN FND_API.G_EXC_ERROR THEN

615: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure budgetary_control ' );
616:
617: EXCEPTION
618:
619: WHEN FND_API.G_EXC_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_ERROR ;
621: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
622: ,p_count => x_msg_count
623: ,p_data => x_msg_data);

Line 620: x_return_status := FND_API.G_RET_STS_ERROR ;

616:
617: EXCEPTION
618:
619: WHEN FND_API.G_EXC_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_ERROR ;
621: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
622: ,p_count => x_msg_count
623: ,p_data => x_msg_data);
624: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));

Line 621: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE

617: EXCEPTION
618:
619: WHEN FND_API.G_EXC_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_ERROR ;
621: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
622: ,p_count => x_msg_count
623: ,p_data => x_msg_data);
624: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
625: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in budgetary_control Procedure' );

Line 628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

624: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
625: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in budgetary_control Procedure' );
626: pa_gms_tieback_api;
627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
630: psa_utils.debug_other_string(g_unexp_level,l_path_name, 'Unexpected Error'|| sqlerrm);
631: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
632: ,p_count => x_msg_count

Line 629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

625: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in budgetary_control Procedure' );
626: pa_gms_tieback_api;
627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
630: psa_utils.debug_other_string(g_unexp_level,l_path_name, 'Unexpected Error'|| sqlerrm);
631: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
632: ,p_count => x_msg_count
633: ,p_data => x_msg_data);

Line 631: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE

627:
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
630: psa_utils.debug_other_string(g_unexp_level,l_path_name, 'Unexpected Error'|| sqlerrm);
631: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
632: ,p_count => x_msg_count
633: ,p_data => x_msg_data);
634:
635: psa_utils.debug_other_string(g_unexp_level,l_path_name,'ERROR: Unexpected Error in budgetary_control Procedure' );

Line 638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

634:
635: psa_utils.debug_other_string(g_unexp_level,l_path_name,'ERROR: Unexpected Error in budgetary_control Procedure' );
636: pa_gms_tieback_api;
637: WHEN OTHERS THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
640: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'PSA_BC_XLA_PVT');
641: END IF;
642: psa_utils.debug_unexpected_msg(G_PKG_NAME);

Line 643: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE

639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
640: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'PSA_BC_XLA_PVT');
641: END IF;
642: psa_utils.debug_unexpected_msg(G_PKG_NAME);
643: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
644: ,p_count => x_msg_count
645: ,p_data => x_msg_data);
646: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
647: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in budgetary_control Procedure' );

Line 753: RAISE Fnd_Api.G_Exc_Error;

749:
750: IF l_r12_upgrade_date IS NULL THEN
751: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value does not contain a value');
752: psa_utils.debug_other_string(g_state_level,l_path_name,'Please check whether psar12upg.sql script was run');
753: RAISE Fnd_Api.G_Exc_Error;
754: END IF;
755:
756: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value = ' || to_char(l_r12_upgrade_date));
757:

Line 774: RAISE Fnd_Api.G_Exc_Error;

770: FROM ap_invoice_distributions_all
771: WHERE invoice_distribution_id = p_distribution_id;
772: ELSE
773: psa_utils.debug_other_string(g_state_level,l_path_name,'Invalid Distribution Link Type'|| p_dist_link_type);
774: RAISE Fnd_Api.G_Exc_Error;
775: END IF;
776:
777: psa_utils.debug_other_string(g_state_level,l_path_name,'Distribution CREATION_DATE = ' || to_char(l_dist_creation_date));
778:

Line 822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

818: RETURN l_return_val;
819: EXCEPTION
820: WHEN others THEN
821: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in function get_sla_notupgraded_flag' );
822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
823: END get_sla_notupgraded_flag;
824:
825:
826: -- PA_GMS_INTEGRATION_API

Line 900: RAISE FND_API.G_EXC_ERROR;

896: IF (l_ret_code = 'F') THEN
897: psa_utils.debug_other_string(g_error_level,l_path_name, 'PA Integration API Failed');
898: FND_MESSAGE.SET_NAME('PA', 'PA_BC_FUND_CHK_FAIL');
899: FND_MSG_PUB.ADD;
900: RAISE FND_API.G_EXC_ERROR;
901: ELSE
902: psa_utils.debug_other_string(g_state_level,l_path_name, 'PA Integration API Successful');
903: END IF;
904:

Line 947: RAISE FND_API.G_EXC_ERROR;

943: IF (l_ret_code = 'F') THEN
944: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Integration API Failed');
945: FND_MESSAGE.SET_NAME('GMS', 'GMS_FUNDS_CHECK_FAILED');
946: FND_MSG_PUB.ADD;
947: RAISE FND_API.G_EXC_ERROR;
948: ELSE
949: psa_utils.debug_other_string(g_state_level,l_path_name, 'GMS Integration API Successful');
950: END IF;
951:

Line 960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

956: END;
957: EXCEPTION
958: WHEN others THEN
959: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in pa_gms_integration_api' );
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961:
962: END pa_gms_integration_api;
963:
964: PROCEDURE pa_gms_tieback_api IS

Line 1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1057: END;
1058: EXCEPTION
1059: WHEN others THEN
1060: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in pa_gms_tieback_api' );
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062:
1063: END pa_gms_tieback_api;
1064:
1065: -----------------------------------------