DBA Data[Home] [Help]

APPS.PA_YEAR_END_ROLLOVER_PKG dependencies on FND_API

Line 50: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

46: BEGIN
47:
48: g_procedure_name := 'Upd_Ins_Budget_Acct_Line';
49:
50: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
51:
52: BEGIN
53: IF P_DEBUG_MODE = 'Y' THEN
54: log_message('Year_End_Rollover: ' || 'Before Update in Upd_Ins_Budget_Acct_Line');

Line 339: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

335: X_Return_Status => l_Return_Status,
336: X_Error_Message_Code => l_Msg_Data
337: );
338:
339: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
340: IF P_DEBUG_MODE = 'Y' THEN
341: PA_Fck_Util.debug_msg('Year_End_Rollover: ' || 'Error occured while running sweeper process PA_Sweeper.Update_Act_Enc_Balance');
342: PA_Fck_Util.debug_msg('Year_End_Rollover: ' || 'Action: Contact Oracle support team');
343: PA_Fck_Util.debug_msg('Year_End_Rollover: ' || 'X_Error_Message_Code:'||l_Msg_Data);

Line 388: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN -- Need to test carefully

384: X_Msg_Count => l_Msg_Count,
385: X_Msg_Data => l_Msg_Data
386: );
387:
388: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN -- Need to test carefully
389: X_Msg_Count := l_Msg_Count;
390: X_Msg_Data := l_Msg_Data;
391: X_Return_Status := l_Return_Status;
392:

Line 554: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

550: X_Msg_Count => l_Msg_Count,
551: X_Msg_Data => l_Msg_Data
552: );
553:
554: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
555: IF P_DEBUG_MODE = 'Y' THEN
556: g_procedure_name := 'Year_End_Rollover';
557: log_message(g_procedure_name||':Create_Working_Budget Failed:'||l_Msg_Data);
558: END IF;

Line 748: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

744: X_Msg_Count => l_Msg_Count,
745: X_Msg_Data => l_Msg_Data
746: );
747:
748: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
749: log_message('Year_End_Rollover: Old period: Upd_Ins_Budget_Line failed:'||l_Msg_Data);
750: g_procedure_name := 'Year_End_Rollover';
751: RAISE l_IU_Bdgt_Line_ERR;
752: END IF;

Line 782: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

778: X_Msg_Count => l_Msg_Count,
779: X_Msg_Data => l_Msg_Data
780: );
781:
782: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
783: THEN
784: log_message('Year_End_Rollover: Old period: Upd_Ins_Budget_Acct_Line failed:'||l_Msg_Data);
785: g_procedure_name := 'Year_End_Rollover';
786: RAISE l_IU_Bdgt_Acct_ERR;

Line 829: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

825: X_Msg_Count => l_Msg_Count,
826: X_Msg_Data => l_Msg_Data
827: );
828:
829: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
830: log_message('Year_End_Rollover: New period: Upd_Ins_Budget_Line failed:'||l_Msg_Data);
831: g_procedure_name := 'Year_End_Rollover';
832: RAISE l_IU_Bdgt_Line_ERR;
833: END IF;

Line 869: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS

865: X_Msg_Count => l_Msg_Count,
866: X_Msg_Data => l_Msg_Data
867: );
868:
869: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS
870: THEN
871: log_message('Year_End_Rollover: New period: Upd_Ins_Budget_Acct_Line failed:'||l_Msg_Data);
872: g_procedure_name := 'Year_End_Rollover';
873: RAISE l_IU_Bdgt_Acct_ERR;

Line 937: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

933: X_Return_Status => l_return_status,
934: X_Msg_Count => l_msg_count,
935: X_Msg_Data => l_msg_data) ;
936:
937: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
938: l_Proceed_Flag := FALSE;
939: Year_End_Rollover_Log (
940: P_Budget_Version_ID => l_Work_Budget_Version_Id,
941: P_Message_Name => 'PA_BC_GEN_FAI_ACCT',

Line 1037: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1033: X_Return_Status => l_return_status,
1034: X_Msg_Count => l_msg_count,
1035: X_Msg_Data => l_msg_data) ;
1036:
1037: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1038: ROLLBACK;
1039: l_Message_Name := 'PA_BC_GEN_FAI_ACCT';
1040: RAISE l_SUBMIT_BASELINE_ERR;
1041: END IF;

Line 1281: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1277:
1278: WHEN l_Lock_Bdgt_Err THEN
1279: X_Msg_Count := 1;
1280: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
1281: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1282: Year_End_Rollover_Log (
1283: P_Budget_Version_ID => l_Work_Budget_Version_Id,
1284: P_Message_Name => 'PA_BC_LOCK_BDGT_ERR',
1285: P_Request_ID => P_Request_ID,

Line 1291: X_Return_Status := FND_API.G_RET_STS_ERROR;

1287:
1288: WHEN l_SUBMIT_BASELINE_ERR THEN
1289: X_Msg_Count := 1;
1290: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
1291: X_Return_Status := FND_API.G_RET_STS_ERROR;
1292: Year_End_Rollover_Log (
1293: P_Budget_Version_ID => l_Work_Budget_Version_Id,
1294: P_Message_Name => l_Message_Name,
1295: P_Request_ID => P_Request_ID,

Line 1362: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1358: P_Request_ID => P_Request_ID);
1359: /* Bug 5726535 - End */
1360: X_Msg_Count := 1;
1361: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
1362: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1363: log_message('Year_End_Rollover: ' ||'In When Others. End->X_Msg_Data :'||X_Msg_Data);
1364: ROLLBACK;
1365: RETURN;
1366:

Line 1477: X_Return_Status := FND_API.G_RET_STS_ERROR;

1473: END IF;
1474:
1475: X_Msg_Count := 9998;
1476: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
1477: X_Return_Status := FND_API.G_RET_STS_ERROR;
1478:
1479: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_Year_End_Rollover_PKG',
1480: P_Procedure_Name => 'Get_Period_Details');
1481: RETURN;

Line 1513: X_Return_Status := FND_API.G_RET_STS_ERROR;

1509: END IF;
1510:
1511: X_Msg_Count := 9999;
1512: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
1513: X_Return_Status := FND_API.G_RET_STS_ERROR;
1514:
1515: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_Year_End_Rollover_PKG',
1516: P_Procedure_Name => 'Get_Period_Details');
1517: RETURN;

Line 1535: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1531: log_message('Year_End_Rollover: ' || 'ERRORS encountered in API : Get_Period_Details' );
1532: END IF;
1533: X_Msg_Count := 1;
1534: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
1535: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1536:
1537: FND_MSG_PUB.add_Exc_msg( P_Pkg_Name => 'PA_Year_End_Rollover_PKG',
1538: P_Procedure_Name => 'Get_Period_Details');
1539: END Get_Period_Details;

Line 1585: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

1581: l_Txn_Curr_Code PA_BUDGET_LINES.TXN_CURRENCY_CODE%type;
1582: --l_Budget_Line_Id PA_BUDGET_LINES.BUDGET_LINE_ID%type;
1583:
1584: BEGIN
1585: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
1586:
1587: -----------------------------------------------------------------------------------+
1588: -- Update the Budget line for a required res. assignment and period
1589: -----------------------------------------------------------------------------------+

Line 2060: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2056: EXCEPTION
2057: WHEN l_Lock_Bdgt_Err THEN
2058: X_Msg_Count := 1;
2059: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
2060: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2061: Year_End_Rollover_Log (
2062: P_Budget_Version_ID => l_Work_Budget_Version_Id,
2063: P_Message_Name => 'PA_BC_LOCK_BDGT_ERR',
2064: P_Request_ID => P_Request_ID,

Line 2070: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2066:
2067: WHEN l_Get_Work_Bdgt_Err THEN
2068: X_Msg_Count := 1;
2069: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
2070: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2071: Year_End_Rollover_Log (
2072: P_Budget_Version_ID => l_Work_Budget_Version_Id,
2073: P_Message_Name => 'PA_BC_WORK_BDGT_ERR',
2074: P_Request_ID => P_Request_ID,

Line 2079: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2075: P_Lock_Name => l_Lock_Name );
2076: WHEN l_Copy_Bdgt_Err THEN
2077: X_Msg_Count := 1;
2078: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
2079: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2080: Year_End_Rollover_Log (
2081: P_Budget_Version_ID => l_Work_Budget_Version_Id,
2082: P_Message_Name => 'PA_BC_COPY_BDGT_ERR',
2083: P_Request_ID => P_Request_ID,

Line 2088: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2084: P_Lock_Name => l_Lock_Name );
2085: WHEN l_IU_Bdgt_Acct_Err THEN
2086: X_Msg_Count := 1;
2087: X_Msg_Data := SUBSTR(SQLERRM, 1, 240);
2088: X_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2089: Year_End_Rollover_Log (
2090: P_Budget_Version_ID => l_Work_Budget_Version_Id,
2091: P_Message_Name => upper('PA_BC_IU_Bdgt_Acct_Err'),
2092: P_Request_ID => P_Request_ID,