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 711: x_return_status := FND_API.G_RET_STS_SUCCESS;

707:
708: psa_utils.debug_other_string(g_state_level,l_api_name,'Product Uptaken SLA: '||l_sla_uptake_prod);
709:
710: -- Initialize API return status to success
711: x_return_status := FND_API.G_RET_STS_SUCCESS;
712:
713: -- Build query string for all products
714: psa_utils.debug_other_string(g_state_level,l_api_name,'Begin SQL Query String');
715: psa_utils.debug_other_string(g_state_level,l_api_name,'x_return_status: ' || x_return_status);

Line 3011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3007: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure build_report_query');
3008:
3009: EXCEPTION
3010: WHEN OTHERS THEN
3011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3012: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: ' || SQLERRM(sqlcode));
3013: RAISE;
3014: psa_utils.debug_other_string(g_excep_level,l_api_name,' ' || x_return_status);
3015: psa_utils.debug_other_string(g_excep_level,l_api_name,'x_report_query' || ' = ' ||x_report_query);

Line 3017: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3013: RAISE;
3014: psa_utils.debug_other_string(g_excep_level,l_api_name,' ' || x_return_status);
3015: psa_utils.debug_other_string(g_excep_level,l_api_name,'x_report_query' || ' = ' ||x_report_query);
3016:
3017: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3018: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
3019: psa_utils.debug_other_string(g_error_level,l_api_name,' ERROR IN QUERY STRING');
3020: RAISE FND_API.G_EXC_ERROR;
3021:

Line 3020: RAISE FND_API.G_EXC_ERROR;

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

Line 3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3022: ELSE
3023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3024: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
3025: psa_utils.debug_other_string(g_unexp_level,l_api_name,'UNEXPECTED ERROR IN QUERY STRING');
3026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3027: END IF;
3028:
3029: END build_report_query;
3030: -------------------------------------------------------------------------------

Line 3059: x_return_status := FND_API.G_RET_STS_SUCCESS;

3055: l_api_name := g_full_path||'get_xml';
3056: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure get_xml');
3057:
3058: -- Initialize API return status to success
3059: x_return_status := FND_API.G_RET_STS_SUCCESS;
3060:
3061: -- The value below is currently hard coded as a workaround. Hard coding should be removed later.
3062: -- l_char_set := 'UTF-8'; Removed for bug 6445210
3063:

Line 3100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3096:
3097:
3098: EXCEPTION
3099: WHEN OTHERS THEN
3100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3101: DBMS_XMLGEN.closecontext(l_ctx);
3102: psa_utils.debug_other_string(g_unexp_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3103: RAISE;
3104:

Line 3105: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3101: DBMS_XMLGEN.closecontext(l_ctx);
3102: psa_utils.debug_other_string(g_unexp_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3103: RAISE;
3104:
3105: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3106: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
3107: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR IN GET_XML');
3108: RAISE FND_API.G_EXC_ERROR;
3109: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3108: RAISE FND_API.G_EXC_ERROR;

3104:
3105: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3106: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
3107: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR IN GET_XML');
3108: RAISE FND_API.G_EXC_ERROR;
3109: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3110: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
3111: psa_utils.debug_other_string(g_unexp_level,l_api_name,' UNEXPECTED ERROR IN GET_XML');
3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3109: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3105: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3106: psa_utils.debug_other_string(g_error_level,l_api_name,' ' || x_return_status);
3107: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR IN GET_XML');
3108: RAISE FND_API.G_EXC_ERROR;
3109: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3110: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
3111: psa_utils.debug_other_string(g_unexp_level,l_api_name,' UNEXPECTED ERROR IN GET_XML');
3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3113: END IF;

Line 3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3108: RAISE FND_API.G_EXC_ERROR;
3109: ELSE x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3110: psa_utils.debug_other_string(g_unexp_level,l_api_name,' ' || x_return_status);
3111: psa_utils.debug_other_string(g_unexp_level,l_api_name,' UNEXPECTED ERROR IN GET_XML');
3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3113: END IF;
3114:
3115: END get_xml;
3116:

Line 3146: x_return_status := FND_API.G_RET_STS_SUCCESS;

3142:
3143: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure construct_bc_report_output');
3144:
3145: -- Initialize API return status to success
3146: x_return_status := FND_API.G_RET_STS_SUCCESS;
3147:
3148: -- Construct the parameter list section
3149: psa_utils.debug_other_string(g_state_level, l_api_name, 'Save the IN parameters in fnd log file');
3150:

Line 3244: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

3240: p_sequence_id => p_para_rec.sequence_id,
3241: p_trxs => p_trxs,
3242: p_offset => l_offset+2);
3243: END IF;
3244: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3245: RAISE FND_API.G_EXC_ERROR;
3246: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3248: END IF;

Line 3245: RAISE FND_API.G_EXC_ERROR;

3241: p_trxs => p_trxs,
3242: p_offset => l_offset+2);
3243: END IF;
3244: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3245: RAISE FND_API.G_EXC_ERROR;
3246: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3248: END IF;
3249:

Line 3246: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3242: p_offset => l_offset+2);
3243: END IF;
3244: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3245: RAISE FND_API.G_EXC_ERROR;
3246: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3248: END IF;
3249:
3250: FND_FILE.put_line(FND_FILE.output, '');

Line 3247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3243: END IF;
3244: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3245: RAISE FND_API.G_EXC_ERROR;
3246: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3248: END IF;
3249:
3250: FND_FILE.put_line(FND_FILE.output, '');
3251: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure construct_bc_report_output');

Line 3254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3250: FND_FILE.put_line(FND_FILE.output, '');
3251: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure construct_bc_report_output');
3252:
3253: EXCEPTION
3254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3256: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: ' || 'Unexpected Error in construct_bc_report_output Procedure');
3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3258:

Line 3255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3251: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure construct_bc_report_output');
3252:
3253: EXCEPTION
3254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3256: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: ' || 'Unexpected Error in construct_bc_report_output Procedure');
3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3258:
3259: WHEN FND_API.G_EXC_ERROR THEN

Line 3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3253: EXCEPTION
3254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3256: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: ' || 'Unexpected Error in construct_bc_report_output Procedure');
3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3258:
3259: WHEN FND_API.G_EXC_ERROR THEN
3260: x_return_status := FND_API.G_RET_STS_ERROR;
3261: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');

Line 3259: WHEN FND_API.G_EXC_ERROR THEN

3255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3256: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: ' || 'Unexpected Error in construct_bc_report_output Procedure');
3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3258:
3259: WHEN FND_API.G_EXC_ERROR THEN
3260: x_return_status := FND_API.G_RET_STS_ERROR;
3261: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');
3262: RAISE FND_API.G_EXC_ERROR;
3263: WHEN OTHERS THEN

Line 3260: x_return_status := FND_API.G_RET_STS_ERROR;

3256: psa_utils.debug_other_string(g_unexp_level,l_api_name,'ERROR: ' || 'Unexpected Error in construct_bc_report_output Procedure');
3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3258:
3259: WHEN FND_API.G_EXC_ERROR THEN
3260: x_return_status := FND_API.G_RET_STS_ERROR;
3261: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');
3262: RAISE FND_API.G_EXC_ERROR;
3263: WHEN OTHERS THEN
3264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3262: RAISE FND_API.G_EXC_ERROR;

3258:
3259: WHEN FND_API.G_EXC_ERROR THEN
3260: x_return_status := FND_API.G_RET_STS_ERROR;
3261: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');
3262: RAISE FND_API.G_EXC_ERROR;
3263: WHEN OTHERS THEN
3264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3265: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION:' || SQLERRM(sqlcode));
3266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3260: x_return_status := FND_API.G_RET_STS_ERROR;
3261: psa_utils.debug_other_string(g_error_level,l_api_name,'ERROR: ' || 'Error in construct_bc_report_output Procedure');
3262: RAISE FND_API.G_EXC_ERROR;
3263: WHEN OTHERS THEN
3264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3265: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION:' || SQLERRM(sqlcode));
3266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3267: END construct_bc_report_output;
3268:

Line 3266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3262: RAISE FND_API.G_EXC_ERROR;
3263: WHEN OTHERS THEN
3264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3265: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION:' || SQLERRM(sqlcode));
3266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3267: END construct_bc_report_output;
3268:
3269: -------------------------------------------------------------------------------
3270: -- PROCEDURE save_xml

Line 3303: x_return_status := FND_API.G_RET_STS_SUCCESS;

3299:
3300: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure save_xml');
3301:
3302: -- Initialize API return status to success
3303: x_return_status := FND_API.G_RET_STS_SUCCESS;
3304:
3305: l_length := DBMS_LOB.getlength(p_trxs);
3306:
3307: psa_utils.debug_other_string(g_state_level,l_api_name,'l_amount' || ' = ' || l_amount);

Line 3331: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3327: END LOOP;
3328:
3329: END IF;
3330:
3331: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3332: psa_utils.debug_other_string(g_state_level,l_api_name ,'"SUCCESSFUL" creation of XML Data Output');
3333: END IF;
3334:
3335: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml');

Line 3339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3335: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml');
3336:
3337: EXCEPTION
3338: WHEN OTHERS THEN
3339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3340: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3341: RAISE;
3342: END save_xml;
3343:

Line 3363: x_return_status := FND_API.G_RET_STS_SUCCESS;

3359: l_api_name := g_full_path||'save_xml_to_db';
3360: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure save_xml_to_db');
3361:
3362: -- Initialize API return status to success
3363: x_return_status := FND_API.G_RET_STS_SUCCESS;
3364:
3365: -- delete old data i.e. data for older expired sessions or created 1 day earlier
3366:
3367: DELETE FROM psa_bc_xml_clob pbxc

Line 3397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3393: psa_utils.debug_other_string(g_state_level,l_api_name,'end of procedure save_xml_to_db');
3394:
3395: EXCEPTION
3396: WHEN OTHERS THEN
3397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3398: psa_utils.debug_other_string(g_excep_level,l_api_name,'EXCEPTION: '|| SQLERRM(sqlcode));
3399: RAISE;
3400: END save_xml_to_db;
3401: END PSA_BC_XML_REPORT_PUB;