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

Line 95: x_return_status := FND_API.G_RET_STS_SUCCESS;

91: x_inventory_item_ids := '';
92: inv_item_id := NULL;
93: A := NULL;
94: i := NULL;
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96: x_msg_count := 0;
97:
98:
99:

Line 101: x_return_status := FND_API.G_RET_STS_SUCCESS; -- Added for bug 3848087

97:
98:
99:
100: BEGIN
101: x_return_status := FND_API.G_RET_STS_SUCCESS; -- Added for bug 3848087
102:
103: -- NULL;
104:
105:

Line 300: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087

296:
297:
298: EXCEPTION
299: WHEN NO_DATA_FOUND THEN
300: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087
301: x_msg_count := x_msg_count + 1;
302: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
303: WHEN TOO_MANY_ROWS THEN
304: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087

Line 304: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087

300: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087
301: x_msg_count := x_msg_count + 1;
302: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
303: WHEN TOO_MANY_ROWS THEN
304: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087
305: x_msg_count := x_msg_count + 1;
306: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
307:
308: END;

Line 316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- Added for bug 3848087

312: INTO l_object_type
313: FROM pa_proj_elements
314: WHERE proj_element_id = p_wbs_element_id;
315: EXCEPTION WHEN OTHERS THEN
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- Added for bug 3848087
317: x_msg_count := x_msg_count + 1;
318: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
319: END;
320:

Line 318: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');

314: WHERE proj_element_id = p_wbs_element_id;
315: EXCEPTION WHEN OTHERS THEN
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- Added for bug 3848087
317: x_msg_count := x_msg_count + 1;
318: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_GENERIC_MSG', p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
319: END;
320:
321: IF l_object_type = 'PA_STRUCTURES' THEN
322: -- in this case the selected proj_element_id is a structure

Line 391: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087

387: ;
388:
389: EXCEPTION
390: WHEN NO_DATA_FOUND THEN
391: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087
392: x_msg_count := x_msg_count + 1;
393: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
394:
395: WHEN OTHERS THEN

Line 396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- Added for bug 3848087

392: x_msg_count := x_msg_count + 1;
393: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
394:
395: WHEN OTHERS THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- Added for bug 3848087
397: x_msg_count := x_msg_count + 1;
398: Pji_Rep_Util.add_message(p_app_short_name=>'PJI',
399: p_msg_name=>'PJI_REP_GENERIC_MSG',
400: p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,

Line 400: p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,

396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- Added for bug 3848087
397: x_msg_count := x_msg_count + 1;
398: Pji_Rep_Util.add_message(p_app_short_name=>'PJI',
399: p_msg_name=>'PJI_REP_GENERIC_MSG',
400: p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,
401: p_token1=>'PROC_NAME',
402: p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
403:
404: END;

Line 415: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087

411: WHERE person_type_id = x_person_type_id;
412:
413: EXCEPTION
414: WHEN NO_DATA_FOUND THEN
415: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087
416: x_msg_count := x_msg_count + 1;
417: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
418:
419: WHEN OTHERS THEN

Line 420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- Added for bug 3848087

416: x_msg_count := x_msg_count + 1;
417: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
418:
419: WHEN OTHERS THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- Added for bug 3848087
421: x_msg_count := x_msg_count + 1;
422: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
423: p_msg_name=>'PJI_REP_GENERIC_MSG',
424: p_msg_type=>Pji_Rep_Util.G_RET_STS_WARNING,

Line 471: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087

467: --dbms_output.put_line('x_inventory_item_ids='||x_inventory_item_ids);
468:
469: EXCEPTION
470: WHEN NO_DATA_FOUND THEN
471: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087
472: x_msg_count := x_msg_count + 1;
473: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
474: NULL;
475: WHEN TOO_MANY_ROWS THEN

Line 476: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087

472: x_msg_count := x_msg_count + 1;
473: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
474: NULL;
475: WHEN TOO_MANY_ROWS THEN
476: x_return_status := FND_API.G_RET_STS_ERROR; -- Added for bug 3848087
477: x_msg_count := x_msg_count + 1;
478: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
479: NULL;
480: WHEN OTHERS THEN

Line 481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- Added for bug 3848087

477: x_msg_count := x_msg_count + 1;
478: pji_rep_util.add_message(p_app_short_name=> 'PJI',p_msg_name=> 'PJI_REP_SYSTEM_ERROR', p_msg_type=>Pji_Rep_Util.G_RET_STS_ERROR,p_token1=>'PROC_NAME',p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
479: NULL;
480: WHEN OTHERS THEN
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- Added for bug 3848087
482: x_msg_count := x_msg_count + 1;
483: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
484: p_msg_name=>'PJI_REP_GENERIC_MSG',
485: p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,

Line 485: p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,

481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- Added for bug 3848087
482: x_msg_count := x_msg_count + 1;
483: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
484: p_msg_name=>'PJI_REP_GENERIC_MSG',
485: p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,
486: p_token1=>'PROC_NAME',
487: p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.derive_parameters');
488:
489: END;

Line 521: x_return_status := FND_API.G_RET_STS_SUCCESS;

517: BEGIN
518:
519: x_show_events_flag := 'N';
520: x_show_costs_flag := 'Y';
521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522: x_msg_count := 0;
523:
524: BEGIN
525: SELECT object_type

Line 530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

526: INTO l_object_type
527: FROM pa_proj_elements
528: WHERE proj_element_id = p_wbs_element_id;
529: EXCEPTION WHEN OTHERS THEN
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: x_msg_count := x_msg_count + 1;
532: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
533: p_msg_name=>'PJI_REP_GENERIC_MSG',
534: p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,

Line 534: p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,

530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: x_msg_count := x_msg_count + 1;
532: Pji_Rep_Util.Add_Message(p_app_short_name=>'PJI',
533: p_msg_name=>'PJI_REP_GENERIC_MSG',
534: p_msg_type=>FND_API.G_RET_STS_UNEXP_ERROR,
535: p_token1=>'PROC_NAME',
536: p_token1_value=>'PJI_REP_DFLT_DRILLDOWN_TXN.determine_events_costs_display');
537: END;
538: