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

Line 334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

330:
331: PROCEDURE Move_To_PSB
332: (
333: p_api_version IN NUMBER ,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
335: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
337: p_return_status OUT NOCOPY VARCHAR2 ,
338: p_msg_count OUT NOCOPY NUMBER ,

Line 335: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

331: PROCEDURE Move_To_PSB
332: (
333: p_api_version IN NUMBER ,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
335: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
337: p_return_status OUT NOCOPY VARCHAR2 ,
338: p_msg_count OUT NOCOPY NUMBER ,
339: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

332: (
333: p_api_version IN NUMBER ,
334: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
335: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
337: p_return_status OUT NOCOPY VARCHAR2 ,
338: p_msg_count OUT NOCOPY NUMBER ,
339: p_msg_data OUT NOCOPY VARCHAR2 ,
340: --

Line 342: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

338: p_msg_count OUT NOCOPY NUMBER ,
339: p_msg_data OUT NOCOPY VARCHAR2 ,
340: --
341: p_export_id IN NUMBER,
342: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
345: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM

Line 343: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

339: p_msg_data OUT NOCOPY VARCHAR2 ,
340: --
341: p_export_id IN NUMBER,
342: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
345: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
347: )

Line 344: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,

340: --
341: p_export_id IN NUMBER,
342: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
345: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
347: )
348: IS

Line 345: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

341: p_export_id IN NUMBER,
342: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
345: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
347: )
348: IS
349:

Line 346: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM

342: p_import_worksheet_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
343: p_amt_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
344: p_amt_tolerance_value IN NUMBER := FND_API.G_MISS_NUM,
345: p_pct_tolerance_value_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
346: p_pct_tolerance_value IN NUMBER := FND_API.G_MISS_NUM
347: )
348: IS
349:
350: l_validation_status VARCHAR2(1);

Line 378: IF NOT FND_API.Compatible_API_Call ( l_api_version,

374: BEGIN
375: --
376: SAVEPOINT Move_To_PSB_Pvt ;
377: --
378: IF NOT FND_API.Compatible_API_Call ( l_api_version,
379: p_api_version,
380: l_api_name,
381: G_PKG_NAME )
382: THEN

Line 383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

379: p_api_version,
380: l_api_name,
381: G_PKG_NAME )
382: THEN
383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
384: END IF;
385: --
386:
387: IF FND_API.To_Boolean ( p_init_msg_list ) THEN

Line 387: IF FND_API.To_Boolean ( p_init_msg_list ) THEN

383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
384: END IF;
385: --
386:
387: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
388: FND_MSG_PUB.initialize ;
389: END IF;
390: --
391: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 391: p_return_status := FND_API.G_RET_STS_SUCCESS ;

387: IF FND_API.To_Boolean ( p_init_msg_list ) THEN
388: FND_MSG_PUB.initialize ;
389: END IF;
390: --
391: p_return_status := FND_API.G_RET_STS_SUCCESS ;
392: --
393: l_validation_status := FND_API.G_RET_STS_SUCCESS;
394:
395: g_export_id := p_export_id;

Line 393: l_validation_status := FND_API.G_RET_STS_SUCCESS;

389: END IF;
390: --
391: p_return_status := FND_API.G_RET_STS_SUCCESS ;
392: --
393: l_validation_status := FND_API.G_RET_STS_SUCCESS;
394:
395: g_export_id := p_export_id;
396: g_amt_tolerance_value_type := p_amt_tolerance_value_type;
397: g_amt_tolerance_value := p_amt_tolerance_value;

Line 401: IF p_import_worksheet_type = FND_API.G_MISS_CHAR THEN

397: g_amt_tolerance_value := p_amt_tolerance_value;
398: g_pct_tolerance_value_type := p_pct_tolerance_value_type;
399: g_pct_tolerance_value := p_pct_tolerance_value;
400:
401: IF p_import_worksheet_type = FND_API.G_MISS_CHAR THEN
402: l_import_ws_type := 'B';
403: ELSE
404: l_import_ws_type := p_import_worksheet_type;
405: END IF;

Line 416: RAISE FND_API.G_EXC_ERROR ;

412:
413: IF ( nvl(Recinfo.selected_stage_id,0) > 0 ) THEN
414: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_NOT_ALLOWED');
415: FND_MSG_PUB.Add;
416: RAISE FND_API.G_EXC_ERROR ;
417: END IF;
418:
419: l_selected_template_id := Recinfo.selected_template_id;
420: g_position_export_status := Recinfo.position_export_status;

Line 431: RAISE FND_API.G_EXC_ERROR ;

427: ELSE
428: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ARGUMENT');
429: FND_MESSAGE.SET_TOKEN('ROUTINE', 'Import Worksheet Procedure' );
430: FND_MSG_PUB.Add;
431: RAISE FND_API.G_EXC_ERROR ;
432: END IF;
433: CLOSE exp_ws_cur;
434:
435: -- Check if the exported worksheet moved stage or is frozen

Line 451: RAISE FND_API.G_EXC_ERROR ;

447: IF g_current_stage_seq <> ws_rec.current_stage_seq
448: OR nvl(ws_rec.freeze_flag,'N') = 'Y' THEN
449: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_NOT_ALLOWED');
450: FND_MSG_PUB.Add;
451: RAISE FND_API.G_EXC_ERROR ;
452: END IF;
453:
454: g_global_worksheet_flag := ws_rec.global_worksheet_flag;
455: g_local_copy_flag := ws_rec.local_copy_flag;

Line 499: RAISE FND_API.G_EXC_ERROR;

495: -- Rewritten Code
496: IF l_import_accounts and ( nvl(l_selected_template_id,0) > 0 ) THEN
497: FND_MESSAGE.SET_NAME('PSB', 'PSB_IMPORT_NOT_ALLOWED');
498: FND_MSG_PUB.Add;
499: RAISE FND_API.G_EXC_ERROR;
500: END IF;
501:
502: IF l_import_ws_type IN ('P','B') and
503: nvl(g_position_export_status,'INSERT') = 'VALIDATE' and

Line 513: RAISE FND_API.G_EXC_ERROR ;

509: ( not l_import_positions) THEN
510: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ARGUMENT');
511: FND_MESSAGE.SET_TOKEN('ROUTINE', 'Import Worksheet Procedure' );
512: FND_MSG_PUB.Add;
513: RAISE FND_API.G_EXC_ERROR ;
514: END IF;
515:
516: --
517: --comment the line below when done with testing

Line 531: p_init_msg_list => FND_API.G_FALSE,

527:
528: PSB_WS_Ops_Pvt.Find_Parent_Worksheets
529: (
530: p_api_version => 1.0,
531: p_init_msg_list => FND_API.G_FALSE,
532: p_commit => FND_API.G_FALSE,
533: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
534: p_return_status => l_return_status,
535: p_msg_count => l_msg_count,

Line 532: p_commit => FND_API.G_FALSE,

528: PSB_WS_Ops_Pvt.Find_Parent_Worksheets
529: (
530: p_api_version => 1.0,
531: p_init_msg_list => FND_API.G_FALSE,
532: p_commit => FND_API.G_FALSE,
533: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
534: p_return_status => l_return_status,
535: p_msg_count => l_msg_count,
536: p_msg_data => l_msg_data,

Line 533: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

529: (
530: p_api_version => 1.0,
531: p_init_msg_list => FND_API.G_FALSE,
532: p_commit => FND_API.G_FALSE,
533: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
534: p_return_status => l_return_status,
535: p_msg_count => l_msg_count,
536: p_msg_data => l_msg_data,
537: --

Line 542: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

538: p_worksheet_id => g_worksheet_id,
539: p_worksheet_tbl => g_worksheets_tbl
540: );
541:
542: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
543: raise FND_API.G_EXC_ERROR;
544: END IF;
545: END IF;
546:

Line 543: raise FND_API.G_EXC_ERROR;

539: p_worksheet_tbl => g_worksheets_tbl
540: );
541:
542: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
543: raise FND_API.G_EXC_ERROR;
544: END IF;
545: END IF;
546:
547: PSB_WS_ACCT1.Cache_Budget_Calendar

Line 551: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

547: PSB_WS_ACCT1.Cache_Budget_Calendar
548: (p_return_status => l_return_status,
549: p_budget_calendar_id => g_budget_calendar_id);
550:
551: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
552: raise FND_API.G_EXC_ERROR;
553: end if;
554:
555: -- Setup the Calendar Info in Globals

Line 552: raise FND_API.G_EXC_ERROR;

548: (p_return_status => l_return_status,
549: p_budget_calendar_id => g_budget_calendar_id);
550:
551: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
552: raise FND_API.G_EXC_ERROR;
553: end if;
554:
555: -- Setup the Calendar Info in Globals
556: PSB_EXCEL_PVT.Get_Calendar_Dates

Line 596: IF FND_API.to_Boolean (p_commit) then

592: END IF;
593:
594: Delete_Export_Header;
595:
596: IF FND_API.to_Boolean (p_commit) then
597: commit work;
598: END IF;
599:
600: EXCEPTION

Line 602: WHEN FND_API.G_EXC_ERROR THEN

598: END IF;
599:
600: EXCEPTION
601: --
602: WHEN FND_API.G_EXC_ERROR THEN
603: --
604: ROLLBACK TO Move_To_PSB_Pvt;
605: p_return_status := FND_API.G_RET_STS_ERROR;
606: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 605: p_return_status := FND_API.G_RET_STS_ERROR;

601: --
602: WHEN FND_API.G_EXC_ERROR THEN
603: --
604: ROLLBACK TO Move_To_PSB_Pvt;
605: p_return_status := FND_API.G_RET_STS_ERROR;
606: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
607: p_data => p_msg_data );
608: --
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

605: p_return_status := FND_API.G_RET_STS_ERROR;
606: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
607: p_data => p_msg_data );
608: --
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: --
611: ROLLBACK TO Move_To_PSB_Pvt;
612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

608: --
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: --
611: ROLLBACK TO Move_To_PSB_Pvt;
612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
614: p_data => p_msg_data );
615: --
616: WHEN OTHERS THEN

Line 619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

615: --
616: WHEN OTHERS THEN
617: --
618: ROLLBACK TO Move_To_PSB_Pvt;
619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: --
621: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
622: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
623: l_api_name);

Line 929: l_validation_status := FND_API.G_RET_STS_SUCCESS;

925: END LOOP;
926: /* End Bug 3558916 */
927:
928:
929: l_validation_status := FND_API.G_RET_STS_SUCCESS;
930: -- Initialize the table
931: FOR l_index in 1..PSB_WS_ACCT1.G_MAX_NUM_AMOUNTS LOOP
932: l_period_amount(l_index) := NULL;
933: END LOOP;

Line 1081: p_init_msg_list => FND_API.G_FALSE,

1077:
1078: PSB_WS_ACCT_PVT.Create_Account_Dist
1079: (
1080: p_api_version => 1.0,
1081: p_init_msg_list => FND_API.G_FALSE,
1082: p_commit => FND_API.G_FALSE,
1083: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1084: p_return_status => l_return_status,
1085: p_msg_count => l_msg_count,

Line 1082: p_commit => FND_API.G_FALSE,

1078: PSB_WS_ACCT_PVT.Create_Account_Dist
1079: (
1080: p_api_version => 1.0,
1081: p_init_msg_list => FND_API.G_FALSE,
1082: p_commit => FND_API.G_FALSE,
1083: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1084: p_return_status => l_return_status,
1085: p_msg_count => l_msg_count,
1086: p_msg_data => l_msg_data,

Line 1083: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1079: (
1080: p_api_version => 1.0,
1081: p_init_msg_list => FND_API.G_FALSE,
1082: p_commit => FND_API.G_FALSE,
1083: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1084: p_return_status => l_return_status,
1085: p_msg_count => l_msg_count,
1086: p_msg_data => l_msg_data,
1087: --

Line 1088: p_distribute_flag => FND_API.G_TRUE,

1084: p_return_status => l_return_status,
1085: p_msg_count => l_msg_count,
1086: p_msg_data => l_msg_data,
1087: --
1088: p_distribute_flag => FND_API.G_TRUE,
1089: p_worksheet_id => g_worksheet_id,
1090: p_account_line_id => l_account_line_id,
1091: p_service_package_id => l_spid,
1092: p_ytd_amount => g_year_amts(col_index).amount,

Line 1097: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1093: --
1094: p_period_amount => l_period_amount
1095: );
1096:
1097: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1098: RAISE FND_API.G_EXC_ERROR ;
1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1101: END IF;

Line 1098: RAISE FND_API.G_EXC_ERROR ;

1094: p_period_amount => l_period_amount
1095: );
1096:
1097: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1098: RAISE FND_API.G_EXC_ERROR ;
1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1101: END IF;
1102:

Line 1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1095: );
1096:
1097: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1098: RAISE FND_API.G_EXC_ERROR ;
1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1101: END IF;
1102:
1103: END IF;

Line 1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1096:
1097: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1098: RAISE FND_API.G_EXC_ERROR ;
1099: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1101: END IF;
1102:
1103: END IF;
1104:

Line 1115: p_init_msg_list => FND_API.G_FALSE,

1111: IF not validated_acct THEN
1112: PSB_VALIDATE_ACCT_PVT.Validate_Account
1113: (
1114: p_api_version => 1.0,
1115: p_init_msg_list => FND_API.G_FALSE,
1116: p_commit => FND_API.G_FALSE,
1117: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1118: p_return_status => l_return_status,
1119: p_msg_count => l_msg_count,

Line 1116: p_commit => FND_API.G_FALSE,

1112: PSB_VALIDATE_ACCT_PVT.Validate_Account
1113: (
1114: p_api_version => 1.0,
1115: p_init_msg_list => FND_API.G_FALSE,
1116: p_commit => FND_API.G_FALSE,
1117: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1118: p_return_status => l_return_status,
1119: p_msg_count => l_msg_count,
1120: p_msg_data => l_msg_data,

Line 1117: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1113: (
1114: p_api_version => 1.0,
1115: p_init_msg_list => FND_API.G_FALSE,
1116: p_commit => FND_API.G_FALSE,
1117: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1118: p_return_status => l_return_status,
1119: p_msg_count => l_msg_count,
1120: p_msg_data => l_msg_data,
1121: --

Line 1127: p_create_budget_account => FND_API.G_TRUE,

1123: p_startdate_pp => g_pp_start_date,
1124: p_enddate_cy => g_cy_end_date,
1125: p_set_of_books_id => g_set_of_books_id,
1126: p_flex_code => g_chart_of_accounts_id,
1127: p_create_budget_account => FND_API.G_TRUE,
1128: --
1129: p_concatenated_segments => l_concatenated_account,
1130: --
1131: p_worksheet_id => g_global_worksheet_id,

Line 1132: p_in_ccid => FND_API.G_MISS_NUM,

1128: --
1129: p_concatenated_segments => l_concatenated_account,
1130: --
1131: p_worksheet_id => g_global_worksheet_id,
1132: p_in_ccid => FND_API.G_MISS_NUM,
1133: p_out_ccid => va_ccid,
1134: p_budget_group_id => va_budget_group_id
1135: );
1136:

Line 1137: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1133: p_out_ccid => va_ccid,
1134: p_budget_group_id => va_budget_group_id
1135: );
1136:
1137: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1138: validated_acct := TRUE;
1139: l_budget_group_id := va_budget_group_id;
1140: ELSE
1141: l_validation_status := FND_API.G_RET_STS_ERROR;

Line 1141: l_validation_status := FND_API.G_RET_STS_ERROR;

1137: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1138: validated_acct := TRUE;
1139: l_budget_group_id := va_budget_group_id;
1140: ELSE
1141: l_validation_status := FND_API.G_RET_STS_ERROR;
1142: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_CC_SEG');
1143: FND_MESSAGE.SET_TOKEN('CC', l_concatenated_account );
1144: FND_MSG_PUB.Add;
1145: RAISE FND_API.G_EXC_ERROR;

Line 1145: RAISE FND_API.G_EXC_ERROR;

1141: l_validation_status := FND_API.G_RET_STS_ERROR;
1142: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_CC_SEG');
1143: FND_MESSAGE.SET_TOKEN('CC', l_concatenated_account );
1144: FND_MSG_PUB.Add;
1145: RAISE FND_API.G_EXC_ERROR;
1146: END IF;
1147:
1148: END IF; -- if not validated even once for the record
1149: -- Create the Account

Line 1159: p_init_msg_list => FND_API.G_FALSE,

1155:
1156: PSB_WS_ACCT_PVT.Create_Account_Dist
1157: (
1158: p_api_version => 1.0,
1159: p_init_msg_list => FND_API.G_FALSE,
1160: p_commit => FND_API.G_FALSE,
1161: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1162: p_return_status => l_return_status,
1163: p_msg_count => l_msg_count,

Line 1160: p_commit => FND_API.G_FALSE,

1156: PSB_WS_ACCT_PVT.Create_Account_Dist
1157: (
1158: p_api_version => 1.0,
1159: p_init_msg_list => FND_API.G_FALSE,
1160: p_commit => FND_API.G_FALSE,
1161: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1162: p_return_status => l_return_status,
1163: p_msg_count => l_msg_count,
1164: p_msg_data => l_msg_data,

Line 1161: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1157: (
1158: p_api_version => 1.0,
1159: p_init_msg_list => FND_API.G_FALSE,
1160: p_commit => FND_API.G_FALSE,
1161: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1162: p_return_status => l_return_status,
1163: p_msg_count => l_msg_count,
1164: p_msg_data => l_msg_data,
1165: --

Line 1176: p_distribute_flag => FND_API.G_TRUE,

1172: p_concatenated_segments => l_concatenated_account,
1173: p_currency_code => g_currency_code,
1174: p_balance_type => 'E', -- Always Estimate
1175: p_ytd_amount => g_year_amts(col_index).amount,
1176: p_distribute_flag => FND_API.G_TRUE,
1177: p_period_amount => l_period_amount,
1178: p_service_package_id => l_spid
1179: );
1180:

Line 1182: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1178: p_service_package_id => l_spid
1179: );
1180:
1181:
1182: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1183: RAISE FND_API.G_EXC_ERROR ;
1184: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1186: END IF;

Line 1183: RAISE FND_API.G_EXC_ERROR ;

1179: );
1180:
1181:
1182: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1183: RAISE FND_API.G_EXC_ERROR ;
1184: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1186: END IF;
1187:

Line 1184: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1180:
1181:
1182: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1183: RAISE FND_API.G_EXC_ERROR ;
1184: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1186: END IF;
1187:
1188:

Line 1185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1181:
1182: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1183: RAISE FND_API.G_EXC_ERROR ;
1184: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1186: END IF;
1187:
1188:
1189: END IF; --new acct or old acct and not found_acct_line

Line 1198: WHEN FND_API.G_EXC_ERROR then

1194:
1195: END LOOP; -- For 1..tblcount
1196:
1197: EXCEPTION -- To handle exceptions at record level and continue with the rest
1198: WHEN FND_API.G_EXC_ERROR then
1199: l_validation_status := FND_API.G_RET_STS_ERROR;
1200: -- Other Exceptions are handled in Import WS procedure
1201: END;
1202: END LOOP; --For each record in WAL Interface

Line 1199: l_validation_status := FND_API.G_RET_STS_ERROR;

1195: END LOOP; -- For 1..tblcount
1196:
1197: EXCEPTION -- To handle exceptions at record level and continue with the rest
1198: WHEN FND_API.G_EXC_ERROR then
1199: l_validation_status := FND_API.G_RET_STS_ERROR;
1200: -- Other Exceptions are handled in Import WS procedure
1201: END;
1202: END LOOP; --For each record in WAL Interface
1203:

Line 1206: IF l_validation_status = FND_API.G_RET_STS_ERROR THEN

1202: END LOOP; --For each record in WAL Interface
1203:
1204: CLOSE cur_wlbi;
1205:
1206: IF l_validation_status = FND_API.G_RET_STS_ERROR THEN
1207: raise FND_API.G_EXC_ERROR;
1208: END IF;
1209:
1210: END Get_WS_Line_Bal;

Line 1207: raise FND_API.G_EXC_ERROR;

1203:
1204: CLOSE cur_wlbi;
1205:
1206: IF l_validation_status = FND_API.G_RET_STS_ERROR THEN
1207: raise FND_API.G_EXC_ERROR;
1208: END IF;
1209:
1210: END Get_WS_Line_Bal;
1211:

Line 1346: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1342: p_data_extract_id => g_data_extract_id,
1343: p_business_group_id => g_business_group_id,
1344: p_worksheet_id => g_worksheet_id);
1345:
1346: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1347: raise FND_API.G_EXC_ERROR;
1348: end if;
1349:
1350:

Line 1347: raise FND_API.G_EXC_ERROR;

1343: p_business_group_id => g_business_group_id,
1344: p_worksheet_id => g_worksheet_id);
1345:
1346: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1347: raise FND_API.G_EXC_ERROR;
1348: end if;
1349:
1350:
1351: PSB_WS_POS1.Cache_Named_Attributes

Line 1355: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1351: PSB_WS_POS1.Cache_Named_Attributes
1352: (p_return_status => l_return_status,
1353: p_business_group_id => g_business_group_id);
1354:
1355: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1356: raise FND_API.G_EXC_ERROR;
1357: end if;
1358:
1359: ua_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1356: raise FND_API.G_EXC_ERROR;

1352: (p_return_status => l_return_status,
1353: p_business_group_id => g_business_group_id);
1354:
1355: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1356: raise FND_API.G_EXC_ERROR;
1357: end if;
1358:
1359: ua_return_status := FND_API.G_RET_STS_SUCCESS;
1360: ud_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1359: ua_return_status := FND_API.G_RET_STS_SUCCESS;

1355: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1356: raise FND_API.G_EXC_ERROR;
1357: end if;
1358:
1359: ua_return_status := FND_API.G_RET_STS_SUCCESS;
1360: ud_return_status := FND_API.G_RET_STS_SUCCESS;
1361:
1362:
1363: -- Drive the process with Positions

Line 1360: ud_return_status := FND_API.G_RET_STS_SUCCESS;

1356: raise FND_API.G_EXC_ERROR;
1357: end if;
1358:
1359: ua_return_status := FND_API.G_RET_STS_SUCCESS;
1360: ud_return_status := FND_API.G_RET_STS_SUCCESS;
1361:
1362:
1363: -- Drive the process with Positions
1364: FOR position_rec in

Line 1378: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

1374:
1375: Update_Assignments(p_return_status => l_return_status,
1376: p_position_line_id => position_rec.position_line_id);
1377:
1378: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1379: ua_return_status := l_return_status;
1380: END IF;
1381:
1382: END LOOP;

Line 1390: -- Using FND_API constants here leads to DB crash

1386: -- total element cost change
1387:
1388: Update_Distributions(p_return_status => ud_return_status);
1389:
1390: -- Using FND_API constants here leads to DB crash
1391: IF (ua_return_status <> 'S' ) OR
1392: (ud_return_status <> 'S' ) THEN
1393: raise FND_API.G_EXC_ERROR;
1394: END IF;

Line 1393: raise FND_API.G_EXC_ERROR;

1389:
1390: -- Using FND_API constants here leads to DB crash
1391: IF (ua_return_status <> 'S' ) OR
1392: (ud_return_status <> 'S' ) THEN
1393: raise FND_API.G_EXC_ERROR;
1394: END IF;
1395:
1396: END Get_POS_WS_Line_Bal;
1397:

Line 1456: l_validation_status := FND_API.G_RET_STS_SUCCESS;

1452:
1453: l_disp_amt number;
1454:
1455: BEGIN
1456: l_validation_status := FND_API.G_RET_STS_SUCCESS;
1457:
1458: -- Initialize the table
1459: FOR l_index in 1..PSB_WS_ACCT1.G_MAX_NUM_AMOUNTS LOOP
1460: l_period_amounts(l_index) := NULL;

Line 1735: RAISE FND_API.G_EXC_ERROR ;

1731: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ELEMENT_SET');
1732: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_ID', l_pay_element_id );
1733: FND_MESSAGE.SET_TOKEN('POSITION_LINE_ID', l_position_line_id );
1734: FND_MSG_PUB.Add;
1735: RAISE FND_API.G_EXC_ERROR ;
1736: END IF;
1737:
1738: old_acct := FALSE;
1739: new_acct := FALSE;

Line 1803: p_init_msg_list => FND_API.G_FALSE,

1799:
1800: PSB_WS_ACCT_PVT.Create_Account_Dist
1801: (
1802: p_api_version => 1.0,
1803: p_init_msg_list => FND_API.G_FALSE,
1804: p_commit => FND_API.G_FALSE,
1805: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1806: p_return_status => l_return_status,
1807: p_msg_count => l_msg_count,

Line 1804: p_commit => FND_API.G_FALSE,

1800: PSB_WS_ACCT_PVT.Create_Account_Dist
1801: (
1802: p_api_version => 1.0,
1803: p_init_msg_list => FND_API.G_FALSE,
1804: p_commit => FND_API.G_FALSE,
1805: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1806: p_return_status => l_return_status,
1807: p_msg_count => l_msg_count,
1808: p_msg_data => l_msg_data,

Line 1805: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1801: (
1802: p_api_version => 1.0,
1803: p_init_msg_list => FND_API.G_FALSE,
1804: p_commit => FND_API.G_FALSE,
1805: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1806: p_return_status => l_return_status,
1807: p_msg_count => l_msg_count,
1808: p_msg_data => l_msg_data,
1809: --

Line 1818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1814: --
1815: p_period_amount => l_period_amounts
1816: );
1817:
1818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1819: RAISE FND_API.G_EXC_ERROR ;
1820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1822: END IF;

Line 1819: RAISE FND_API.G_EXC_ERROR ;

1815: p_period_amount => l_period_amounts
1816: );
1817:
1818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1819: RAISE FND_API.G_EXC_ERROR ;
1820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1822: END IF;
1823:

Line 1820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1816: );
1817:
1818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1819: RAISE FND_API.G_EXC_ERROR ;
1820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1822: END IF;
1823:
1824: IF ( l_salary_account_line = 'Y') THEN

Line 1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1817:
1818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1819: RAISE FND_API.G_EXC_ERROR ;
1820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1822: END IF;
1823:
1824: IF ( l_salary_account_line = 'Y') THEN
1825: l_create_follow_sal_acct := TRUE;

Line 1835: p_init_msg_list => FND_API.G_FALSE,

1831: IF not validated_acct THEN
1832: PSB_VALIDATE_ACCT_PVT.Validate_Account
1833: (
1834: p_api_version => 1.0,
1835: p_init_msg_list => FND_API.G_FALSE,
1836: p_commit => FND_API.G_FALSE,
1837: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1838: p_return_status => l_return_status,
1839: p_msg_count => l_msg_count,

Line 1836: p_commit => FND_API.G_FALSE,

1832: PSB_VALIDATE_ACCT_PVT.Validate_Account
1833: (
1834: p_api_version => 1.0,
1835: p_init_msg_list => FND_API.G_FALSE,
1836: p_commit => FND_API.G_FALSE,
1837: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1838: p_return_status => l_return_status,
1839: p_msg_count => l_msg_count,
1840: p_msg_data => l_msg_data,

Line 1837: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1833: (
1834: p_api_version => 1.0,
1835: p_init_msg_list => FND_API.G_FALSE,
1836: p_commit => FND_API.G_FALSE,
1837: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1838: p_return_status => l_return_status,
1839: p_msg_count => l_msg_count,
1840: p_msg_data => l_msg_data,
1841: --

Line 1847: p_create_budget_account => FND_API.G_TRUE,

1843: p_startdate_pp => g_pp_start_date,
1844: p_enddate_cy => g_cy_end_date,
1845: p_set_of_books_id => g_set_of_books_id,
1846: p_flex_code => g_chart_of_accounts_id,
1847: p_create_budget_account => FND_API.G_TRUE,
1848: --
1849: p_concatenated_segments => l_concatenated_account,
1850: --
1851: p_worksheet_id => g_global_worksheet_id,

Line 1852: p_in_ccid => FND_API.G_MISS_NUM,

1848: --
1849: p_concatenated_segments => l_concatenated_account,
1850: --
1851: p_worksheet_id => g_global_worksheet_id,
1852: p_in_ccid => FND_API.G_MISS_NUM,
1853: p_out_ccid => va_ccid,
1854: p_budget_group_id => va_budget_group_id
1855: );
1856:

Line 1857: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1853: p_out_ccid => va_ccid,
1854: p_budget_group_id => va_budget_group_id
1855: );
1856:
1857: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1858: validated_acct := TRUE;
1859: l_budget_group_id := va_budget_group_id;
1860: ELSE
1861: l_validation_status := FND_API.G_RET_STS_ERROR;

Line 1861: l_validation_status := FND_API.G_RET_STS_ERROR;

1857: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1858: validated_acct := TRUE;
1859: l_budget_group_id := va_budget_group_id;
1860: ELSE
1861: l_validation_status := FND_API.G_RET_STS_ERROR;
1862: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_CC_SEG');
1863: FND_MESSAGE.SET_TOKEN('CC', l_concatenated_account );
1864: FND_MSG_PUB.Add;
1865: RAISE FND_API.G_EXC_ERROR ;

Line 1865: RAISE FND_API.G_EXC_ERROR ;

1861: l_validation_status := FND_API.G_RET_STS_ERROR;
1862: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_CC_SEG');
1863: FND_MESSAGE.SET_TOKEN('CC', l_concatenated_account );
1864: FND_MSG_PUB.Add;
1865: RAISE FND_API.G_EXC_ERROR ;
1866: END IF;
1867:
1868:
1869: END IF; -- if not validated even once for the record

Line 1874: p_init_msg_list => FND_API.G_FALSE,

1870:
1871: PSB_WS_ACCT_PVT.Create_Account_Dist
1872: (
1873: p_api_version => 1.0,
1874: p_init_msg_list => FND_API.G_FALSE,
1875: p_commit => FND_API.G_FALSE,
1876: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1877: p_return_status => l_return_status,
1878: p_msg_count => l_msg_count,

Line 1875: p_commit => FND_API.G_FALSE,

1871: PSB_WS_ACCT_PVT.Create_Account_Dist
1872: (
1873: p_api_version => 1.0,
1874: p_init_msg_list => FND_API.G_FALSE,
1875: p_commit => FND_API.G_FALSE,
1876: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1877: p_return_status => l_return_status,
1878: p_msg_count => l_msg_count,
1879: p_msg_data => l_msg_data,

Line 1876: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1872: (
1873: p_api_version => 1.0,
1874: p_init_msg_list => FND_API.G_FALSE,
1875: p_commit => FND_API.G_FALSE,
1876: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1877: p_return_status => l_return_status,
1878: p_msg_count => l_msg_count,
1879: p_msg_data => l_msg_data,
1880: --

Line 1891: p_distribute_flag => FND_API.G_FALSE,

1887: p_concatenated_segments => l_concatenated_account,
1888: p_currency_code => g_currency_code,
1889: p_balance_type => 'E', -- Always Estimate
1890: p_ytd_amount => l_year_amount,
1891: p_distribute_flag => FND_API.G_FALSE,
1892: p_period_amount => l_period_amounts,
1893: p_service_package_id => l_spid,
1894: p_position_line_id => l_position_line_id,
1895: p_element_set_id => l_element_set_id,

Line 1900: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1896: p_salary_account_line => l_salary_account_line
1897:
1898: );
1899:
1900: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1901: RAISE FND_API.G_EXC_ERROR ;
1902: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1904: END IF;

Line 1901: RAISE FND_API.G_EXC_ERROR ;

1897:
1898: );
1899:
1900: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1901: RAISE FND_API.G_EXC_ERROR ;
1902: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1904: END IF;
1905:

Line 1902: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1898: );
1899:
1900: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1901: RAISE FND_API.G_EXC_ERROR ;
1902: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1904: END IF;
1905:
1906: IF ( l_salary_account_line = 'Y') AND

Line 1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1899:
1900: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1901: RAISE FND_API.G_EXC_ERROR ;
1902: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1904: END IF;
1905:
1906: IF ( l_salary_account_line = 'Y') AND
1907: ( nvl(ca_account_line_id,0) <> 0 ) THEN

Line 1922: p_init_msg_list => FND_API.G_FALSE,

1918:
1919: PSB_WS_POSITION_RFS_PVT.Redistribute_Follow_Salary
1920: (
1921: p_api_version => 1.0,
1922: p_init_msg_list => FND_API.G_FALSE,
1923: p_commit => FND_API.G_FALSE,
1924: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1925: p_return_status => l_return_status,
1926: p_msg_count => l_msg_count,

Line 1923: p_commit => FND_API.G_FALSE,

1919: PSB_WS_POSITION_RFS_PVT.Redistribute_Follow_Salary
1920: (
1921: p_api_version => 1.0,
1922: p_init_msg_list => FND_API.G_FALSE,
1923: p_commit => FND_API.G_FALSE,
1924: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1925: p_return_status => l_return_status,
1926: p_msg_count => l_msg_count,
1927: p_msg_data => l_msg_data,

Line 1924: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1920: (
1921: p_api_version => 1.0,
1922: p_init_msg_list => FND_API.G_FALSE,
1923: p_commit => FND_API.G_FALSE,
1924: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1925: p_return_status => l_return_status,
1926: p_msg_count => l_msg_count,
1927: p_msg_data => l_msg_data,
1928: --

Line 1935: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1931: p_service_package_id => l_spid,
1932: p_stage_set_id => g_stage_set_id
1933: );
1934:
1935: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1936: RAISE FND_API.G_EXC_ERROR ;
1937: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1939: END IF;

Line 1936: RAISE FND_API.G_EXC_ERROR ;

1932: p_stage_set_id => g_stage_set_id
1933: );
1934:
1935: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1936: RAISE FND_API.G_EXC_ERROR ;
1937: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1939: END IF;
1940:

Line 1937: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1933: );
1934:
1935: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1936: RAISE FND_API.G_EXC_ERROR ;
1937: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1939: END IF;
1940:
1941: END IF; --create follow salary acct(called both on insert and update)

Line 1938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1934:
1935: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1936: RAISE FND_API.G_EXC_ERROR ;
1937: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1939: END IF;
1940:
1941: END IF; --create follow salary acct(called both on insert and update)
1942:

Line 1944: WHEN FND_API.G_EXC_ERROR then

1940:
1941: END IF; --create follow salary acct(called both on insert and update)
1942:
1943: EXCEPTION -- To handle exceptions at record level and continue with the rest
1944: WHEN FND_API.G_EXC_ERROR then
1945: l_validation_status := FND_API.G_RET_STS_ERROR;
1946: END;
1947: END LOOP; -- for wlbi rec
1948:

Line 1945: l_validation_status := FND_API.G_RET_STS_ERROR;

1941: END IF; --create follow salary acct(called both on insert and update)
1942:
1943: EXCEPTION -- To handle exceptions at record level and continue with the rest
1944: WHEN FND_API.G_EXC_ERROR then
1945: l_validation_status := FND_API.G_RET_STS_ERROR;
1946: END;
1947: END LOOP; -- for wlbi rec
1948:
1949: IF l_validation_status = FND_API.G_RET_STS_ERROR THEN

Line 1949: IF l_validation_status = FND_API.G_RET_STS_ERROR THEN

1945: l_validation_status := FND_API.G_RET_STS_ERROR;
1946: END;
1947: END LOOP; -- for wlbi rec
1948:
1949: IF l_validation_status = FND_API.G_RET_STS_ERROR THEN
1950: p_return_status := FND_API.G_RET_STS_ERROR;
1951: ELSE
1952: p_return_status := FND_API.G_RET_STS_SUCCESS;
1953: END IF;

Line 1950: p_return_status := FND_API.G_RET_STS_ERROR;

1946: END;
1947: END LOOP; -- for wlbi rec
1948:
1949: IF l_validation_status = FND_API.G_RET_STS_ERROR THEN
1950: p_return_status := FND_API.G_RET_STS_ERROR;
1951: ELSE
1952: p_return_status := FND_API.G_RET_STS_SUCCESS;
1953: END IF;
1954:

Line 1952: p_return_status := FND_API.G_RET_STS_SUCCESS;

1948:
1949: IF l_validation_status = FND_API.G_RET_STS_ERROR THEN
1950: p_return_status := FND_API.G_RET_STS_ERROR;
1951: ELSE
1952: p_return_status := FND_API.G_RET_STS_SUCCESS;
1953: END IF;
1954:
1955: EXCEPTION
1956:

Line 1957: when FND_API.G_EXC_UNEXPECTED_ERROR then

1953: END IF;
1954:
1955: EXCEPTION
1956:
1957: when FND_API.G_EXC_UNEXPECTED_ERROR then
1958: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1959: when OTHERS then
1960: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1961:

Line 1958: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1954:
1955: EXCEPTION
1956:
1957: when FND_API.G_EXC_UNEXPECTED_ERROR then
1958: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1959: when OTHERS then
1960: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1961:
1962: END Update_Distributions;

Line 1960: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1956:
1957: when FND_API.G_EXC_UNEXPECTED_ERROR then
1958: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1959: when OTHERS then
1960: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1961:
1962: END Update_Distributions;
1963:
1964:

Line 2104: where nvl(c.pay_element_option_id, FND_API.G_MISS_NUM) = nvl(a.pay_element_option_id, FND_API.G_MISS_NUM)

2100: and a.currency_code = g_currency_code
2101: and exists
2102: (select 1
2103: from PSB_POSITION_ASSIGNMENTS c
2104: where nvl(c.pay_element_option_id, FND_API.G_MISS_NUM) = nvl(a.pay_element_option_id, FND_API.G_MISS_NUM)
2105: and (c.worksheet_id is null or c.worksheet_id = g_global_worksheet_id)
2106: and c.currency_code = g_currency_code
2107: and (((c.effective_start_date <= l_end_date)
2108: and (c.effective_end_date is null))

Line 2201: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2197: p_data_extract_id => g_data_extract_id,
2198: p_position_id => l_position_id);
2199:
2200:
2201: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2202: raise FND_API.G_EXC_ERROR;
2203: end if;
2204:
2205: for c_Element_Assignments_Rec in c_Element_Assignments loop

Line 2202: raise FND_API.G_EXC_ERROR;

2198: p_position_id => l_position_id);
2199:
2200:
2201: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2202: raise FND_API.G_EXC_ERROR;
2203: end if;
2204:
2205: for c_Element_Assignments_Rec in c_Element_Assignments loop
2206:

Line 2248: p_return_status := FND_API.G_RET_STS_SUCCESS;

2244: g_poswkh_assignments(g_num_poswkh_assignments).default_weekly_hours := c_Attributes_Rec.attribute_value;
2245:
2246: end loop;
2247:
2248: p_return_status := FND_API.G_RET_STS_SUCCESS;
2249: EXCEPTION
2250:
2251: when FND_API.G_EXC_ERROR then
2252: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2251: when FND_API.G_EXC_ERROR then

2247:
2248: p_return_status := FND_API.G_RET_STS_SUCCESS;
2249: EXCEPTION
2250:
2251: when FND_API.G_EXC_ERROR then
2252: p_return_status := FND_API.G_RET_STS_ERROR;
2253:
2254: when FND_API.G_EXC_UNEXPECTED_ERROR then
2255: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2252: p_return_status := FND_API.G_RET_STS_ERROR;

2248: p_return_status := FND_API.G_RET_STS_SUCCESS;
2249: EXCEPTION
2250:
2251: when FND_API.G_EXC_ERROR then
2252: p_return_status := FND_API.G_RET_STS_ERROR;
2253:
2254: when FND_API.G_EXC_UNEXPECTED_ERROR then
2255: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256:

Line 2254: when FND_API.G_EXC_UNEXPECTED_ERROR then

2250:
2251: when FND_API.G_EXC_ERROR then
2252: p_return_status := FND_API.G_RET_STS_ERROR;
2253:
2254: when FND_API.G_EXC_UNEXPECTED_ERROR then
2255: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256:
2257: when OTHERS then
2258: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2255: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2251: when FND_API.G_EXC_ERROR then
2252: p_return_status := FND_API.G_RET_STS_ERROR;
2253:
2254: when FND_API.G_EXC_UNEXPECTED_ERROR then
2255: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256:
2257: when OTHERS then
2258: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2259:

Line 2258: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2254: when FND_API.G_EXC_UNEXPECTED_ERROR then
2255: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256:
2257: when OTHERS then
2258: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2259:
2260: END Cache_Position_Data;
2261:
2262:

Line 2317: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2313: p_start_date => l_start_date,
2314: p_end_date => l_end_date);
2315:
2316:
2317: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2318: raise FND_API.G_EXC_ERROR;
2319: end if;
2320:
2321:

Line 2318: raise FND_API.G_EXC_ERROR;

2314: p_end_date => l_end_date);
2315:
2316:
2317: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2318: raise FND_API.G_EXC_ERROR;
2319: end if;
2320:
2321:
2322: --Outer loop (element_rec) created to get rid of group by operation

Line 2352: RAISE FND_API.G_EXC_ERROR ;

2348: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_ELEMENT_SET');
2349: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_ID', l_pay_element_id );
2350: FND_MESSAGE.SET_TOKEN('POSITION_LINE_ID', p_position_line_id );
2351: FND_MSG_PUB.Add;
2352: RAISE FND_API.G_EXC_ERROR ;
2353: END IF;
2354:
2355: -- For each pay element
2356: FOR element_total_rec IN

Line 2656: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2652: );
2653:
2654:
2655: -- Change_Position_Assignments; -- Assignment API
2656: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2657: raise FND_API.G_EXC_ERROR;
2658: end if;
2659:
2660: l_element_cost_update_reqd := TRUE;

Line 2657: raise FND_API.G_EXC_ERROR;

2653:
2654:
2655: -- Change_Position_Assignments; -- Assignment API
2656: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2657: raise FND_API.G_EXC_ERROR;
2658: end if;
2659:
2660: l_element_cost_update_reqd := TRUE;
2661:

Line 2681: p_return_status := FND_API.G_RET_STS_SUCCESS;

2677:
2678: END LOOP; --for each element total in a position
2679: END LOOP; --for each element in a position (added later to avoid group by operation)
2680:
2681: p_return_status := FND_API.G_RET_STS_SUCCESS;
2682: EXCEPTION
2683:
2684: when FND_API.G_EXC_ERROR then
2685: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2684: when FND_API.G_EXC_ERROR then

2680:
2681: p_return_status := FND_API.G_RET_STS_SUCCESS;
2682: EXCEPTION
2683:
2684: when FND_API.G_EXC_ERROR then
2685: p_return_status := FND_API.G_RET_STS_ERROR;
2686:
2687: when FND_API.G_EXC_UNEXPECTED_ERROR then
2688: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2685: p_return_status := FND_API.G_RET_STS_ERROR;

2681: p_return_status := FND_API.G_RET_STS_SUCCESS;
2682: EXCEPTION
2683:
2684: when FND_API.G_EXC_ERROR then
2685: p_return_status := FND_API.G_RET_STS_ERROR;
2686:
2687: when FND_API.G_EXC_UNEXPECTED_ERROR then
2688: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2689:

Line 2687: when FND_API.G_EXC_UNEXPECTED_ERROR then

2683:
2684: when FND_API.G_EXC_ERROR then
2685: p_return_status := FND_API.G_RET_STS_ERROR;
2686:
2687: when FND_API.G_EXC_UNEXPECTED_ERROR then
2688: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2689:
2690: when OTHERS then
2691: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2688: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2684: when FND_API.G_EXC_ERROR then
2685: p_return_status := FND_API.G_RET_STS_ERROR;
2686:
2687: when FND_API.G_EXC_UNEXPECTED_ERROR then
2688: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2689:
2690: when OTHERS then
2691: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2692:

Line 2691: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2687: when FND_API.G_EXC_UNEXPECTED_ERROR then
2688: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2689:
2690: when OTHERS then
2691: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2692:
2693: END Update_Assignments;
2694:
2695:

Line 2985: p_init_msg_list => FND_API.G_FALSE,

2981:
2982: PSB_WS_POS_PVT.Create_Element_Lines
2983: (
2984: p_api_version => 1.0,
2985: p_init_msg_list => FND_API.G_FALSE,
2986: p_commit => FND_API.G_FALSE,
2987: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2988: p_return_status => l_return_status,
2989: p_msg_count => l_msg_count,

Line 2986: p_commit => FND_API.G_FALSE,

2982: PSB_WS_POS_PVT.Create_Element_Lines
2983: (
2984: p_api_version => 1.0,
2985: p_init_msg_list => FND_API.G_FALSE,
2986: p_commit => FND_API.G_FALSE,
2987: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2988: p_return_status => l_return_status,
2989: p_msg_count => l_msg_count,
2990: p_msg_data => l_msg_data,

Line 2987: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2983: (
2984: p_api_version => 1.0,
2985: p_init_msg_list => FND_API.G_FALSE,
2986: p_commit => FND_API.G_FALSE,
2987: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2988: p_return_status => l_return_status,
2989: p_msg_count => l_msg_count,
2990: p_msg_data => l_msg_data,
2991: --

Line 3000: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2996: p_element_cost => l_wlbi_sp_element_cost
2997: );
2998:
2999: --debug('elm_return_status'||l_return_status);
3000: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR ;
3002: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3004: END IF;

Line 3001: RAISE FND_API.G_EXC_ERROR ;

2997: );
2998:
2999: --debug('elm_return_status'||l_return_status);
3000: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR ;
3002: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3004: END IF;
3005:

Line 3002: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2998:
2999: --debug('elm_return_status'||l_return_status);
3000: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR ;
3002: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3004: END IF;
3005:
3006: ELSE

Line 3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2999: --debug('elm_return_status'||l_return_status);
3000: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3001: RAISE FND_API.G_EXC_ERROR ;
3002: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3004: END IF;
3005:
3006: ELSE
3007: -- Call Create Element Lines API

Line 3012: p_init_msg_list => FND_API.G_FALSE,

3008:
3009: PSB_WS_POS_PVT.Create_Element_Lines
3010: (
3011: p_api_version => 1.0,
3012: p_init_msg_list => FND_API.G_FALSE,
3013: p_commit => FND_API.G_FALSE,
3014: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3015: p_return_status => l_return_status,
3016: p_msg_count => l_msg_count,

Line 3013: p_commit => FND_API.G_FALSE,

3009: PSB_WS_POS_PVT.Create_Element_Lines
3010: (
3011: p_api_version => 1.0,
3012: p_init_msg_list => FND_API.G_FALSE,
3013: p_commit => FND_API.G_FALSE,
3014: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3015: p_return_status => l_return_status,
3016: p_msg_count => l_msg_count,
3017: p_msg_data => l_msg_data,

Line 3014: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3010: (
3011: p_api_version => 1.0,
3012: p_init_msg_list => FND_API.G_FALSE,
3013: p_commit => FND_API.G_FALSE,
3014: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3015: p_return_status => l_return_status,
3016: p_msg_count => l_msg_count,
3017: p_msg_data => l_msg_data,
3018: --

Line 3020: -- p_check_spel_exists => FND_API.G_TRUE,

3016: p_msg_count => l_msg_count,
3017: p_msg_data => l_msg_data,
3018: --
3019: p_element_line_id => l_element_line_id,
3020: -- p_check_spel_exists => FND_API.G_TRUE,
3021: p_position_line_id => p_position_line_id,
3022: p_budget_year_id => i,
3023: p_pay_element_id => p_pay_element_id,
3024: p_currency_code => g_currency_code,

Line 3034: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

3030:
3031: );
3032:
3033: --debug('elc_return_status'||l_return_status);
3034: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3035: RAISE FND_API.G_EXC_ERROR ;
3036: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3038: END IF;

Line 3035: RAISE FND_API.G_EXC_ERROR ;

3031: );
3032:
3033: --debug('elc_return_status'||l_return_status);
3034: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3035: RAISE FND_API.G_EXC_ERROR ;
3036: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3038: END IF;
3039:

Line 3036: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3032:
3033: --debug('elc_return_status'||l_return_status);
3034: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3035: RAISE FND_API.G_EXC_ERROR ;
3036: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3038: END IF;
3039:
3040: END IF;

Line 3037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3033: --debug('elc_return_status'||l_return_status);
3034: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3035: RAISE FND_API.G_EXC_ERROR ;
3036: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3038: END IF;
3039:
3040: END IF;
3041:

Line 3179: l_salary_defined VARCHAR2(1) := FND_API.G_FALSE;

3175: l_ytd_element_cost NUMBER;
3176:
3177: l_last_period_index NUMBER;
3178:
3179: l_salary_defined VARCHAR2(1) := FND_API.G_FALSE;
3180: l_salary_element_value NUMBER;
3181:
3182:
3183: l_assign_period VARCHAR2(1);

Line 3257: l_element_assigned := FND_API.G_FALSE;

3253: end loop;
3254:
3255:
3256: l_pay_element_id := p_pay_element_id;
3257: l_element_assigned := FND_API.G_FALSE;
3258: l_nonrec_calculated := FND_API.G_FALSE;
3259:
3260: for l_assign_index in 1..g_num_poselem_assignments loop
3261: if ((g_poselem_assignments(l_assign_index).pay_element_id = l_pay_element_id) and

Line 3258: l_nonrec_calculated := FND_API.G_FALSE;

3254:
3255:
3256: l_pay_element_id := p_pay_element_id;
3257: l_element_assigned := FND_API.G_FALSE;
3258: l_nonrec_calculated := FND_API.G_FALSE;
3259:
3260: for l_assign_index in 1..g_num_poselem_assignments loop
3261: if ((g_poselem_assignments(l_assign_index).pay_element_id = l_pay_element_id) and
3262: (((g_poselem_assignments(l_assign_index).start_date <= l_year_end_date) and

Line 3268: l_element_assigned := FND_API.G_TRUE;

3264: ((g_poselem_assignments(l_assign_index).start_date between l_year_start_date and l_year_end_date) or
3265: (g_poselem_assignments(l_assign_index).end_date between l_year_start_date and l_year_end_date) or
3266: ((g_poselem_assignments(l_assign_index).start_date < l_year_start_date) and
3267: (g_poselem_assignments(l_assign_index).end_date > l_year_end_date))))) then
3268: l_element_assigned := FND_API.G_TRUE;
3269:
3270: exit;
3271: end if;
3272:

Line 3283: l_calculate_from_salary := FND_API.G_FALSE;

3279: l_assign_period_index := l_last_period_index;
3280: end if;
3281:
3282: l_ytd_element_cost := 0;
3283: l_calculate_from_salary := FND_API.G_FALSE;
3284: l_assign_period := FND_API.G_FALSE;
3285:
3286: -- Main Loop
3287: -- For each budget period with a new amount

Line 3284: l_assign_period := FND_API.G_FALSE;

3280: end if;
3281:
3282: l_ytd_element_cost := 0;
3283: l_calculate_from_salary := FND_API.G_FALSE;
3284: l_assign_period := FND_API.G_FALSE;
3285:
3286: -- Main Loop
3287: -- For each budget period with a new amount
3288:

Line 3327: l_ws_assignment := FND_API.G_FALSE;

3323: end if;
3324: end loop;
3325:
3326: -- Get the assignment data
3327: l_ws_assignment := FND_API.G_FALSE;
3328: for l_assign_index in 1..g_num_poselem_assignments loop
3329:
3330: if ((g_poselem_assignments(l_assign_index).pay_element_id = l_pay_element_id) and
3331: (g_poselem_assignments(l_assign_index).worksheet_id is not null) and

Line 3340: l_ws_assignment := FND_API.G_TRUE;

3336: ((g_poselem_assignments(l_assign_index).start_date < l_budget_period_start_date) and
3337: (g_poselem_assignments(l_assign_index).end_date > l_budget_period_end_date))))) then
3338: begin
3339:
3340: l_ws_assignment := FND_API.G_TRUE;
3341: l_pay_basis := g_poselem_assignments(l_assign_index).pay_basis;
3342: l_pay_element_option_id := g_poselem_assignments(l_assign_index).pay_element_option_id;
3343: l_element_value_type := g_poselem_assignments(l_assign_index).element_value_type;
3344: l_element_value := g_poselem_assignments(l_assign_index).element_value;

Line 3347: l_nonrec_calculated := FND_API.G_TRUE;

3343: l_element_value_type := g_poselem_assignments(l_assign_index).element_value_type;
3344: l_element_value := g_poselem_assignments(l_assign_index).element_value;
3345:
3346: if l_processing_type = 'N' then
3347: l_nonrec_calculated := FND_API.G_TRUE;
3348: end if;
3349: exit;
3350:
3351: end;

Line 3357: l_pos_assignment := FND_API.G_FALSE;

3353:
3354: end loop;
3355:
3356:
3357: l_pos_assignment := FND_API.G_FALSE;
3358: if not FND_API.to_Boolean(l_ws_assignment) then
3359: begin
3360:
3361: for l_assign_index in 1..g_num_poselem_assignments loop

Line 3358: if not FND_API.to_Boolean(l_ws_assignment) then

3354: end loop;
3355:
3356:
3357: l_pos_assignment := FND_API.G_FALSE;
3358: if not FND_API.to_Boolean(l_ws_assignment) then
3359: begin
3360:
3361: for l_assign_index in 1..g_num_poselem_assignments loop
3362:

Line 3373: l_pos_assignment := FND_API.G_TRUE;

3369: ((g_poselem_assignments(l_assign_index).start_date < l_budget_period_start_date) and
3370: (g_poselem_assignments(l_assign_index).end_date > l_budget_period_end_date))))) then
3371: begin
3372:
3373: l_pos_assignment := FND_API.G_TRUE;
3374: l_pay_basis := g_poselem_assignments(l_assign_index).pay_basis;
3375: l_pay_element_option_id := g_poselem_assignments(l_assign_index).pay_element_option_id;
3376: l_element_value_type := g_poselem_assignments(l_assign_index).element_value_type;
3377: l_element_value := g_poselem_assignments(l_assign_index).element_value;

Line 3380: l_nonrec_calculated := FND_API.G_TRUE;

3376: l_element_value_type := g_poselem_assignments(l_assign_index).element_value_type;
3377: l_element_value := g_poselem_assignments(l_assign_index).element_value;
3378:
3379: if l_processing_type = 'N' then
3380: l_nonrec_calculated := FND_API.G_TRUE;
3381: end if;
3382:
3383:
3384: exit;

Line 3394: l_value_from_elem_rates := FND_API.G_FALSE;

3390: end;
3391: end if; -- if not ws assignment
3392:
3393: -- See if the value is arrived from element rates table
3394: l_value_from_elem_rates := FND_API.G_FALSE;
3395: if l_element_value is null then
3396: begin
3397:
3398: for l_rate_index in 1..g_num_poselem_rates loop

Line 3401: (nvl(g_poselem_rates(l_rate_index).pay_element_option_id, FND_API.G_MISS_NUM) = nvl(l_pay_element_option_id, FND_API.G_MISS_NUM)) and

3397:
3398: for l_rate_index in 1..g_num_poselem_rates loop
3399:
3400: if ((g_poselem_rates(l_rate_index).pay_element_id = l_pay_element_id) and
3401: (nvl(g_poselem_rates(l_rate_index).pay_element_option_id, FND_API.G_MISS_NUM) = nvl(l_pay_element_option_id, FND_API.G_MISS_NUM)) and
3402: (((g_poselem_rates(l_rate_index).start_date <= l_budget_period_end_date) and
3403: (g_poselem_rates(l_rate_index).end_date is null)) or
3404: ((g_poselem_rates(l_rate_index).start_date between l_budget_period_start_date and l_budget_period_end_date) or
3405: (g_poselem_rates(l_rate_index).end_date between l_budget_period_start_date and l_budget_period_end_date) or

Line 3409: l_value_from_elem_rates := FND_API.G_TRUE;

3405: (g_poselem_rates(l_rate_index).end_date between l_budget_period_start_date and l_budget_period_end_date) or
3406: ((g_poselem_rates(l_rate_index).start_date < l_budget_period_start_date) and
3407: (g_poselem_rates(l_rate_index).end_date > l_budget_period_end_date))))) then
3408: begin
3409: l_value_from_elem_rates := FND_API.G_TRUE;
3410: l_element_value_type := g_poselem_rates(l_rate_index).element_value_type;
3411: l_element_value := g_poselem_rates(l_rate_index).element_value;
3412: l_formula_id := g_poselem_rates(l_rate_index).formula_id;
3413: exit;

Line 3470: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3466: p_start_date => l_budget_period_start_date,
3467: p_end_date => l_budget_period_end_date,
3468: p_factor => l_factor);
3469:
3470: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3471: raise FND_API.G_EXC_ERROR;
3472: end if;
3473:
3474:

Line 3471: raise FND_API.G_EXC_ERROR;

3467: p_end_date => l_budget_period_end_date,
3468: p_factor => l_factor);
3469:
3470: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3471: raise FND_API.G_EXC_ERROR;
3472: end if;
3473:
3474:
3475: l_new_element_value := l_new_element_cost/(l_fte * l_factor * l_num_calc_periods);

Line 3491: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3487: p_start_date => l_budget_period_start_date,
3488: p_end_date => l_budget_period_end_date,
3489: p_factor => l_factor);
3490:
3491: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3492: raise FND_API.G_EXC_ERROR;
3493: end if;
3494:
3495: if l_default_weekly_hours is null then

Line 3492: raise FND_API.G_EXC_ERROR;

3488: p_end_date => l_budget_period_end_date,
3489: p_factor => l_factor);
3490:
3491: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3492: raise FND_API.G_EXC_ERROR;
3493: end if;
3494:
3495: if l_default_weekly_hours is null then
3496: --add_message('PSB', 'PSB_INVALID_NAMED_ATTRIBUTE');

Line 3517: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3513: p_start_date => l_budget_period_start_date,
3514: p_end_date => l_budget_period_end_date,
3515: p_factor => l_factor);
3516:
3517: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3518: raise FND_API.G_EXC_ERROR;
3519: end if;
3520:
3521:

Line 3518: raise FND_API.G_EXC_ERROR;

3514: p_end_date => l_budget_period_end_date,
3515: p_factor => l_factor);
3516:
3517: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3518: raise FND_API.G_EXC_ERROR;
3519: end if;
3520:
3521:
3522: l_new_element_value := l_new_element_cost/(l_fte * l_factor * l_num_calc_periods);

Line 3540: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3536: p_element_name => l_element_name,
3537: p_start_date => l_budget_period_start_date,
3538: p_end_date => l_budget_period_end_date,
3539: p_factor => l_factor);
3540: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3541: raise FND_API.G_EXC_ERROR;
3542: end if;
3543:
3544: l_new_element_value := l_new_element_cost/(l_fte * l_factor * l_num_calc_periods );

Line 3541: raise FND_API.G_EXC_ERROR;

3537: p_start_date => l_budget_period_start_date,
3538: p_end_date => l_budget_period_end_date,
3539: p_factor => l_factor);
3540: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3541: raise FND_API.G_EXC_ERROR;
3542: end if;
3543:
3544: l_new_element_value := l_new_element_cost/(l_fte * l_factor * l_num_calc_periods );
3545:

Line 3579: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3575: p_element_name => l_element_name,
3576: p_start_date => l_budget_period_start_date,
3577: p_end_date => l_budget_period_end_date,
3578: p_factor => l_factor);
3579: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3580: raise FND_API.G_EXC_ERROR;
3581: end if;
3582: l_new_element_value := l_new_element_cost/(l_fte * l_factor * l_num_calc_periods );
3583: end;

Line 3580: raise FND_API.G_EXC_ERROR;

3576: p_start_date => l_budget_period_start_date,
3577: p_end_date => l_budget_period_end_date,
3578: p_factor => l_factor);
3579: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3580: raise FND_API.G_EXC_ERROR;
3581: end if;
3582: l_new_element_value := l_new_element_cost/(l_fte * l_factor * l_num_calc_periods );
3583: end;
3584: end if;

Line 3626: l_new_assignment_found := FND_API.G_FALSE;

3622: end if;
3623: end if;
3624:
3625:
3626: l_new_assignment_found := FND_API.G_FALSE;
3627: -- Find out the Element Option from element value
3628:
3629: l_new_element_option_id := null;
3630: if l_option_flag = 'Y' then

Line 3665: l_new_assignment_found := FND_API.G_TRUE;

3661: order by 1,2
3662: )
3663: loop
3664: l_new_element_option_id := elem_asgn_rec.pay_element_option_id;
3665: l_new_assignment_found := FND_API.G_TRUE;
3666:
3667:
3668: exit;
3669: end loop; --elem_asgn_rec

Line 3671: if l_new_assignment_found = FND_API.G_FALSE then

3667:
3668: exit;
3669: end loop; --elem_asgn_rec
3670:
3671: if l_new_assignment_found = FND_API.G_FALSE then
3672:
3673: FND_MESSAGE.SET_NAME('PSB', 'PSB_ELEMENT_OPTION_NOT_FOUND');
3674: FND_MESSAGE.SET_TOKEN('POSITION_NAME', p_position_name);
3675: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_NAME', l_element_name);

Line 3677: raise FND_API.G_EXC_ERROR;

3673: FND_MESSAGE.SET_NAME('PSB', 'PSB_ELEMENT_OPTION_NOT_FOUND');
3674: FND_MESSAGE.SET_TOKEN('POSITION_NAME', p_position_name);
3675: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_NAME', l_element_name);
3676: FND_MSG_PUB.Add;
3677: raise FND_API.G_EXC_ERROR;
3678: end if;
3679:
3680: elsif l_option_flag = 'N' then
3681:

Line 3690: raise FND_API.G_EXC_ERROR;

3686: FND_MESSAGE.SET_NAME('PSB', 'PSB_ELEMENT_OVERIDE_NA');
3687: FND_MESSAGE.SET_TOKEN('POSITION_NAME', p_position_name);
3688: FND_MESSAGE.SET_TOKEN('PAY_ELEMENT_NAME', l_element_name);
3689: FND_MSG_PUB.Add;
3690: raise FND_API.G_EXC_ERROR;
3691: end if;
3692:
3693:
3694: end if; -- option flag = 'Y'

Line 3703: AND ( l_new_assignment_found = FND_API.G_TRUE

3699: -- Call Modify Assignment API to make assignment change
3700: IF ( nvl(l_new_element_value,0) > 0 )
3701: AND nvl(l_new_element_value,0) <> nvl(l_element_value,0)
3702: AND ( l_new_element_option_id IS NOT NULL )
3703: AND ( l_new_assignment_found = FND_API.G_TRUE
3704: OR
3705: l_overwrite_flag = 'Y' ) THEN
3706:
3707: --debug('l_element_value_type'||l_element_value_type);

Line 3716: IF l_new_assignment_found = FND_API.G_TRUE THEN

3712: --debug('l_pay_basis'||l_pay_basis);
3713:
3714: -- Change made on 11/10/98
3715: -- Do not populate element value if a matching element option is found
3716: IF l_new_assignment_found = FND_API.G_TRUE THEN
3717: l_new_element_value := null;
3718: END IF;
3719:
3720:

Line 3724: p_init_msg_list => FND_API.G_FALSE,

3720:
3721:
3722: PSB_POSITIONS_PVT.Modify_Assignment(
3723: p_api_version => 1.0,
3724: p_init_msg_list => FND_API.G_FALSE,
3725: p_commit => FND_API.G_FALSE,
3726: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3727: p_return_status => l_return_status,
3728: p_msg_count => l_msg_count,

Line 3725: p_commit => FND_API.G_FALSE,

3721:
3722: PSB_POSITIONS_PVT.Modify_Assignment(
3723: p_api_version => 1.0,
3724: p_init_msg_list => FND_API.G_FALSE,
3725: p_commit => FND_API.G_FALSE,
3726: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3727: p_return_status => l_return_status,
3728: p_msg_count => l_msg_count,
3729: p_msg_data => l_msg_data,

Line 3726: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3722: PSB_POSITIONS_PVT.Modify_Assignment(
3723: p_api_version => 1.0,
3724: p_init_msg_list => FND_API.G_FALSE,
3725: p_commit => FND_API.G_FALSE,
3726: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3727: p_return_status => l_return_status,
3728: p_msg_count => l_msg_count,
3729: p_msg_data => l_msg_data,
3730: p_position_assignment_id => l_position_assignment_id,

Line 3754: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3750: p_modify_flag => null,
3751: p_rowid => l_rowid
3752: );
3753: --debug('new asgn id'||l_position_assignment_id);
3754: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3755: raise FND_API.G_EXC_ERROR;
3756: end if;
3757:
3758: --debug('l_element_value_type'||l_element_value_type);

Line 3755: raise FND_API.G_EXC_ERROR;

3751: p_rowid => l_rowid
3752: );
3753: --debug('new asgn id'||l_position_assignment_id);
3754: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3755: raise FND_API.G_EXC_ERROR;
3756: end if;
3757:
3758: --debug('l_element_value_type'||l_element_value_type);
3759: END IF;

Line 3763: p_return_status := FND_API.G_RET_STS_SUCCESS;

3759: END IF;
3760: end loop; -- For each Budget Period in the input PL/SQL table
3761:
3762:
3763: p_return_status := FND_API.G_RET_STS_SUCCESS;
3764: EXCEPTION
3765:
3766: when FND_API.G_EXC_ERROR then
3767: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3766: when FND_API.G_EXC_ERROR then

3762:
3763: p_return_status := FND_API.G_RET_STS_SUCCESS;
3764: EXCEPTION
3765:
3766: when FND_API.G_EXC_ERROR then
3767: p_return_status := FND_API.G_RET_STS_ERROR;
3768:
3769: when FND_API.G_EXC_UNEXPECTED_ERROR then
3770: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3767: p_return_status := FND_API.G_RET_STS_ERROR;

3763: p_return_status := FND_API.G_RET_STS_SUCCESS;
3764: EXCEPTION
3765:
3766: when FND_API.G_EXC_ERROR then
3767: p_return_status := FND_API.G_RET_STS_ERROR;
3768:
3769: when FND_API.G_EXC_UNEXPECTED_ERROR then
3770: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3771:

Line 3769: when FND_API.G_EXC_UNEXPECTED_ERROR then

3765:
3766: when FND_API.G_EXC_ERROR then
3767: p_return_status := FND_API.G_RET_STS_ERROR;
3768:
3769: when FND_API.G_EXC_UNEXPECTED_ERROR then
3770: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3771:
3772: when OTHERS then
3773: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3770: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3766: when FND_API.G_EXC_ERROR then
3767: p_return_status := FND_API.G_RET_STS_ERROR;
3768:
3769: when FND_API.G_EXC_UNEXPECTED_ERROR then
3770: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3771:
3772: when OTHERS then
3773: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3774:

Line 3773: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3769: when FND_API.G_EXC_UNEXPECTED_ERROR then
3770: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3771:
3772: when OTHERS then
3773: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3774:
3775: END Change_Pos_Year_Assignments;
3776:
3777: