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.PQH_WKS_ERROR_CHK dependencies on FND_MESSAGE

Line 214: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ID');

210: -- main check for input action cd in D or R
211: IF NVL(l_pqh_worksheet_details_rec.action_cd,'R') NOT IN ('D', 'R') THEN
212:
213: -- get message text for PQH_WKS_INVALID_ID
214: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ID');
215: l_message_text_out := FND_MESSAGE.GET;
216:
217: l_message_text := l_message_text_out;
218:

Line 215: l_message_text_out := FND_MESSAGE.GET;

211: IF NVL(l_pqh_worksheet_details_rec.action_cd,'R') NOT IN ('D', 'R') THEN
212:
213: -- get message text for PQH_WKS_INVALID_ID
214: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ID');
215: l_message_text_out := FND_MESSAGE.GET;
216:
217: l_message_text := l_message_text_out;
218:
219: /*

Line 587: FND_MESSAGE.SET_NAME('PQH','PQH_INV_WKS_DTL_ID');

583: -- no worksheet record would be fetched . So abort
584:
585: IF g_worksheet_id IS NULL THEN
586: -- get the message text PQH_INV_WKS_DTL_ID
587: FND_MESSAGE.SET_NAME('PQH','PQH_INV_WKS_DTL_ID');
588: APP_EXCEPTION.RAISE_EXCEPTION;
589: END IF;
590:
591: -- get table_route_id for all the six worksheet tables

Line 776: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_DEL_CHANGES');

772: -- get message text for PQH_WKS_DEL_CHANGES
773: -- Changes in the delegated organization ORG_NAME have not been applied
774:
775: -- get message text for PQH_WKS_DEL_CHANGES
776: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_DEL_CHANGES');
777: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_log_context);
778: l_message_text_out := FND_MESSAGE.GET;
779:
780: l_message_text := l_message_text_out;

Line 777: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_log_context);

773: -- Changes in the delegated organization ORG_NAME have not been applied
774:
775: -- get message text for PQH_WKS_DEL_CHANGES
776: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_DEL_CHANGES');
777: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_log_context);
778: l_message_text_out := FND_MESSAGE.GET;
779:
780: l_message_text := l_message_text_out;
781:

Line 778: l_message_text_out := FND_MESSAGE.GET;

774:
775: -- get message text for PQH_WKS_DEL_CHANGES
776: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_DEL_CHANGES');
777: FND_MESSAGE.SET_TOKEN('ORG_NAME',l_log_context);
778: l_message_text_out := FND_MESSAGE.GET;
779:
780: l_message_text := l_message_text_out;
781:
782: -- set l_error_flag to Y

Line 926: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ACTION_CD');

922: IF NVL(l_worksheet_details_rec.action_cd , 'R') NOT IN ( 'R','D','B' ) THEN
923:
924: -- get message text for PQH_WKS_INVALID_ACTION_CD
925: -- message : Worksheet has invalid Action Code ACTION_CD
926: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ACTION_CD');
927: FND_MESSAGE.SET_TOKEN('ACTION_CD',l_worksheet_details_rec.action_cd);
928: l_message_text_out := FND_MESSAGE.GET;
929:
930:

Line 927: FND_MESSAGE.SET_TOKEN('ACTION_CD',l_worksheet_details_rec.action_cd);

923:
924: -- get message text for PQH_WKS_INVALID_ACTION_CD
925: -- message : Worksheet has invalid Action Code ACTION_CD
926: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ACTION_CD');
927: FND_MESSAGE.SET_TOKEN('ACTION_CD',l_worksheet_details_rec.action_cd);
928: l_message_text_out := FND_MESSAGE.GET;
929:
930:
931: l_message_text := l_message_text_out;

Line 928: l_message_text_out := FND_MESSAGE.GET;

924: -- get message text for PQH_WKS_INVALID_ACTION_CD
925: -- message : Worksheet has invalid Action Code ACTION_CD
926: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ACTION_CD');
927: FND_MESSAGE.SET_TOKEN('ACTION_CD',l_worksheet_details_rec.action_cd);
928: l_message_text_out := FND_MESSAGE.GET;
929:
930:
931: l_message_text := l_message_text_out;
932:

Line 961: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BDG_AMT');

957: -- there is already an error so append the message
958:
959: -- get message text for PQH_WKS_INVALID_BDG_AMT
960: -- message : Worksheet Budgeted Amount Must be more then zero
961: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BDG_AMT');
962: l_message_text_out := FND_MESSAGE.GET;
963:
964: l_message_text := l_message_text||' **** '||l_message_text_out;
965: ELSE

Line 962: l_message_text_out := FND_MESSAGE.GET;

958:
959: -- get message text for PQH_WKS_INVALID_BDG_AMT
960: -- message : Worksheet Budgeted Amount Must be more then zero
961: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BDG_AMT');
962: l_message_text_out := FND_MESSAGE.GET;
963:
964: l_message_text := l_message_text||' **** '||l_message_text_out;
965: ELSE
966: -- new message

Line 985: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BDG_AMT');

981: -- there is already an error so append the message
982:
983: -- get message text for PQH_WKS_INVALID_BDG_AMT
984: -- message : Worksheet Budgeted Amount Must be more then zero
985: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BDG_AMT');
986: l_message_text_out := FND_MESSAGE.GET;
987:
988: l_message_text := l_message_text||' **** '||l_message_text_out;
989: ELSE

Line 986: l_message_text_out := FND_MESSAGE.GET;

982:
983: -- get message text for PQH_WKS_INVALID_BDG_AMT
984: -- message : Worksheet Budgeted Amount Must be more then zero
985: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BDG_AMT');
986: l_message_text_out := FND_MESSAGE.GET;
987:
988: l_message_text := l_message_text||' **** '||l_message_text_out;
989: ELSE
990: -- new message

Line 1008: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BDG_AMT');

1004: -- there is already an error so append the message
1005:
1006: -- get message text for PQH_WKS_INVALID_BDG_AMT
1007: -- message : Worksheet Budgeted Amount Must be more then zero
1008: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BDG_AMT');
1009: l_message_text_out := FND_MESSAGE.GET;
1010:
1011: l_message_text := l_message_text||' **** '||l_message_text_out;
1012: ELSE

Line 1009: l_message_text_out := FND_MESSAGE.GET;

1005:
1006: -- get message text for PQH_WKS_INVALID_BDG_AMT
1007: -- message : Worksheet Budgeted Amount Must be more then zero
1008: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BDG_AMT');
1009: l_message_text_out := FND_MESSAGE.GET;
1010:
1011: l_message_text := l_message_text||' **** '||l_message_text_out;
1012: ELSE
1013: -- new message

Line 1045: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_PERIODS');

1041: hr_utility.set_location('WKS Detail Error 3 PQH_WKS_NO_PERIODS '||l_worksheet_details_rec.worksheet_detail_id,10);
1042:
1043: -- get message text for PQH_WKS_NO_PERIODS
1044: -- message : No Periods Defined for the budgeted entity
1045: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_PERIODS');
1046: l_message_text_out := FND_MESSAGE.GET;
1047:
1048: IF l_error_flag = 'Y' THEN
1049: -- there is already an error so append the message

Line 1046: l_message_text_out := FND_MESSAGE.GET;

1042:
1043: -- get message text for PQH_WKS_NO_PERIODS
1044: -- message : No Periods Defined for the budgeted entity
1045: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_PERIODS');
1046: l_message_text_out := FND_MESSAGE.GET;
1047:
1048: IF l_error_flag = 'Y' THEN
1049: -- there is already an error so append the message
1050:

Line 1069: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_WRONG_POSITION');

1065: FETCH csr_pos_availability into l_availability_status_id;
1066: CLOSE csr_pos_availability;
1067:
1068: IF pqh_wks_budget.get_position_budget_flag(l_availability_status_id) = 'N' THEN
1069: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_WRONG_POSITION');
1070: FND_MESSAGE.SET_TOKEN('STATUS',HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_availability_status_id));
1071:
1072: l_message_text_out := FND_MESSAGE.GET;
1073:

Line 1070: FND_MESSAGE.SET_TOKEN('STATUS',HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_availability_status_id));

1066: CLOSE csr_pos_availability;
1067:
1068: IF pqh_wks_budget.get_position_budget_flag(l_availability_status_id) = 'N' THEN
1069: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_WRONG_POSITION');
1070: FND_MESSAGE.SET_TOKEN('STATUS',HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_availability_status_id));
1071:
1072: l_message_text_out := FND_MESSAGE.GET;
1073:
1074: IF l_error_flag = 'Y' THEN

Line 1072: l_message_text_out := FND_MESSAGE.GET;

1068: IF pqh_wks_budget.get_position_budget_flag(l_availability_status_id) = 'N' THEN
1069: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_WRONG_POSITION');
1070: FND_MESSAGE.SET_TOKEN('STATUS',HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_availability_status_id));
1071:
1072: l_message_text_out := FND_MESSAGE.GET;
1073:
1074: IF l_error_flag = 'Y' THEN
1075: -- there is already an error so append the message
1076:

Line 1107: FND_MESSAGE.SET_NAME('PQH','PQH_PC_POSN_INVALID');

1103: IF l_pc_posn_status = 'ERROR' THEN
1104: hr_utility.set_location('WKS Detail Error 3.1 PQH_PC_POSN_INVALID '||l_worksheet_details_rec.position_id,11);
1105: -- get message text for PQH_PC_POSN_INVALID
1106: -- message : Position is already budgeted in another budget for the same Fiscal period
1107: FND_MESSAGE.SET_NAME('PQH','PQH_PC_POSN_INVALID');
1108: l_message_text_out := FND_MESSAGE.GET;
1109:
1110: IF l_error_flag = 'Y' THEN
1111: -- there is already an error so append the message

Line 1108: l_message_text_out := FND_MESSAGE.GET;

1104: hr_utility.set_location('WKS Detail Error 3.1 PQH_PC_POSN_INVALID '||l_worksheet_details_rec.position_id,11);
1105: -- get message text for PQH_PC_POSN_INVALID
1106: -- message : Position is already budgeted in another budget for the same Fiscal period
1107: FND_MESSAGE.SET_NAME('PQH','PQH_PC_POSN_INVALID');
1108: l_message_text_out := FND_MESSAGE.GET;
1109:
1110: IF l_error_flag = 'Y' THEN
1111: -- there is already an error so append the message
1112:

Line 1139: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_DEL_ALL_AMT');

1135: hr_utility.set_location('WKS Detail Error 4 PQH_WKS_DEL_ALL_AMT '||l_worksheet_details_rec.worksheet_detail_id,10);
1136:
1137: -- get message text for PQH_WKS_DEL_ALL_AMT
1138: -- message : Budget Amount in the delegated organization exceeds the allocated amount
1139: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_DEL_ALL_AMT');
1140: l_message_text_out := FND_MESSAGE.GET;
1141:
1142: IF l_error_flag = 'Y' THEN
1143: -- there is already an error so append the message

Line 1140: l_message_text_out := FND_MESSAGE.GET;

1136:
1137: -- get message text for PQH_WKS_DEL_ALL_AMT
1138: -- message : Budget Amount in the delegated organization exceeds the allocated amount
1139: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_DEL_ALL_AMT');
1140: l_message_text_out := FND_MESSAGE.GET;
1141:
1142: IF l_error_flag = 'Y' THEN
1143: -- there is already an error so append the message
1144:

Line 1168: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_POSITION');

1164: hr_utility.set_location('WKS Detail Error 5 PQH_WKS_NO_POSITION '||l_worksheet_details_rec.worksheet_detail_id,10);
1165:
1166: -- get message text for PQH_WKS_NO_POSITION
1167: -- message : Position is not created for this position transaction
1168: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_POSITION');
1169: l_message_text_out := FND_MESSAGE.GET;
1170:
1171: IF l_error_flag = 'Y' THEN
1172: -- there is already an error so append the message

Line 1169: l_message_text_out := FND_MESSAGE.GET;

1165:
1166: -- get message text for PQH_WKS_NO_POSITION
1167: -- message : Position is not created for this position transaction
1168: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_POSITION');
1169: l_message_text_out := FND_MESSAGE.GET;
1170:
1171: IF l_error_flag = 'Y' THEN
1172: -- there is already an error so append the message
1173:

Line 1277: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_BSETS');

1273:
1274: IF NVL(l_count,0) = 0 THEN
1275: -- get message text for PQH_WKS_NO_BSETS
1276: -- message : No budget Sets have been defined for the budgeted period.
1277: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_BSETS');
1278: l_message_text_out := FND_MESSAGE.GET;
1279:
1280: l_message_text := l_message_text_out;
1281:

Line 1278: l_message_text_out := FND_MESSAGE.GET;

1274: IF NVL(l_count,0) = 0 THEN
1275: -- get message text for PQH_WKS_NO_BSETS
1276: -- message : No budget Sets have been defined for the budgeted period.
1277: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_BSETS');
1278: l_message_text_out := FND_MESSAGE.GET;
1279:
1280: l_message_text := l_message_text_out;
1281:
1282: -- set l_error_flag to Y

Line 1299: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_PERIOD_VAL');

1295: ( NVL(l_worksheet_periods_rec.budget_unit3_value,0) < 0 ) THEN
1296:
1297: -- get message text for PQH_WKS_INVALID_PERIOD_VAL
1298: -- message : Budget Period Values must be more then zero
1299: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_PERIOD_VAL');
1300: l_message_text_out := FND_MESSAGE.GET;
1301:
1302: l_message_text := l_message_text_out;
1303:

Line 1300: l_message_text_out := FND_MESSAGE.GET;

1296:
1297: -- get message text for PQH_WKS_INVALID_PERIOD_VAL
1298: -- message : Budget Period Values must be more then zero
1299: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_PERIOD_VAL');
1300: l_message_text_out := FND_MESSAGE.GET;
1301:
1302: l_message_text := l_message_text_out;
1303:
1304: -- set l_error_flag to Y

Line 1362: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_PERIOD_AMT');

1358: /* -- added configurable rule on 10/13/2000
1359:
1360: -- get message text for PQH_WKS_INVALID_PERIOD_AMT
1361: -- message : Budget Period Amount exceeds the allocated amount
1362: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_PERIOD_AMT');
1363: l_message_text_out := FND_MESSAGE.GET;
1364:
1365: IF l_error_flag = 'Y' THEN
1366: -- there is already an error so append the message

Line 1363: l_message_text_out := FND_MESSAGE.GET;

1359:
1360: -- get message text for PQH_WKS_INVALID_PERIOD_AMT
1361: -- message : Budget Period Amount exceeds the allocated amount
1362: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_PERIOD_AMT');
1363: l_message_text_out := FND_MESSAGE.GET;
1364:
1365: IF l_error_flag = 'Y' THEN
1366: -- there is already an error so append the message
1367:

Line 1520: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BSET_VAL');

1516:
1517: /*
1518: -- get message text for PQH_WKS_INVALID_BSET_VAL
1519: -- message : Sum of Budget Sets value for a period must be more then zero
1520: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BSET_VAL');
1521: l_message_text_out := FND_MESSAGE.GET;
1522:
1523: l_message_text := l_message_text_out;
1524:

Line 1521: l_message_text_out := FND_MESSAGE.GET;

1517: /*
1518: -- get message text for PQH_WKS_INVALID_BSET_VAL
1519: -- message : Sum of Budget Sets value for a period must be more then zero
1520: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BSET_VAL');
1521: l_message_text_out := FND_MESSAGE.GET;
1522:
1523: l_message_text := l_message_text_out;
1524:
1525: -- insert error message

Line 1581: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BSET_VAL');

1577:
1578: /*
1579: -- get message text for PQH_WKS_INVALID_BSET_VAL
1580: -- message : Sum of Budget Sets value for a period must be more then zero
1581: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BSET_VAL');
1582: l_message_text_out := FND_MESSAGE.GET;
1583:
1584: l_message_text := l_message_text_out;
1585:

Line 1582: l_message_text_out := FND_MESSAGE.GET;

1578: /*
1579: -- get message text for PQH_WKS_INVALID_BSET_VAL
1580: -- message : Sum of Budget Sets value for a period must be more then zero
1581: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BSET_VAL');
1582: l_message_text_out := FND_MESSAGE.GET;
1583:
1584: l_message_text := l_message_text_out;
1585:
1586: -- insert error message

Line 1642: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BSET_VAL');

1638:
1639: /*
1640: -- get message text for PQH_WKS_INVALID_BSET_VAL
1641: -- message : Sum of Budget Sets value for a period must be more then zero
1642: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BSET_VAL');
1643: l_message_text_out := FND_MESSAGE.GET;
1644:
1645: l_message_text := l_message_text_out;
1646:

Line 1643: l_message_text_out := FND_MESSAGE.GET;

1639: /*
1640: -- get message text for PQH_WKS_INVALID_BSET_VAL
1641: -- message : Sum of Budget Sets value for a period must be more then zero
1642: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_BSET_VAL');
1643: l_message_text_out := FND_MESSAGE.GET;
1644:
1645: l_message_text := l_message_text_out;
1646:
1647: -- insert error message

Line 1770: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ELMNT_SUM');

1766: /*
1767:
1768: -- get message text for PQH_WKS_INVALID_ELMNT_SUM
1769: -- message : For Budget elements total of percentage under a budget set cannot exceed 100
1770: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ELMNT_SUM');
1771: l_message_text_out := FND_MESSAGE.GET;
1772:
1773: l_message_text := l_message_text_out;
1774:

Line 1771: l_message_text_out := FND_MESSAGE.GET;

1767:
1768: -- get message text for PQH_WKS_INVALID_ELMNT_SUM
1769: -- message : For Budget elements total of percentage under a budget set cannot exceed 100
1770: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ELMNT_SUM');
1771: l_message_text_out := FND_MESSAGE.GET;
1772:
1773: l_message_text := l_message_text_out;
1774:
1775: -- set l_error_flag to Y

Line 1818: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_LESS_ELMNT_SUM');

1814:
1815: /*
1816: -- get message text for PQH_WKS_LESS_ELMNT_SUM
1817: -- message : Warning : For Budget elements total of percentage under budget set is less then 100
1818: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_LESS_ELMNT_SUM');
1819: l_message_text_out := FND_MESSAGE.GET;
1820:
1821: l_message_text := l_message_text_out;
1822:

Line 1819: l_message_text_out := FND_MESSAGE.GET;

1815: /*
1816: -- get message text for PQH_WKS_LESS_ELMNT_SUM
1817: -- message : Warning : For Budget elements total of percentage under budget set is less then 100
1818: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_LESS_ELMNT_SUM');
1819: l_message_text_out := FND_MESSAGE.GET;
1820:
1821: l_message_text := l_message_text_out;
1822:
1823: -- set l_error_flag to Y

Line 1852: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ELMNT_PERCENT');

1848: -- there is already an error so append the message
1849:
1850: -- get message text for PQH_WKS_INVALID_ELMNT_PERCENT
1851: -- message : For Budget elements percentage cannot be less then 0
1852: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ELMNT_PERCENT');
1853: l_message_text_out := FND_MESSAGE.GET;
1854:
1855: l_message_text := l_message_text||' **** '||l_message_text_out;
1856: ELSE

Line 1853: l_message_text_out := FND_MESSAGE.GET;

1849:
1850: -- get message text for PQH_WKS_INVALID_ELMNT_PERCENT
1851: -- message : For Budget elements percentage cannot be less then 0
1852: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_ELMNT_PERCENT');
1853: l_message_text_out := FND_MESSAGE.GET;
1854:
1855: l_message_text := l_message_text||' **** '||l_message_text_out;
1856: ELSE
1857: -- new message

Line 2027: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_SRC_MANDATORY');

2023: l_worksheet_fund_srcs_rec.expenditure_type is null or
2024: l_worksheet_fund_srcs_rec.organization_id is null then
2025: -- one of the PATEO column is missing, raise an error
2026: l_error_flag := 'Y';
2027: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_SRC_MANDATORY');
2028: l_message_text_out := FND_MESSAGE.GET;
2029: l_message_text := l_message_text||' **** '||l_message_text_out;
2030: end if;
2031: else

Line 2028: l_message_text_out := FND_MESSAGE.GET;

2024: l_worksheet_fund_srcs_rec.organization_id is null then
2025: -- one of the PATEO column is missing, raise an error
2026: l_error_flag := 'Y';
2027: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_SRC_MANDATORY');
2028: l_message_text_out := FND_MESSAGE.GET;
2029: l_message_text := l_message_text||' **** '||l_message_text_out;
2030: end if;
2031: else
2032: -- ALL PATEO columns should be null as cost allocation is present

Line 2040: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_SRC_GL_GMS');

2036: l_worksheet_fund_srcs_rec.expenditure_type is not null and
2037: l_worksheet_fund_srcs_rec.organization_id is not null then
2038: -- some of the PATEO column is present alongwith cost allocation, raise an error
2039: l_error_flag := 'Y';
2040: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_SRC_GL_GMS');
2041: l_message_text_out := FND_MESSAGE.GET;
2042: l_message_text := l_message_text||' **** '||l_message_text_out;
2043: end if;
2044: end if;

Line 2041: l_message_text_out := FND_MESSAGE.GET;

2037: l_worksheet_fund_srcs_rec.organization_id is not null then
2038: -- some of the PATEO column is present alongwith cost allocation, raise an error
2039: l_error_flag := 'Y';
2040: FND_MESSAGE.SET_NAME('PQH','PQH_BUDGET_SRC_GL_GMS');
2041: l_message_text_out := FND_MESSAGE.GET;
2042: l_message_text := l_message_text||' **** '||l_message_text_out;
2043: end if;
2044: end if;
2045: /*

Line 2056: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_SRC_PERCENT');

2052: -- there is already an error so append the message
2053:
2054: -- get message text for PQH_WKS_INVALID_SRC_PERCENT
2055: -- message : For Budget funding source percentage cannot be less then 0
2056: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_SRC_PERCENT');
2057: l_message_text_out := FND_MESSAGE.GET;
2058:
2059: l_message_text := l_message_text||' **** '||l_message_text_out;
2060: ELSE

Line 2057: l_message_text_out := FND_MESSAGE.GET;

2053:
2054: -- get message text for PQH_WKS_INVALID_SRC_PERCENT
2055: -- message : For Budget funding source percentage cannot be less then 0
2056: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_INVALID_SRC_PERCENT');
2057: l_message_text_out := FND_MESSAGE.GET;
2058:
2059: l_message_text := l_message_text||' **** '||l_message_text_out;
2060: ELSE
2061: -- new message

Line 2625: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_PERIODS');

2621: hr_utility.set_location('WKS Detail Error 3 PQH_WKS_NO_PERIODS '||l_worksheet_details_rec.worksheet_detail_id,10);
2622:
2623: -- get message text for PQH_WKS_NO_PERIODS
2624: -- message : No Periods Defined for the budgeted entity
2625: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_PERIODS');
2626: l_message_text_out := FND_MESSAGE.GET;
2627:
2628: IF l_error_flag = 'Y' THEN
2629: -- there is already an error so append the message

Line 2626: l_message_text_out := FND_MESSAGE.GET;

2622:
2623: -- get message text for PQH_WKS_NO_PERIODS
2624: -- message : No Periods Defined for the budgeted entity
2625: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_PERIODS');
2626: l_message_text_out := FND_MESSAGE.GET;
2627:
2628: IF l_error_flag = 'Y' THEN
2629: -- there is already an error so append the message
2630:

Line 2654: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_DEL_ALL_AMT');

2650: hr_utility.set_location('WKS Detail Error 4 PQH_WKS_DEL_ALL_AMT '||l_worksheet_details_rec.worksheet_detail_id,10);
2651:
2652: -- get message text for PQH_WKS_DEL_ALL_AMT
2653: -- message : Budget Amount in the delegated organization exceeds the allocated amount
2654: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_DEL_ALL_AMT');
2655: l_message_text_out := FND_MESSAGE.GET;
2656:
2657: IF l_error_flag = 'Y' THEN
2658: -- there is already an error so append the message

Line 2655: l_message_text_out := FND_MESSAGE.GET;

2651:
2652: -- get message text for PQH_WKS_DEL_ALL_AMT
2653: -- message : Budget Amount in the delegated organization exceeds the allocated amount
2654: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_DEL_ALL_AMT');
2655: l_message_text_out := FND_MESSAGE.GET;
2656:
2657: IF l_error_flag = 'Y' THEN
2658: -- there is already an error so append the message
2659:

Line 2682: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_BDT_RECS');

2678: IF NVL(l_budget_count,0) = 0 THEN
2679:
2680: -- get message text for PQH_WKS_NO_BDT_RECS
2681: -- message : There must be atleast one Budgeted entity
2682: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_BDT_RECS');
2683: l_message_text_out := FND_MESSAGE.GET;
2684:
2685: IF l_error_flag = 'Y' THEN
2686: -- there is already an error so append the message

Line 2683: l_message_text_out := FND_MESSAGE.GET;

2679:
2680: -- get message text for PQH_WKS_NO_BDT_RECS
2681: -- message : There must be atleast one Budgeted entity
2682: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_BDT_RECS');
2683: l_message_text_out := FND_MESSAGE.GET;
2684:
2685: IF l_error_flag = 'Y' THEN
2686: -- there is already an error so append the message
2687:

Line 2825: message_text = fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED'),

2821: IF l_pqh_process_log_rec.message_type_cd <> 'ERROR'THEN
2822: -- no errors in the batch
2823: UPDATE pqh_process_log
2824: SET message_type_cd = 'COMPLETE',
2825: message_text = fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED'),
2826: txn_table_route_id = g_table_route_id_wdt,
2827: batch_status = l_status,
2828: batch_end_date = sysdate
2829: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

Line 2977: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_VALID_DATES');

2973: );
2974:
2975: IF NVL(l_status,'ERROR') = 'ERROR' THEN
2976: -- get message text for PQH_WKS_VALID_DATES
2977: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_VALID_DATES');
2978: FND_MESSAGE.SET_TOKEN('LL',l_wks_ll_date);
2979: FND_MESSAGE.SET_TOKEN('UL',l_wks_ul_date);
2980: l_message_text_out := FND_MESSAGE.GET;
2981: p_message := l_message_text_out;

Line 2978: FND_MESSAGE.SET_TOKEN('LL',l_wks_ll_date);

2974:
2975: IF NVL(l_status,'ERROR') = 'ERROR' THEN
2976: -- get message text for PQH_WKS_VALID_DATES
2977: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_VALID_DATES');
2978: FND_MESSAGE.SET_TOKEN('LL',l_wks_ll_date);
2979: FND_MESSAGE.SET_TOKEN('UL',l_wks_ul_date);
2980: l_message_text_out := FND_MESSAGE.GET;
2981: p_message := l_message_text_out;
2982:

Line 2979: FND_MESSAGE.SET_TOKEN('UL',l_wks_ul_date);

2975: IF NVL(l_status,'ERROR') = 'ERROR' THEN
2976: -- get message text for PQH_WKS_VALID_DATES
2977: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_VALID_DATES');
2978: FND_MESSAGE.SET_TOKEN('LL',l_wks_ll_date);
2979: FND_MESSAGE.SET_TOKEN('UL',l_wks_ul_date);
2980: l_message_text_out := FND_MESSAGE.GET;
2981: p_message := l_message_text_out;
2982:
2983: p_status := 'ERROR';

Line 2980: l_message_text_out := FND_MESSAGE.GET;

2976: -- get message text for PQH_WKS_VALID_DATES
2977: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_VALID_DATES');
2978: FND_MESSAGE.SET_TOKEN('LL',l_wks_ll_date);
2979: FND_MESSAGE.SET_TOKEN('UL',l_wks_ul_date);
2980: l_message_text_out := FND_MESSAGE.GET;
2981: p_message := l_message_text_out;
2982:
2983: p_status := 'ERROR';
2984: