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.PA_CAPITAL_EVENTS_PVT dependencies on PA_CAPITAL_EVENTS

Line 1: PACKAGE BODY PA_CAPITAL_EVENTS_PVT AS

1: PACKAGE BODY PA_CAPITAL_EVENTS_PVT AS
2: /* $Header: PACACCBB.pls 120.1 2005/06/10 03:22:22 avajain noship $ */
3:
4:
5: PROCEDURE CREATE_PERIODIC_EVENTS

Line 497: PA_CAPITAL_EVENTS_PVT.CREATE_EVENT_FOR_PROJECT

493: END IF;
494:
495:
496:
497: PA_CAPITAL_EVENTS_PVT.CREATE_EVENT_FOR_PROJECT
498: (errbuf => errbuf,
499: retcode => retcode,
500: p_event_period_name => p_event_period_name,
501: p_asset_date_through => p_asset_date_through,

Line 526: PA_CAPITAL_EVENTS_PVT.CREATE_EVENT_FOR_PROJECT

522:
523:
524: IF (v_ret_tasks_count > 0) OR (v_ret_assets_count > 0) THEN
525:
526: PA_CAPITAL_EVENTS_PVT.CREATE_EVENT_FOR_PROJECT
527: (errbuf => errbuf,
528: retcode => retcode,
529: p_event_period_name => p_event_period_name,
530: p_asset_date_through => p_asset_date_through,

Line 557: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CAPITAL_EVENTS_PVT',

553: retcode := -10;
554: errbuf := 'Parameter p_event_period_name is required.';
555: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,errbuf);
556: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);
557: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CAPITAL_EVENTS_PVT',
558: p_procedure_name => 'CREATE_PERIODIC_EVENT',
559: p_error_text => SUBSTRB(errbuf,1,240));
560: ROLLBACK;
561: RAISE;

Line 569: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CAPITAL_EVENTS_PVT',

565: retcode := -20;
566: errbuf := 'Parameter p_asset_through_date is required.';
567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,errbuf);
568: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);
569: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CAPITAL_EVENTS_PVT',
570: p_procedure_name => 'CREATE_PERIODIC_EVENT',
571: p_error_text => SUBSTRB(errbuf,1,240));
572: ROLLBACK;
573: RAISE;

Line 605: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CAPITAL_EVENTS_PVT',

601: errbuf := 'Unexpected error for project id '||
602: ac_projects_rec.project_id||': '||SQLCODE||' '||SQLERRM;
603: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,errbuf);
604: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);
605: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CAPITAL_EVENTS_PVT',
606: p_procedure_name => 'CREATE_PERIODIC_EVENT',
607: p_error_text => SUBSTRB(errbuf,1,240));
608: ROLLBACK;
609: RAISE;

Line 634: FROM pa_capital_events

630: x_event_type VARCHAR2) IS
631: SELECT capital_event_id,
632: capital_event_number,
633: event_name
634: FROM pa_capital_events
635: WHERE project_id = x_project_id
636: AND event_period = p_event_period_name
637: AND event_type = x_event_type
638: ORDER BY capital_event_id;

Line 737: FROM pa_capital_events c,

733: c.capital_event_id,
734: c.capital_event_number,
735: c.event_name,
736: c.event_type
737: FROM pa_capital_events c,
738: pa_projects p
739: WHERE c.project_id = x_project_id
740: AND c.event_type = x_event_type
741: AND c.request_id = x_request_id

Line 758: FROM pa_capital_events c,

754: c.capital_event_id,
755: c.capital_event_number,
756: c.event_name,
757: c.event_type
758: FROM pa_capital_events c,
759: pa_projects p
760: WHERE c.project_id = p.project_id
761: AND c.project_id = x_project_id
762: AND c.event_period = p_event_period_name

Line 846: v_event_number pa_capital_events.capital_event_number%TYPE;

842: v_project_number pa_projects_all.segment1%TYPE;
843: v_print_project_number pa_projects_all.segment1%TYPE;
844: v_addtl_costs_or_assets VARCHAR2(1);
845: v_first_addtl VARCHAR2(1);
846: v_event_number pa_capital_events.capital_event_number%TYPE;
847: v_new_event_id pa_capital_events.capital_event_id%TYPE := NULL;
848: v_task_number pa_tasks.task_number%TYPE;
849: v_event_exists VARCHAR2(1);
850: v_asset_count NUMBER := 0;

Line 847: v_new_event_id pa_capital_events.capital_event_id%TYPE := NULL;

843: v_print_project_number pa_projects_all.segment1%TYPE;
844: v_addtl_costs_or_assets VARCHAR2(1);
845: v_first_addtl VARCHAR2(1);
846: v_event_number pa_capital_events.capital_event_number%TYPE;
847: v_new_event_id pa_capital_events.capital_event_id%TYPE := NULL;
848: v_task_number pa_tasks.task_number%TYPE;
849: v_event_exists VARCHAR2(1);
850: v_asset_count NUMBER := 0;
851: v_ei_count NUMBER := 0;

Line 1009: FROM pa_capital_events

1005:
1006: --Determine the highest existing event number
1007: SELECT NVL(MAX(capital_event_number),0)
1008: INTO v_event_number
1009: FROM pa_capital_events
1010: WHERE project_id = p_project_id;
1011:
1012: --Get the Capital Type meaning
1013: SELECT meaning

Line 1025: PA_CAPITAL_EVENTS_PKG.INSERT_ROW

1021:
1022: --Initialize new event id
1023: v_new_event_id := NULL;
1024:
1025: PA_CAPITAL_EVENTS_PKG.INSERT_ROW
1026: (x_rowid => v_null_rowid,
1027: x_capital_event_id => v_new_event_id,
1028: x_project_id => p_project_id,
1029: x_capital_event_number => v_event_number,

Line 1499: FROM pa_capital_events

1495:
1496: --Determine the highest existing event number
1497: SELECT NVL(MAX(capital_event_number),0)
1498: INTO v_event_number
1499: FROM pa_capital_events
1500: WHERE project_id = p_project_id;
1501:
1502: --Get the Capital Type meaning
1503: SELECT meaning

Line 1515: PA_CAPITAL_EVENTS_PKG.INSERT_ROW

1511:
1512: --Initialize new event id
1513: v_new_event_id := NULL;
1514:
1515: PA_CAPITAL_EVENTS_PKG.INSERT_ROW
1516: (x_rowid => v_null_rowid,
1517: x_capital_event_id => v_new_event_id,
1518: x_project_id => p_project_id,
1519: x_capital_event_number => v_event_number,

Line 2357: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CAPITAL_EVENTS_PVT',

2353: retcode := -30;
2354: errbuf := 'Cannot find newly created Capital Event for project id '||p_project_id;
2355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,errbuf);
2356: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);
2357: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CAPITAL_EVENTS_PVT',
2358: p_procedure_name => 'CREATE_EVENT_FOR_PROJECT',
2359: p_error_text => SUBSTRB(errbuf,1,240));
2360: ROLLBACK;
2361: RAISE;

Line 2371: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CAPITAL_EVENTS_PVT',

2367: errbuf := 'Unexpected error for project id '||
2368: p_project_id||': '||SQLCODE||' '||SQLERRM;
2369: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,errbuf);
2370: FND_FILE.PUT_LINE(FND_FILE.LOG,errbuf);
2371: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CAPITAL_EVENTS_PVT',
2372: p_procedure_name => 'CREATE_EVENT_FOR_PROJECT',
2373: p_error_text => SUBSTRB(errbuf,1,240));
2374: ROLLBACK;
2375: RAISE;

Line 2447: v_event_type PA_CAPITAL_EVENTS.event_type%TYPE;

2443: task_assignments_rec task_assignments_cur%ROWTYPE;
2444:
2445:
2446:
2447: v_event_type PA_CAPITAL_EVENTS.event_type%TYPE;
2448: v_user_id NUMBER := FND_GLOBAL.user_id;
2449: v_login_id NUMBER := FND_GLOBAL.login_id;
2450:
2451:

Line 2459: FROM pa_capital_events

2455:
2456: --Get capital event type
2457: SELECT event_type
2458: INTO v_event_type
2459: FROM pa_capital_events
2460: WHERE capital_event_id = p_capital_event_id;
2461:
2462:
2463: --Verify that assets exist to be attached

Line 2611: v_event_type PA_CAPITAL_EVENTS.event_type%TYPE;

2607: task_asgn_assets_rec task_asgn_assets_cur%ROWTYPE;
2608:
2609:
2610:
2611: v_event_type PA_CAPITAL_EVENTS.event_type%TYPE;
2612: v_user_id NUMBER := FND_GLOBAL.user_id;
2613: v_login_id NUMBER := FND_GLOBAL.login_id;
2614: v_attach_ei VARCHAR2(1) := 'N';
2615: v_project_assignment VARCHAR2(1) := 'N';

Line 2631: FROM pa_capital_events

2627:
2628: --Get capital event type
2629: SELECT event_type
2630: INTO v_event_type
2631: FROM pa_capital_events
2632: WHERE capital_event_id = p_capital_event_id;
2633:
2634:
2635: --Verify that costs exist to be attached

Line 2759: END PA_CAPITAL_EVENTS_PVT;

2755:
2756: END ATTACH_COSTS;
2757:
2758:
2759: END PA_CAPITAL_EVENTS_PVT;