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_XML_REPORT_PUB dependencies on FND_API

Line 114: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

110: p_para_rec => l_para_rec,
111: p_trxs => l_trxs);
112:
113:
114: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;
117: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure create_bc_report' );
118:

Line 115: RAISE FND_API.G_EXC_ERROR;

111: p_trxs => l_trxs);
112:
113:
114: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;
117: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure create_bc_report' );
118:
119: EXCEPTION

Line 120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

116: END IF;
117: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure create_bc_report' );
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
121: retcode := 2;
122: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: Unexpected Error in create_bc_report Procedure' );
123:
124: WHEN FND_API.G_EXC_ERROR THEN

Line 124: WHEN FND_API.G_EXC_ERROR THEN

120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
121: retcode := 2;
122: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: Unexpected Error in create_bc_report Procedure' );
123:
124: WHEN FND_API.G_EXC_ERROR THEN
125: retcode := 2;
126: psa_utils.debug_other_string(g_error_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
127: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in create_bc_report Procedure' );
128:

Line 244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

240: x_source => 'FORM',
241: p_para_rec => l_para_rec,
242: p_trxs => l_trxs);
243:
244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:
248: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure create_bc_transaction_report');

Line 245: RAISE FND_API.G_EXC_ERROR;

241: p_para_rec => l_para_rec,
242: p_trxs => l_trxs);
243:
244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:
248: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure create_bc_transaction_report');
249:

Line 251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

247:
248: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure create_bc_transaction_report');
249:
250: EXCEPTION
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: retcode := 2;
253: psa_utils.debug_other_string(g_unexp_level,l_api_name, 'ERROR: Unexpected Error in create_bc_report Procedure');
254:
255: WHEN FND_API.G_EXC_ERROR THEN

Line 255: WHEN FND_API.G_EXC_ERROR THEN

251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: retcode := 2;
253: psa_utils.debug_other_string(g_unexp_level,l_api_name, 'ERROR: Unexpected Error in create_bc_report Procedure');
254:
255: WHEN FND_API.G_EXC_ERROR THEN
256: retcode := 2;
257: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || SQLERRM(sqlcode));
258: psa_utils.debug_other_string(g_error_level,l_api_name,'Error in create_bc_report Procedure');
259:

Line 670: x_return_status := FND_API.G_RET_STS_SUCCESS;

666:
667: psa_utils.debug_other_string(g_state_level,l_api_name,'Product Uptaken SLA: '||l_sla_uptake_prod);
668:
669: -- Initialize API return status to success
670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671:
672: -- Build query string for all products
673: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin SQL Query String');
674: psa_utils.debug_other_string(g_state_level,l_api_name,'x_return_status: ' || x_return_status);

Line 2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2920: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure build_report_query');
2921:
2922: EXCEPTION
2923: WHEN OTHERS THEN
2924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2925: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: ' || SQLERRM(sqlcode));
2926: RAISE;
2927: psa_utils.debug_other_string(g_excep_level,l_api_name,' ' || x_return_status);
2928: psa_utils.debug_other_string(g_excep_level,l_api_name,'x_report_query' || ' = ' ||x_report_query);

Line 2930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2926: RAISE;
2927: psa_utils.debug_other_string(g_excep_level,l_api_name,' ' || x_return_status);
2928: psa_utils.debug_other_string(g_excep_level,l_api_name,'x_report_query' || ' = ' ||x_report_query);
2929:
2930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2931: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
2932: psa_utils.debug_other_string(g_error_level,l_api_name,' ERROR IN QUERY STRING');
2933: RAISE FND_API.G_EXC_ERROR;
2934:

Line 2933: RAISE FND_API.G_EXC_ERROR;

2929:
2930: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2931: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
2932: psa_utils.debug_other_string(g_error_level,l_api_name,' ERROR IN QUERY STRING');
2933: RAISE FND_API.G_EXC_ERROR;
2934:
2935: ELSE
2936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2937: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);

Line 2936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2932: psa_utils.debug_other_string(g_error_level,l_api_name,' ERROR IN QUERY STRING');
2933: RAISE FND_API.G_EXC_ERROR;
2934:
2935: ELSE
2936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2937: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
2938: psa_utils.debug_other_string(g_unexp_level,l_api_name,'UNEXPECTED ERROR IN QUERY STRING');
2939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2940: END IF;

Line 2939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2935: ELSE
2936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2937: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
2938: psa_utils.debug_other_string(g_unexp_level,l_api_name,'UNEXPECTED ERROR IN QUERY STRING');
2939: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2940: END IF;
2941:
2942: END build_report_query;
2943: -------------------------------------------------------------------------------

Line 2972: x_return_status := FND_API.G_RET_STS_SUCCESS;

2968: l_api_name := g_full_path||'get_xml';
2969: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure get_xml');
2970:
2971: -- Initialize API return status to success
2972: x_return_status := FND_API.G_RET_STS_SUCCESS;
2973:
2974: -- The value below is currently hard coded as a workaround. Hard coding should be removed later.
2975: -- l_char_set := 'UTF-8'; Removed for bug 6445210
2976:

Line 3013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3009:
3010:
3011: EXCEPTION
3012: WHEN OTHERS THEN
3013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3014: DBMS_XMLGEN.closecontext(l_ctx);
3015: psa_utils.debug_other_string(g_unexp_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3016: RAISE;
3017:

Line 3018: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3014: DBMS_XMLGEN.closecontext(l_ctx);
3015: psa_utils.debug_other_string(g_unexp_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3016: RAISE;
3017:
3018: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3019: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
3020: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR IN GET_XML');
3021: RAISE FND_API.G_EXC_ERROR;
3022: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3021: RAISE FND_API.G_EXC_ERROR;

3017:
3018: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3019: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
3020: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR IN GET_XML');
3021: RAISE FND_API.G_EXC_ERROR;
3022: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3023: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
3024: psa_utils.debug_other_string(g_unexp_level,l_api_name,' UNEXPECTED ERROR IN GET_XML');
3025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3022: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3018: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3019: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
3020: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR IN GET_XML');
3021: RAISE FND_API.G_EXC_ERROR;
3022: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3023: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
3024: psa_utils.debug_other_string(g_unexp_level,l_api_name,' UNEXPECTED ERROR IN GET_XML');
3025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3026: END IF;

Line 3025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3021: RAISE FND_API.G_EXC_ERROR;
3022: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3023: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
3024: psa_utils.debug_other_string(g_unexp_level,l_api_name,' UNEXPECTED ERROR IN GET_XML');
3025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3026: END IF;
3027:
3028: END get_xml;
3029:

Line 3059: x_return_status := FND_API.G_RET_STS_SUCCESS;

3055:
3056: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure construct_bc_report_output');
3057:
3058: -- Initialize API return status to success
3059: x_return_status := FND_API.G_RET_STS_SUCCESS;
3060:
3061: -- Construct the parameter list section
3062: psa_utils.debug_other_string(g_state_level, l_api_name, 'Save the IN parameters in fnd log file');
3063:

Line 3157: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3153: p_sequence_id => p_para_rec.sequence_id,
3154: p_trxs => p_trxs,
3155: p_offset => l_offset+2);
3156: END IF;
3157: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3158: RAISE FND_API.G_EXC_ERROR;
3159: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END IF;

Line 3158: RAISE FND_API.G_EXC_ERROR;

3154: p_trxs => p_trxs,
3155: p_offset => l_offset+2);
3156: END IF;
3157: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3158: RAISE FND_API.G_EXC_ERROR;
3159: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END IF;
3162:

Line 3159: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3155: p_offset => l_offset+2);
3156: END IF;
3157: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3158: RAISE FND_API.G_EXC_ERROR;
3159: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END IF;
3162:
3163: FND_FILE.put_line(FND_FILE.output, '');

Line 3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3156: END IF;
3157: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3158: RAISE FND_API.G_EXC_ERROR;
3159: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END IF;
3162:
3163: FND_FILE.put_line(FND_FILE.output, '');
3164: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure construct_bc_report_output');

Line 3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3163: FND_FILE.put_line(FND_FILE.output, '');
3164: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure construct_bc_report_output');
3165:
3166: EXCEPTION
3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3169: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: ' || 'Unexpected Error in construct_bc_report_output Procedure');
3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3171:

Line 3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3164: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure construct_bc_report_output');
3165:
3166: EXCEPTION
3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3169: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: ' || 'Unexpected Error in construct_bc_report_output Procedure');
3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN

Line 3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3166: EXCEPTION
3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3169: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: ' || 'Unexpected Error in construct_bc_report_output Procedure');
3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN
3173: x_return_status := FND_API.G_RET_STS_ERROR;
3174: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');

Line 3172: WHEN FND_API.G_EXC_ERROR THEN

3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3169: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: ' || 'Unexpected Error in construct_bc_report_output Procedure');
3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN
3173: x_return_status := FND_API.G_RET_STS_ERROR;
3174: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');
3175: RAISE FND_API.G_EXC_ERROR;
3176: WHEN OTHERS THEN

Line 3173: x_return_status := FND_API.G_RET_STS_ERROR;

3169: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: ' || 'Unexpected Error in construct_bc_report_output Procedure');
3170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3171:
3172: WHEN FND_API.G_EXC_ERROR THEN
3173: x_return_status := FND_API.G_RET_STS_ERROR;
3174: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');
3175: RAISE FND_API.G_EXC_ERROR;
3176: WHEN OTHERS THEN
3177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3175: RAISE FND_API.G_EXC_ERROR;

3171:
3172: WHEN FND_API.G_EXC_ERROR THEN
3173: x_return_status := FND_API.G_RET_STS_ERROR;
3174: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');
3175: RAISE FND_API.G_EXC_ERROR;
3176: WHEN OTHERS THEN
3177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3178: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION:' || SQLERRM(sqlcode));
3179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3173: x_return_status := FND_API.G_RET_STS_ERROR;
3174: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');
3175: RAISE FND_API.G_EXC_ERROR;
3176: WHEN OTHERS THEN
3177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3178: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION:' || SQLERRM(sqlcode));
3179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3180: END construct_bc_report_output;
3181:

Line 3179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3175: RAISE FND_API.G_EXC_ERROR;
3176: WHEN OTHERS THEN
3177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3178: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION:' || SQLERRM(sqlcode));
3179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3180: END construct_bc_report_output;
3181:
3182: -------------------------------------------------------------------------------
3183: -- PROCEDURE save_xml

Line 3216: x_return_status := FND_API.G_RET_STS_SUCCESS;

3212:
3213: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure save_xml');
3214:
3215: -- Initialize API return status to success
3216: x_return_status := FND_API.G_RET_STS_SUCCESS;
3217:
3218: l_length := DBMS_LOB.getlength(p_trxs);
3219:
3220: psa_utils.debug_other_string(g_state_level,l_api_name,'l_amount' || ' = ' || l_amount);

Line 3244: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3240: END LOOP;
3241:
3242: END IF;
3243:
3244: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3245: psa_utils.debug_other_string(g_state_level,l_api_name ,'"SUCCESSFUL" creation of XML Data Output');
3246: END IF;
3247:
3248: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml');

Line 3252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3248: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml');
3249:
3250: EXCEPTION
3251: WHEN OTHERS THEN
3252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3253: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3254: RAISE;
3255: END save_xml;
3256:

Line 3276: x_return_status := FND_API.G_RET_STS_SUCCESS;

3272: l_api_name := g_full_path||'save_xml_to_db';
3273: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure save_xml_to_db');
3274:
3275: -- Initialize API return status to success
3276: x_return_status := FND_API.G_RET_STS_SUCCESS;
3277:
3278: -- delete old data i.e. data for older expired sessions or created 1 day earlier
3279:
3280: DELETE FROM psa_bc_xml_clob pbxc

Line 3310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3306: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml_to_db');
3307:
3308: EXCEPTION
3309: WHEN OTHERS THEN
3310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3311: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3312: RAISE;
3313: END save_xml_to_db;
3314: END PSA_BC_XML_REPORT_PUB;