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_COST1 dependencies on PA_DEBUG

Line 12: --IF P_PA_DEBUG_MODE = 'Y' Then

8:
9: pragma autonomous_transaction ;
10: BEGIN
11: --dbms_output.put_line(p_msg);
12: --IF P_PA_DEBUG_MODE = 'Y' Then
13: NULL;
14: INSERT INTO PA_FP_CALCULATE_LOG
15: (SESSIONID
16: ,SEQ_NUMBER

Line 37: PA_DEBUG.write

33: BEGIN
34: --calc_log(p_msg);
35: If p_debug_flag = 'Y' Then
36: l_msg := substr(p_msg,1,1000);
37: PA_DEBUG.write
38: (x_Module => l_module
39: ,x_Msg => substr('LOG:'||p_msg,1,240)
40: ,x_Log_Level => 3);
41: End If;

Line 148: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);

144: BEGIN
145: --- Initialize the error statck
146: IF ( g_debug_flag IS NULL )
147: Then
148: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
149: g_debug_flag := NVL(g_debug_flag, 'N');
150: End If;
151: l_debug_flag := NVL(g_debug_flag,'N');
152: IF ( l_debug_flag = 'Y' )

Line 154: PA_DEBUG.init_err_stack ('PA_COST1.get_projLevel_BurdSchds');

150: End If;
151: l_debug_flag := NVL(g_debug_flag,'N');
152: IF ( l_debug_flag = 'Y' )
153: THEN
154: PA_DEBUG.init_err_stack ('PA_COST1.get_projLevel_BurdSchds');
155: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
156: ,x_write_file => 'LOG'
157: ,x_debug_mode => l_debug_flag
158: );

Line 155: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

151: l_debug_flag := NVL(g_debug_flag,'N');
152: IF ( l_debug_flag = 'Y' )
153: THEN
154: PA_DEBUG.init_err_stack ('PA_COST1.get_projLevel_BurdSchds');
155: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
156: ,x_write_file => 'LOG'
157: ,x_debug_mode => l_debug_flag
158: );
159: End If;

Line 645: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);

641: x_return_status := 'S';
642:
643: --- Initialize the error statck
644: If g_debug_flag is NULL Then
645: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
646: g_debug_flag := NVL(g_debug_flag, 'N');
647: End If;
648: l_debug_flag := NVL(g_debug_flag,'N');
649: IF l_debug_flag = 'Y' Then

Line 650: PA_DEBUG.init_err_stack ('PA_COST1.Get_Plan_Actual_Cost_Rates');

646: g_debug_flag := NVL(g_debug_flag, 'N');
647: End If;
648: l_debug_flag := NVL(g_debug_flag,'N');
649: IF l_debug_flag = 'Y' Then
650: PA_DEBUG.init_err_stack ('PA_COST1.Get_Plan_Actual_Cost_Rates');
651: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
652: ,x_write_file => 'LOG'
653: ,x_debug_mode => l_debug_flag
654: );

Line 651: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

647: End If;
648: l_debug_flag := NVL(g_debug_flag,'N');
649: IF l_debug_flag = 'Y' Then
650: PA_DEBUG.init_err_stack ('PA_COST1.Get_Plan_Actual_Cost_Rates');
651: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
652: ,x_write_file => 'LOG'
653: ,x_debug_mode => l_debug_flag
654: );
655: End If;

Line 697: PA_DEBUG.reset_err_stack;

693: x_burden_cost_rejection_code := Null;
694: x_error_msg_code := Null;
695: x_return_status := 'S';
696: If l_debug_flag = 'Y' Then
697: PA_DEBUG.reset_err_stack;
698: End If;
699: RETURN;
700: ElsIf (p_override_trxn_cost_rate is NOT NULL OR p_override_trxn_raw_cost is NOT NULL ) Then
701: l_stage := 'Validating override params';

Line 1460: PA_DEBUG.reset_err_stack;

1456: x_return_status := l_return_status;
1457:
1458: -- reset the error stack
1459: If l_debug_flag = 'Y' Then
1460: PA_DEBUG.reset_err_stack;
1461: End If;
1462:
1463: EXCEPTION
1464: WHEN l_insufficient_parms THEN

Line 1492: PA_DEBUG.write_file('LOG',l_stage);

1488: End If;
1489: x_return_status := 'E';
1490: print_msg(l_debug_flag,l_stage);
1491: If l_debug_flag = 'Y' Then
1492: PA_DEBUG.write_file('LOG',l_stage);
1493: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1494: PA_DEBUG.reset_err_stack;
1495: End If;
1496:

Line 1493: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );

1489: x_return_status := 'E';
1490: print_msg(l_debug_flag,l_stage);
1491: If l_debug_flag = 'Y' Then
1492: PA_DEBUG.write_file('LOG',l_stage);
1493: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1494: PA_DEBUG.reset_err_stack;
1495: End If;
1496:
1497: WHEN l_no_rate_found THEN

Line 1494: PA_DEBUG.reset_err_stack;

1490: print_msg(l_debug_flag,l_stage);
1491: If l_debug_flag = 'Y' Then
1492: PA_DEBUG.write_file('LOG',l_stage);
1493: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1494: PA_DEBUG.reset_err_stack;
1495: End If;
1496:
1497: WHEN l_no_rate_found THEN
1498: x_error_msg_code := 'PA_FP_MISSING_RATE';

Line 1502: PA_DEBUG.write_file('LOG',l_stage);

1498: x_error_msg_code := 'PA_FP_MISSING_RATE';
1499: x_return_status := 'E';
1500: print_msg(l_debug_flag,l_stage);
1501: If l_debug_flag = 'Y' Then
1502: PA_DEBUG.write_file('LOG',l_stage);
1503: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1504: PA_DEBUG.reset_err_stack;
1505: End If;
1506:

Line 1503: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );

1499: x_return_status := 'E';
1500: print_msg(l_debug_flag,l_stage);
1501: If l_debug_flag = 'Y' Then
1502: PA_DEBUG.write_file('LOG',l_stage);
1503: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1504: PA_DEBUG.reset_err_stack;
1505: End If;
1506:
1507: WHEN l_no_burdrate_found THEN

Line 1504: PA_DEBUG.reset_err_stack;

1500: print_msg(l_debug_flag,l_stage);
1501: If l_debug_flag = 'Y' Then
1502: PA_DEBUG.write_file('LOG',l_stage);
1503: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1504: PA_DEBUG.reset_err_stack;
1505: End If;
1506:
1507: WHEN l_no_burdrate_found THEN
1508: x_error_msg_code := 'PA_CALC_BURDENED_COST_FAILED';

Line 1512: PA_DEBUG.write_file('LOG',l_stage);

1508: x_error_msg_code := 'PA_CALC_BURDENED_COST_FAILED';
1509: x_return_status := 'E';
1510: print_msg(l_debug_flag,l_stage);
1511: If l_debug_flag = 'Y' Then
1512: PA_DEBUG.write_file('LOG',l_stage);
1513: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1514: PA_DEBUG.reset_err_stack;
1515: End If;
1516:

Line 1513: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );

1509: x_return_status := 'E';
1510: print_msg(l_debug_flag,l_stage);
1511: If l_debug_flag = 'Y' Then
1512: PA_DEBUG.write_file('LOG',l_stage);
1513: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1514: PA_DEBUG.reset_err_stack;
1515: End If;
1516:
1517: WHEN l_invalid_override_attributes THEN

Line 1514: PA_DEBUG.reset_err_stack;

1510: print_msg(l_debug_flag,l_stage);
1511: If l_debug_flag = 'Y' Then
1512: PA_DEBUG.write_file('LOG',l_stage);
1513: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1514: PA_DEBUG.reset_err_stack;
1515: End If;
1516:
1517: WHEN l_invalid_override_attributes THEN
1518: x_error_msg_code := 'PA_INVALID_OVERRIDE_PARAM';

Line 1522: PA_DEBUG.write_file('LOG',l_stage);

1518: x_error_msg_code := 'PA_INVALID_OVERRIDE_PARAM';
1519: x_return_status := 'E';
1520: print_msg(l_debug_flag,l_stage);
1521: If l_debug_flag = 'Y' Then
1522: PA_DEBUG.write_file('LOG',l_stage);
1523: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1524: PA_DEBUG.reset_err_stack;
1525: End If;
1526:

Line 1523: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );

1519: x_return_status := 'E';
1520: print_msg(l_debug_flag,l_stage);
1521: If l_debug_flag = 'Y' Then
1522: PA_DEBUG.write_file('LOG',l_stage);
1523: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1524: PA_DEBUG.reset_err_stack;
1525: End If;
1526:
1527: WHEN l_invalid_currency THEN

Line 1524: PA_DEBUG.reset_err_stack;

1520: print_msg(l_debug_flag,l_stage);
1521: If l_debug_flag = 'Y' Then
1522: PA_DEBUG.write_file('LOG',l_stage);
1523: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1524: PA_DEBUG.reset_err_stack;
1525: End If;
1526:
1527: WHEN l_invalid_currency THEN
1528: x_error_msg_code := 'PA_INVALID_DENOM_CURRENCY';

Line 1532: PA_DEBUG.write_file('LOG',l_stage);

1528: x_error_msg_code := 'PA_INVALID_DENOM_CURRENCY';
1529: x_return_status := 'E';
1530: print_msg(l_debug_flag,l_stage);
1531: If l_debug_flag = 'Y' Then
1532: PA_DEBUG.write_file('LOG',l_stage);
1533: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1534: PA_DEBUG.reset_err_stack;
1535: End If;
1536:

Line 1533: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );

1529: x_return_status := 'E';
1530: print_msg(l_debug_flag,l_stage);
1531: If l_debug_flag = 'Y' Then
1532: PA_DEBUG.write_file('LOG',l_stage);
1533: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1534: PA_DEBUG.reset_err_stack;
1535: End If;
1536:
1537:

Line 1534: PA_DEBUG.reset_err_stack;

1530: print_msg(l_debug_flag,l_stage);
1531: If l_debug_flag = 'Y' Then
1532: PA_DEBUG.write_file('LOG',l_stage);
1533: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']errCode['||l_err_code||']' );
1534: PA_DEBUG.reset_err_stack;
1535: End If;
1536:
1537:
1538: WHEN OTHERS THEN

Line 1548: PA_DEBUG.write_file('LOG',l_stage);

1544: x_error_msg_code := substr(SQLCODE||SQLERRM,1,30);
1545: End If;
1546: print_msg(l_debug_flag,l_stage);
1547: If l_debug_flag = 'Y' Then
1548: PA_DEBUG.write_file('LOG',l_stage);
1549: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']sqlcode['||sqlcode||']ErrMsg['||x_error_msg_code||']');
1550: PA_DEBUG.reset_err_stack;
1551: End If;
1552:

Line 1549: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']sqlcode['||sqlcode||']ErrMsg['||x_error_msg_code||']');

1545: End If;
1546: print_msg(l_debug_flag,l_stage);
1547: If l_debug_flag = 'Y' Then
1548: PA_DEBUG.write_file('LOG',l_stage);
1549: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']sqlcode['||sqlcode||']ErrMsg['||x_error_msg_code||']');
1550: PA_DEBUG.reset_err_stack;
1551: End If;
1552:
1553: END Get_Plan_Actual_Cost_Rates;

Line 1550: PA_DEBUG.reset_err_stack;

1546: print_msg(l_debug_flag,l_stage);
1547: If l_debug_flag = 'Y' Then
1548: PA_DEBUG.write_file('LOG',l_stage);
1549: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']sqlcode['||sqlcode||']ErrMsg['||x_error_msg_code||']');
1550: PA_DEBUG.reset_err_stack;
1551: End If;
1552:
1553: END Get_Plan_Actual_Cost_Rates;
1554:

Line 1609: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);

1605:
1606: BEGIN
1607: --- Initialize the error statck
1608: If g_debug_flag is NULL Then
1609: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
1610: g_debug_flag := NVL(g_debug_flag, 'N');
1611: End If;
1612: l_debug_flag := NVL(g_debug_flag,'N');
1613: IF l_debug_flag = 'Y' Then

Line 1614: PA_DEBUG.init_err_stack ('PA_COST1.Get_Non_Labor_raw_cost');

1610: g_debug_flag := NVL(g_debug_flag, 'N');
1611: End If;
1612: l_debug_flag := NVL(g_debug_flag,'N');
1613: IF l_debug_flag = 'Y' Then
1614: PA_DEBUG.init_err_stack ('PA_COST1.Get_Non_Labor_raw_cost');
1615: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
1616: ,x_write_file => 'LOG'
1617: ,x_debug_mode => l_debug_flag
1618: );

Line 1615: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

1611: End If;
1612: l_debug_flag := NVL(g_debug_flag,'N');
1613: IF l_debug_flag = 'Y' Then
1614: PA_DEBUG.init_err_stack ('PA_COST1.Get_Non_Labor_raw_cost');
1615: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
1616: ,x_write_file => 'LOG'
1617: ,x_debug_mode => l_debug_flag
1618: );
1619: End If;

Line 1735: PA_DEBUG.reset_err_stack;

1731: x_txn_currency_code := NVL(l_cost_rate_curr_code,l_nlr_txn_curr_code);
1732:
1733: -- reset the error stack
1734: If l_debug_flag = 'Y' Then
1735: PA_DEBUG.reset_err_stack;
1736: End If;
1737:
1738: EXCEPTION
1739:

Line 1743: PA_DEBUG.write_file('LOG',l_stage);

1739:
1740: WHEN OTHERS THEN
1741: print_msg(l_debug_flag,l_stage);
1742: If l_debug_flag = 'Y' Then
1743: PA_DEBUG.write_file('LOG',l_stage);
1744: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']' );
1745: PA_DEBUG.reset_err_stack;
1746: End If;
1747: END Get_Non_Labor_raw_cost;

Line 1744: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']' );

1740: WHEN OTHERS THEN
1741: print_msg(l_debug_flag,l_stage);
1742: If l_debug_flag = 'Y' Then
1743: PA_DEBUG.write_file('LOG',l_stage);
1744: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']' );
1745: PA_DEBUG.reset_err_stack;
1746: End If;
1747: END Get_Non_Labor_raw_cost;
1748:

Line 1745: PA_DEBUG.reset_err_stack;

1741: print_msg(l_debug_flag,l_stage);
1742: If l_debug_flag = 'Y' Then
1743: PA_DEBUG.write_file('LOG',l_stage);
1744: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']ErrMsg['||l_msg_data||']' );
1745: PA_DEBUG.reset_err_stack;
1746: End If;
1747: END Get_Non_Labor_raw_cost;
1748:
1749: /* This is a wrapper api to derive compiled set id and burden multiplier

Line 1818: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);

1814: BEGIN
1815:
1816: --- Initialize the error statck
1817: If g_debug_flag is NULL Then
1818: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
1819: g_debug_flag := NVL(g_debug_flag, 'N');
1820: End If;
1821: l_debug_flag := NVL(g_debug_flag,'N');
1822: IF l_debug_flag = 'Y' Then

Line 1823: PA_DEBUG.init_err_stack ('PA_COST1.Get_burden_sch_details');

1819: g_debug_flag := NVL(g_debug_flag, 'N');
1820: End If;
1821: l_debug_flag := NVL(g_debug_flag,'N');
1822: IF l_debug_flag = 'Y' Then
1823: PA_DEBUG.init_err_stack ('PA_COST1.Get_burden_sch_details');
1824: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
1825: ,x_write_file => 'LOG'
1826: ,x_debug_mode => l_debug_flag
1827: );

Line 1824: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

1820: End If;
1821: l_debug_flag := NVL(g_debug_flag,'N');
1822: IF l_debug_flag = 'Y' Then
1823: PA_DEBUG.init_err_stack ('PA_COST1.Get_burden_sch_details');
1824: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
1825: ,x_write_file => 'LOG'
1826: ,x_debug_mode => l_debug_flag
1827: );
1828: End If;

Line 2030: PA_DEBUG.reset_err_stack;

2026: print_msg(l_debug_flag,l_stage);
2027:
2028: --reset error stack
2029: If l_debug_flag = 'Y' Then
2030: PA_DEBUG.reset_err_stack;
2031: End If;
2032:
2033: EXCEPTION
2034: WHEN l_invalid_schedule Then

Line 2038: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );

2034: WHEN l_invalid_schedule Then
2035: x_return_status := 'E';
2036: x_error_msg_code := 'PA_FCST_INVL_BURDEN_SCH_REV_ID';
2037: If l_debug_flag = 'Y' Then
2038: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2039: PA_DEBUG.write_file('LOG',l_stage);
2040: PA_DEBUG.reset_err_stack;
2041: End If;
2042:

Line 2039: PA_DEBUG.write_file('LOG',l_stage);

2035: x_return_status := 'E';
2036: x_error_msg_code := 'PA_FCST_INVL_BURDEN_SCH_REV_ID';
2037: If l_debug_flag = 'Y' Then
2038: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2039: PA_DEBUG.write_file('LOG',l_stage);
2040: PA_DEBUG.reset_err_stack;
2041: End If;
2042:
2043: WHEN l_no_cost_base Then

Line 2040: PA_DEBUG.reset_err_stack;

2036: x_error_msg_code := 'PA_FCST_INVL_BURDEN_SCH_REV_ID';
2037: If l_debug_flag = 'Y' Then
2038: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2039: PA_DEBUG.write_file('LOG',l_stage);
2040: PA_DEBUG.reset_err_stack;
2041: End If;
2042:
2043: WHEN l_no_cost_base Then
2044: If l_status = 100 Then

Line 2057: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );

2053: x_error_msg_code := 'PA_FCST_NO_COST_BASE';
2054:
2055: End If;
2056: If l_debug_flag = 'Y' Then
2057: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2058: PA_DEBUG.write_file('LOG',l_stage);
2059: PA_DEBUG.reset_err_stack;
2060: End If;
2061:

Line 2058: PA_DEBUG.write_file('LOG',l_stage);

2054:
2055: End If;
2056: If l_debug_flag = 'Y' Then
2057: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2058: PA_DEBUG.write_file('LOG',l_stage);
2059: PA_DEBUG.reset_err_stack;
2060: End If;
2061:
2062: WHEN l_no_compiled_set Then

Line 2059: PA_DEBUG.reset_err_stack;

2055: End If;
2056: If l_debug_flag = 'Y' Then
2057: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2058: PA_DEBUG.write_file('LOG',l_stage);
2059: PA_DEBUG.reset_err_stack;
2060: End If;
2061:
2062: WHEN l_no_compiled_set Then
2063: If p_exp_organization_id is NULL Then

Line 2074: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );

2070: x_return_status := 'E';
2071: x_error_msg_code := 'PA_NO_COMPILED_SET_ID';
2072: End If;
2073: If l_debug_flag = 'Y' Then
2074: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2075: PA_DEBUG.write_file('LOG',l_stage);
2076: PA_DEBUG.reset_err_stack;
2077: End If;
2078:

Line 2075: PA_DEBUG.write_file('LOG',l_stage);

2071: x_error_msg_code := 'PA_NO_COMPILED_SET_ID';
2072: End If;
2073: If l_debug_flag = 'Y' Then
2074: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2075: PA_DEBUG.write_file('LOG',l_stage);
2076: PA_DEBUG.reset_err_stack;
2077: End If;
2078:
2079:

Line 2076: PA_DEBUG.reset_err_stack;

2072: End If;
2073: If l_debug_flag = 'Y' Then
2074: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2075: PA_DEBUG.write_file('LOG',l_stage);
2076: PA_DEBUG.reset_err_stack;
2077: End If;
2078:
2079:
2080: WHEN l_no_multiplier Then

Line 2084: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );

2080: WHEN l_no_multiplier Then
2081: x_return_status := 'E';
2082: x_error_msg_code := 'PA_FCST_NO_COMPILED_MULTI';
2083: If l_debug_flag = 'Y' Then
2084: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2085: PA_DEBUG.write_file('LOG',l_stage);
2086: PA_DEBUG.reset_err_stack;
2087: End If;
2088:

Line 2085: PA_DEBUG.write_file('LOG',l_stage);

2081: x_return_status := 'E';
2082: x_error_msg_code := 'PA_FCST_NO_COMPILED_MULTI';
2083: If l_debug_flag = 'Y' Then
2084: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2085: PA_DEBUG.write_file('LOG',l_stage);
2086: PA_DEBUG.reset_err_stack;
2087: End If;
2088:
2089: WHEN l_invalid_error Then

Line 2086: PA_DEBUG.reset_err_stack;

2082: x_error_msg_code := 'PA_FCST_NO_COMPILED_MULTI';
2083: If l_debug_flag = 'Y' Then
2084: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2085: PA_DEBUG.write_file('LOG',l_stage);
2086: PA_DEBUG.reset_err_stack;
2087: End If;
2088:
2089: WHEN l_invalid_error Then
2090: x_return_status := 'E';

Line 2093: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );

2089: WHEN l_invalid_error Then
2090: x_return_status := 'E';
2091: x_error_msg_code := 'PA_CALC_BURDENED_COST_FAILED';
2092: If l_debug_flag = 'Y' Then
2093: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2094: PA_DEBUG.write_file('LOG',l_stage);
2095: PA_DEBUG.reset_err_stack;
2096: End If;
2097:

Line 2094: PA_DEBUG.write_file('LOG',l_stage);

2090: x_return_status := 'E';
2091: x_error_msg_code := 'PA_CALC_BURDENED_COST_FAILED';
2092: If l_debug_flag = 'Y' Then
2093: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2094: PA_DEBUG.write_file('LOG',l_stage);
2095: PA_DEBUG.reset_err_stack;
2096: End If;
2097:
2098: WHEN OTHERS THEN

Line 2095: PA_DEBUG.reset_err_stack;

2091: x_error_msg_code := 'PA_CALC_BURDENED_COST_FAILED';
2092: If l_debug_flag = 'Y' Then
2093: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2094: PA_DEBUG.write_file('LOG',l_stage);
2095: PA_DEBUG.reset_err_stack;
2096: End If;
2097:
2098: WHEN OTHERS THEN
2099: IF to_char(sqlcode) in ('00100','01403','100','1403') Then

Line 2107: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );

2103: x_return_status := 'U';
2104: x_error_msg_code := substr(SQLCODE||SQLERRM,1,30);
2105: End If;
2106: If l_debug_flag = 'Y' Then
2107: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2108: PA_DEBUG.write_file('LOG',l_stage);
2109: PA_DEBUG.reset_err_stack;
2110: End If;
2111:

Line 2108: PA_DEBUG.write_file('LOG',l_stage);

2104: x_error_msg_code := substr(SQLCODE||SQLERRM,1,30);
2105: End If;
2106: If l_debug_flag = 'Y' Then
2107: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2108: PA_DEBUG.write_file('LOG',l_stage);
2109: PA_DEBUG.reset_err_stack;
2110: End If;
2111:
2112:

Line 2109: PA_DEBUG.reset_err_stack;

2105: End If;
2106: If l_debug_flag = 'Y' Then
2107: PA_DEBUG.write_file('ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2108: PA_DEBUG.write_file('LOG',l_stage);
2109: PA_DEBUG.reset_err_stack;
2110: End If;
2111:
2112:
2113: END Get_burden_sch_details;

Line 2394: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);

2390:
2391: BEGIN
2392: --- Initialize the error statck
2393: If g_debug_flag is NULL Then
2394: fnd_profile.get('PA_DEBUG_MODE',g_debug_flag);
2395: g_debug_flag := NVL(g_debug_flag, 'N');
2396: End If;
2397: l_debug_flag := NVL(g_debug_flag,'N');
2398: If l_debug_flag = 'Y' Then

Line 2399: PA_DEBUG.init_err_stack ('PA_COST1.Convert_COST_TO_PC_PFC');

2395: g_debug_flag := NVL(g_debug_flag, 'N');
2396: End If;
2397: l_debug_flag := NVL(g_debug_flag,'N');
2398: If l_debug_flag = 'Y' Then
2399: PA_DEBUG.init_err_stack ('PA_COST1.Convert_COST_TO_PC_PFC');
2400: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
2401: ,x_write_file => 'LOG'
2402: ,x_debug_mode => l_debug_flag
2403: );

Line 2400: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'

2396: End If;
2397: l_debug_flag := NVL(g_debug_flag,'N');
2398: If l_debug_flag = 'Y' Then
2399: PA_DEBUG.init_err_stack ('PA_COST1.Convert_COST_TO_PC_PFC');
2400: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
2401: ,x_write_file => 'LOG'
2402: ,x_debug_mode => l_debug_flag
2403: );
2404: End If;

Line 2545: PA_DEBUG.reset_err_stack;

2541:
2542:
2543: -- Reset Err Stack
2544: If l_debug_flag = 'Y' Then
2545: PA_DEBUG.reset_err_stack;
2546: End If;
2547: EXCEPTION
2548: WHEN l_insufficient_parms THEN
2549: x_error_msg_code := 'PA_NO_BUDGET_VERSION';

Line 2553: PA_DEBUG.write_file('LOG',l_stage);

2549: x_error_msg_code := 'PA_NO_BUDGET_VERSION';
2550: x_return_status := 'E';
2551: print_msg(l_debug_flag,l_stage);
2552: If l_debug_flag = 'Y' Then
2553: PA_DEBUG.write_file('LOG',l_stage);
2554: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']errCode['||l_error_msg_code||']' );
2555: PA_DEBUG.reset_err_stack;
2556: End If;
2557:

Line 2554: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']errCode['||l_error_msg_code||']' );

2550: x_return_status := 'E';
2551: print_msg(l_debug_flag,l_stage);
2552: If l_debug_flag = 'Y' Then
2553: PA_DEBUG.write_file('LOG',l_stage);
2554: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']errCode['||l_error_msg_code||']' );
2555: PA_DEBUG.reset_err_stack;
2556: End If;
2557:
2558: WHEN l_no_budget_version THEN

Line 2555: PA_DEBUG.reset_err_stack;

2551: print_msg(l_debug_flag,l_stage);
2552: If l_debug_flag = 'Y' Then
2553: PA_DEBUG.write_file('LOG',l_stage);
2554: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']errCode['||l_error_msg_code||']' );
2555: PA_DEBUG.reset_err_stack;
2556: End If;
2557:
2558: WHEN l_no_budget_version THEN
2559: x_error_msg_code := 'PA_INV_PARAM_PASSED';

Line 2563: PA_DEBUG.write_file('LOG',l_stage);

2559: x_error_msg_code := 'PA_INV_PARAM_PASSED';
2560: x_return_status := 'E';
2561: print_msg(l_debug_flag,l_stage);
2562: If l_debug_flag = 'Y' Then
2563: PA_DEBUG.write_file('LOG',l_stage);
2564: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']errCode['||l_error_msg_code||']' );
2565: PA_DEBUG.reset_err_stack;
2566: End If;
2567:

Line 2564: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']errCode['||l_error_msg_code||']' );

2560: x_return_status := 'E';
2561: print_msg(l_debug_flag,l_stage);
2562: If l_debug_flag = 'Y' Then
2563: PA_DEBUG.write_file('LOG',l_stage);
2564: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']errCode['||l_error_msg_code||']' );
2565: PA_DEBUG.reset_err_stack;
2566: End If;
2567:
2568: WHEN OTHERS THEN

Line 2565: PA_DEBUG.reset_err_stack;

2561: print_msg(l_debug_flag,l_stage);
2562: If l_debug_flag = 'Y' Then
2563: PA_DEBUG.write_file('LOG',l_stage);
2564: PA_DEBUG.write_file('LOG','ReturnStatus['||l_return_status||']errCode['||l_error_msg_code||']' );
2565: PA_DEBUG.reset_err_stack;
2566: End If;
2567:
2568: WHEN OTHERS THEN
2569: x_return_status := 'U';

Line 2573: PA_DEBUG.write_file('LOG','ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );

2569: x_return_status := 'U';
2570: x_error_msg_code := SQLERRM||SQLCODE;
2571: print_msg(l_debug_flag,l_stage||x_error_msg_code);
2572: If l_debug_flag = 'Y' Then
2573: PA_DEBUG.write_file('LOG','ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2574: PA_DEBUG.write_file('LOG',l_stage);
2575: PA_DEBUG.reset_err_stack;
2576: End If;
2577:

Line 2574: PA_DEBUG.write_file('LOG',l_stage);

2570: x_error_msg_code := SQLERRM||SQLCODE;
2571: print_msg(l_debug_flag,l_stage||x_error_msg_code);
2572: If l_debug_flag = 'Y' Then
2573: PA_DEBUG.write_file('LOG','ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2574: PA_DEBUG.write_file('LOG',l_stage);
2575: PA_DEBUG.reset_err_stack;
2576: End If;
2577:
2578: END Convert_COST_TO_PC_PFC;

Line 2575: PA_DEBUG.reset_err_stack;

2571: print_msg(l_debug_flag,l_stage||x_error_msg_code);
2572: If l_debug_flag = 'Y' Then
2573: PA_DEBUG.write_file('LOG','ReturnSts['||l_return_status ||']ErrCode['||l_error_msg_code||']' );
2574: PA_DEBUG.write_file('LOG',l_stage);
2575: PA_DEBUG.reset_err_stack;
2576: End If;
2577:
2578: END Convert_COST_TO_PC_PFC;
2579: