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 399: -- p_init_msg_list IN VARCHAR2 optional Default FND_API.G_FALSE

395: -- Description : Call SLA engine for BCPSA
396: --
397: -- Parameters :
398: -- IN : p_api_version IN NUMBER Required
399: -- p_init_msg_list IN VARCHAR2 optional Default FND_API.G_FALSE
400: -- p_commit IN VARCHAR2 optional Default FND_API.G_FALSE
401: -- p_application_id IN NUMBER Required
402: -- p_bc_mode IN NUMBER optional Possible values:Check(C ) /Reserve(R )
403: -- p_bc_override_flag VARCHAR2 optional Possible values: Y/N

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

396: --
397: -- Parameters :
398: -- IN : p_api_version IN NUMBER Required
399: -- p_init_msg_list IN VARCHAR2 optional Default FND_API.G_FALSE
400: -- p_commit IN VARCHAR2 optional Default FND_API.G_FALSE
401: -- p_application_id IN NUMBER Required
402: -- p_bc_mode IN NUMBER optional Possible values:Check(C ) /Reserve(R )
403: -- p_bc_override_flag VARCHAR2 optional Possible values: Y/N
404: -- p_user_id IN NUMBER optional

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

572: psa_utils.debug_other_string(g_state_level,l_path_name, 'Override Flag = ' ||p_override_flag);
573: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Id = ' ||p_user_id);
574: psa_utils.debug_other_string(g_state_level,l_path_name, 'User Responsibility Id = ' ||p_user_resp_id);
575:
576: IF (FND_API.to_boolean(p_init_msg_list)) THEN
577: FND_MSG_PUB.initialize;
578: END IF;
579:
580:

Line 597: RAISE Fnd_Api.G_Exc_Error;

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:
600: -- Currently the packetid is set to -1 , will change after SLA enhancement for PSA
601: x_packet_id := -1;

Line 615: RAISE Fnd_Api.G_Exc_Error;

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:
619: IF (l_override_flag IS NULL) THEN

Line 631: RAISE Fnd_Api.G_Exc_Error;

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;
634:
635: psa_utils.debug_other_string(g_state_level,l_path_name,'End of Parameter Validation');

Line 668: x_return_status := FND_API.G_RET_STS_SUCCESS;

664: -- Get the entity details ,
665: --- For each entity id SLA Accounting engine is invoked
666: --
667: l_accounting_events := FALSE;
668: x_return_status := FND_API.G_RET_STS_SUCCESS;
669: l_overall_success := TRUE;
670:
671:
672: SELECT count(*) INTO l_count

Line 704: Raise FND_API.G_EXC_ERROR;

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;
706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
708: RAISE FND_API.G_EXC_ERROR;

Line 707: WHEN FND_API.G_EXC_ERROR THEN

703:
704: Raise FND_API.G_EXC_ERROR;
705: END IF;
706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
708: RAISE FND_API.G_EXC_ERROR;
709: WHEN OTHERS THEN
710: x_status_code := 'FATAL';
711:

Line 708: RAISE FND_API.G_EXC_ERROR;

704: Raise FND_API.G_EXC_ERROR;
705: END IF;
706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 719: Raise FND_API.G_EXC_ERROR;

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;
721:
722:
723: ---------------------------------------------------------------

Line 741: Raise FND_API.G_EXC_ERROR;

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;
744:
745: --

Line 972: EXECUTE IMMEDIATE l_prepare_stmt USING OUT x_return_status, IN p_bc_mode, IN FND_API.G_FALSE;

968: -- Bug 12352531
969: l_prepare_stmt := 'BEGIN :1 := IGC_CBC_GL_FC_PKG.glzcbc(p_mode => :2, p_conc_proc => :3); END;';
970: psa_utils.debug_other_string(g_state_level,l_path_name, ' l_prepare_stmt -> ' || l_prepare_stmt );
971: IF (x_status_code IN('SUCCESS','ADVISORY')) THEN
972: EXECUTE IMMEDIATE l_prepare_stmt USING OUT x_return_status, IN p_bc_mode, IN FND_API.G_FALSE;
973: psa_utils.debug_other_string(g_state_level,l_path_name, ' x_return_status -> ' || x_return_status );
974:
975: IF x_return_status <> 1 THEN
976: IF x_return_status = -1 THEN

Line 985: EXECUTE IMMEDIATE l_prepare_stmt USING OUT x_return_status, IN 'M', IN FND_API.G_FALSE;

981: psa_funds_checker_pkg.sync_xla_errors(p_failed_ldgr_array => null, p_failed_evnt_array => l_failed_evnt_array);
982: END IF;
983:
984: ELSIF x_status_code IN('FAIL','PARTIAL') THEN
985: EXECUTE IMMEDIATE l_prepare_stmt USING OUT x_return_status, IN 'M', IN FND_API.G_FALSE;
986: psa_utils.debug_other_string(g_state_level,l_path_name, ' x_return_status -> ' || x_return_status );
987: END IF;
988: EXCEPTION
989: WHEN OTHERS THEN

Line 1009: WHEN FND_API.G_EXC_ERROR THEN

1005: psa_utils.debug_other_string(g_state_level,l_path_name, 'END of procedure budgetary_control ' );
1006:
1007: EXCEPTION
1008:
1009: WHEN FND_API.G_EXC_ERROR THEN
1010: x_return_status := FND_API.G_RET_STS_ERROR ;
1011: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1012: ,p_count => x_msg_count
1013: ,p_data => x_msg_data);

Line 1010: x_return_status := FND_API.G_RET_STS_ERROR ;

1006:
1007: EXCEPTION
1008:
1009: WHEN FND_API.G_EXC_ERROR THEN
1010: x_return_status := FND_API.G_RET_STS_ERROR ;
1011: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1012: ,p_count => x_msg_count
1013: ,p_data => x_msg_data);
1014: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));

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

1007: EXCEPTION
1008:
1009: WHEN FND_API.G_EXC_ERROR THEN
1010: x_return_status := FND_API.G_RET_STS_ERROR ;
1011: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1012: ,p_count => x_msg_count
1013: ,p_data => x_msg_data);
1014: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
1015: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in budgetary_control Procedure' );

Line 1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1014: psa_utils.debug_other_string(g_error_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
1015: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in budgetary_control Procedure' );
1016: pa_gms_tieback_api;
1017:
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020: psa_utils.debug_other_string(g_unexp_level,l_path_name, 'Unexpected Error'|| sqlerrm);
1021: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1022: ,p_count => x_msg_count

Line 1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1015: psa_utils.debug_other_string(g_error_level,l_path_name,'Error in budgetary_control Procedure' );
1016: pa_gms_tieback_api;
1017:
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020: psa_utils.debug_other_string(g_unexp_level,l_path_name, 'Unexpected Error'|| sqlerrm);
1021: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1022: ,p_count => x_msg_count
1023: ,p_data => x_msg_data);

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

1017:
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020: psa_utils.debug_other_string(g_unexp_level,l_path_name, 'Unexpected Error'|| sqlerrm);
1021: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1022: ,p_count => x_msg_count
1023: ,p_data => x_msg_data);
1024:
1025: psa_utils.debug_other_string(g_unexp_level,l_path_name,'ERROR: Unexpected Error in budgetary_control Procedure' );

Line 1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1024:
1025: psa_utils.debug_other_string(g_unexp_level,l_path_name,'ERROR: Unexpected Error in budgetary_control Procedure' );
1026: pa_gms_tieback_api;
1027: WHEN OTHERS THEN
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1030: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'PSA_BC_XLA_PVT');
1031: END IF;
1032: psa_utils.debug_unexpected_msg(G_PKG_NAME);

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

1029: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1030: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'PSA_BC_XLA_PVT');
1031: END IF;
1032: psa_utils.debug_unexpected_msg(G_PKG_NAME);
1033: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE
1034: ,p_count => x_msg_count
1035: ,p_data => x_msg_data);
1036: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
1037: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in budgetary_control Procedure' );

Line 1147: RAISE Fnd_Api.G_Exc_Error;

1143:
1144: IF l_r12_upgrade_date IS NULL THEN
1145: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value does not contain a value');
1146: psa_utils.debug_other_string(g_state_level,l_path_name,'Please check whether psar12upg.sql script was run');
1147: RAISE Fnd_Api.G_Exc_Error;
1148: END IF;
1149:
1150: psa_utils.debug_other_string(g_state_level,l_path_name,'Profile value = ' || to_char(l_r12_upgrade_date));
1151:

Line 1168: RAISE Fnd_Api.G_Exc_Error;

1164: FROM ap_invoice_distributions_all
1165: WHERE invoice_distribution_id = p_distribution_id;
1166: ELSE
1167: psa_utils.debug_other_string(g_state_level,l_path_name,'Invalid Distribution Link Type'|| p_dist_link_type);
1168: RAISE Fnd_Api.G_Exc_Error;
1169: END IF;
1170:
1171: psa_utils.debug_other_string(g_state_level,l_path_name,'Distribution CREATION_DATE = ' || to_char(l_dist_creation_date));
1172:

Line 1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1221: RETURN l_return_val;
1222: EXCEPTION
1223: WHEN others THEN
1224: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in function get_sla_notupgraded_flag' );
1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1226: END get_sla_notupgraded_flag;
1227:
1228: -- PA_GMS_INTEGRATION_API
1229: -- Created By : Tushar Pradhan

Line 1302: RAISE FND_API.G_EXC_ERROR;

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');
1305: END IF;
1306:

Line 1349: RAISE FND_API.G_EXC_ERROR;

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');
1352: END IF;
1353:

Line 1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1358: END;
1359: EXCEPTION
1360: WHEN others THEN
1361: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in pa_gms_integration_api' );
1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1363:
1364: END pa_gms_integration_api;
1365:
1366: PROCEDURE pa_gms_tieback_api IS

Line 1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1459: END;
1460: EXCEPTION
1461: WHEN others THEN
1462: psa_utils.debug_other_string(g_excep_level,l_path_name,'Error in pa_gms_tieback_api' );
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1464:
1465: END pa_gms_tieback_api;
1466:
1467: -----------------------------------------