DBA Data[Home] [Help]

APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_UTILS

Line 537: PA_UTILS.ADD_MESSAGE

533: AND po.project_id = p_project_id;
534:
535: EXCEPTION
536: WHEN NO_DATA_FOUND THEN
537: PA_UTILS.ADD_MESSAGE
538: ( p_app_short_name => 'PA',
539: p_msg_name => 'PA_FP_CI_NO_VERSION_DATA_FOUND');
540: ----DBMS_OUTPUT.PUT_LINE('FP_CI_GET_VERSION_DETAILS - 2***');
541: x_return_status := FND_API.G_RET_STS_ERROR;

Line 787: -- Add message in PA_UTILS

783: IF (l_t_time_phased_code = 'G') THEN ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - **8');
784: ----DBMS_OUTPUT.PUT_LINE('Time phased Code is Different');
785: --MERGE NOT POSSIBLE
786: l_merge_possible_code := 'E';
787: -- Add message in PA_UTILS
788: PA_UTILS.ADD_MESSAGE
789: ( p_app_short_name => 'PA',
790: p_msg_name => 'PA_FP_CI_C_TIME_PHASE_DIFF'
791: );

Line 788: PA_UTILS.ADD_MESSAGE

784: ----DBMS_OUTPUT.PUT_LINE('Time phased Code is Different');
785: --MERGE NOT POSSIBLE
786: l_merge_possible_code := 'E';
787: -- Add message in PA_UTILS
788: PA_UTILS.ADD_MESSAGE
789: ( p_app_short_name => 'PA',
790: p_msg_name => 'PA_FP_CI_C_TIME_PHASE_DIFF'
791: );
792: /*p_token1 => 'CI_SOURCE',

Line 809: -- Add message in PA_UTILS

805: --Check for the Target to be the same
806: IF (l_t_time_phased_code = 'P') THEN
807: -- MERGE NOT POSSIBLE
808: l_merge_possible_code := 'E';
809: -- Add message in PA_UTILS
810: PA_UTILS.ADD_MESSAGE
811: ( p_app_short_name => 'PA',
812: p_msg_name => 'PA_FP_CI_C_TIME_PHASE_DIFF'
813: );

Line 810: PA_UTILS.ADD_MESSAGE

806: IF (l_t_time_phased_code = 'P') THEN
807: -- MERGE NOT POSSIBLE
808: l_merge_possible_code := 'E';
809: -- Add message in PA_UTILS
810: PA_UTILS.ADD_MESSAGE
811: ( p_app_short_name => 'PA',
812: p_msg_name => 'PA_FP_CI_C_TIME_PHASE_DIFF'
813: );
814: /*p_token1 => 'CI_SOURCE',

Line 842: -- Add message in PA_UTILS

838: ) THEN
839: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 25');
840: -- MERGE NOT POSSIBLE
841: l_merge_possible_code := 'E';
842: -- Add message in PA_UTILS
843: PA_UTILS.ADD_MESSAGE
844: ( p_app_short_name => 'PA',
845: p_msg_name => 'PA_FP_CI_C_INV_VER_TYPE_MATCH'
846: );

Line 843: PA_UTILS.ADD_MESSAGE

839: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 25');
840: -- MERGE NOT POSSIBLE
841: l_merge_possible_code := 'E';
842: -- Add message in PA_UTILS
843: PA_UTILS.ADD_MESSAGE
844: ( p_app_short_name => 'PA',
845: p_msg_name => 'PA_FP_CI_C_INV_VER_TYPE_MATCH'
846: );
847: /*p_token1 => 'CI_SOURCE',

Line 865: -- Add message in PA_UTILS

861: IF (l_t_fin_plan_pref_code = 'REVENUE_ONLY') THEN
862: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 16****');
863: -- MERGE NOT POSSIBLE
864: l_merge_possible_code := 'E';
865: -- Add message in PA_UTILS
866: PA_UTILS.ADD_MESSAGE
867: ( p_app_short_name => 'PA',
868: p_msg_name => 'PA_FP_CI_C_INV_PREF_CODE_MATCH'
869: );

Line 866: PA_UTILS.ADD_MESSAGE

862: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 16****');
863: -- MERGE NOT POSSIBLE
864: l_merge_possible_code := 'E';
865: -- Add message in PA_UTILS
866: PA_UTILS.ADD_MESSAGE
867: ( p_app_short_name => 'PA',
868: p_msg_name => 'PA_FP_CI_C_INV_PREF_CODE_MATCH'
869: );
870: /*p_token1 => 'CI_SOURCE',

Line 888: -- Add message in PA_UTILS

884: IF (l_t_fin_plan_pref_code = 'COST_ONLY') THEN
885: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 18');
886: -- MERGE NOT POSSIBLE
887: l_merge_possible_code := 'E';
888: -- Add message in PA_UTILS
889: PA_UTILS.ADD_MESSAGE
890: ( p_app_short_name => 'PA',
891: p_msg_name => 'PA_FP_CI_C_INV_PREF_CODE_MATCH'
892: );

Line 889: PA_UTILS.ADD_MESSAGE

885: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 18');
886: -- MERGE NOT POSSIBLE
887: l_merge_possible_code := 'E';
888: -- Add message in PA_UTILS
889: PA_UTILS.ADD_MESSAGE
890: ( p_app_short_name => 'PA',
891: p_msg_name => 'PA_FP_CI_C_INV_PREF_CODE_MATCH'
892: );
893: /*p_token1 => 'CI_SOURCE',

Line 915: -- Add message in PA_UTILS

911: IF (l_t_version_type = 'COST') THEN
912: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 21***');
913: -- MERGE NOT POSSIBLE
914: l_merge_possible_code := 'E';
915: -- Add message in PA_UTILS
916: PA_UTILS.ADD_MESSAGE
917: ( p_app_short_name => 'PA',
918: p_msg_name => 'PA_FP_CI_C_INV_PREF_CODE_MATCH'
919: );

Line 916: PA_UTILS.ADD_MESSAGE

912: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 21***');
913: -- MERGE NOT POSSIBLE
914: l_merge_possible_code := 'E';
915: -- Add message in PA_UTILS
916: PA_UTILS.ADD_MESSAGE
917: ( p_app_short_name => 'PA',
918: p_msg_name => 'PA_FP_CI_C_INV_PREF_CODE_MATCH'
919: );
920: /*p_token1 => 'CI_SOURCE',

Line 936: -- Add message in PA_UTILS

932: IF (l_t_version_type = 'REVENUE') THEN
933: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 23***');
934: -- MERGE NOT POSSIBLE
935: l_merge_possible_code := 'E';
936: -- Add message in PA_UTILS
937: PA_UTILS.ADD_MESSAGE
938: ( p_app_short_name => 'PA',
939: p_msg_name => 'PA_FP_CI_C_INV_PREF_CODE_MATCH'
940: );

Line 937: PA_UTILS.ADD_MESSAGE

933: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 23***');
934: -- MERGE NOT POSSIBLE
935: l_merge_possible_code := 'E';
936: -- Add message in PA_UTILS
937: PA_UTILS.ADD_MESSAGE
938: ( p_app_short_name => 'PA',
939: p_msg_name => 'PA_FP_CI_C_INV_PREF_CODE_MATCH'
940: );
941: /*p_token1 => 'CI_SOURCE',

Line 967: -- Add message in PA_UTILS

963: ) THEN
964: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 25');
965: -- MERGE NOT POSSIBLE
966: l_merge_possible_code := 'E';
967: -- Add message in PA_UTILS
968: PA_UTILS.ADD_MESSAGE
969: ( p_app_short_name => 'PA',
970: p_msg_name => 'PA_FP_CI_C_INV_VER_TYPE_MATCH'
971: );

Line 968: PA_UTILS.ADD_MESSAGE

964: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 25');
965: -- MERGE NOT POSSIBLE
966: l_merge_possible_code := 'E';
967: -- Add message in PA_UTILS
968: PA_UTILS.ADD_MESSAGE
969: ( p_app_short_name => 'PA',
970: p_msg_name => 'PA_FP_CI_C_INV_VER_TYPE_MATCH'
971: );
972: /*p_token1 => 'CI_SOURCE',

Line 1016: -- Add message in PA_UTILS

1012:
1013: IF (l_s_agreement_id <> l_t_agreement_id) THEN
1014: --MERGE NOT POSSIBLE
1015: l_merge_possible_code := 'E';
1016: -- Add message in PA_UTILS
1017: PA_UTILS.ADD_MESSAGE
1018: ( p_app_short_name => 'PA',
1019: p_msg_name => 'PA_FP_CI_C_INV_AGR_ID_MATCH'
1020: );

Line 1017: PA_UTILS.ADD_MESSAGE

1013: IF (l_s_agreement_id <> l_t_agreement_id) THEN
1014: --MERGE NOT POSSIBLE
1015: l_merge_possible_code := 'E';
1016: -- Add message in PA_UTILS
1017: PA_UTILS.ADD_MESSAGE
1018: ( p_app_short_name => 'PA',
1019: p_msg_name => 'PA_FP_CI_C_INV_AGR_ID_MATCH'
1020: );
1021: -- RAISE EXCEPTION RAISE_MERGE_ERROR

Line 1088: PA_UTILS.ADD_MESSAGE

1084: l_count := 0;
1085: /* dummy stmt */
1086: end;
1087:
1088: PA_UTILS.ADD_MESSAGE
1089: ( p_app_short_name => 'PA',
1090: p_msg_name => 'PA_FP_CI_NO_COPY',
1091: p_token1 => 'CI_ID',
1092: p_value1 => l_chg_doc_token,

Line 1109: -- Add message in PA_UTILS

1105: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - **8');
1106: ----DBMS_OUTPUT.PUT_LINE('Time phased Code is Different');
1107: --MERGE NOT POSSIBLE
1108: l_merge_possible_code := 'E';
1109: -- Add message in PA_UTILS
1110: IF (p_calling_mode = 'INCLUDE') THEN
1111: PA_UTILS.ADD_MESSAGE
1112: ( p_app_short_name => 'PA',
1113: p_msg_name => 'PA_FP_CI_TIME_PHASE_DIFF',

Line 1111: PA_UTILS.ADD_MESSAGE

1107: --MERGE NOT POSSIBLE
1108: l_merge_possible_code := 'E';
1109: -- Add message in PA_UTILS
1110: IF (p_calling_mode = 'INCLUDE') THEN
1111: PA_UTILS.ADD_MESSAGE
1112: ( p_app_short_name => 'PA',
1113: p_msg_name => 'PA_FP_CI_TIME_PHASE_DIFF',
1114: p_token1 => 'CHG_DOC',
1115: p_value1 => l_src_ci_number

Line 1118: PA_UTILS.ADD_MESSAGE

1114: p_token1 => 'CHG_DOC',
1115: p_value1 => l_src_ci_number
1116: );
1117: ELSIF (p_calling_mode = 'IMPLEMENT') THEN
1118: PA_UTILS.ADD_MESSAGE
1119: ( p_app_short_name => 'PA',
1120: p_msg_name => 'PA_FP_CIM_TIME_PHASE_DIFF',
1121: p_token1 => 'PLAN_TYPE',
1122: p_value1 => l_targ_pt_name

Line 1126: PA_UTILS.ADD_MESSAGE

1122: p_value1 => l_targ_pt_name
1123:
1124: );
1125: ELSIF (p_calling_mode = 'SUBMIT') THEN
1126: PA_UTILS.ADD_MESSAGE
1127: ( p_app_short_name => 'PA',
1128: p_msg_name => 'PA_FP_CIS_TIME_PHASE_DIFF'
1129: );
1130:

Line 1149: -- Add message in PA_UTILS

1145: --Check for the Target to be the same
1146: IF (l_t_time_phased_code = 'P') THEN
1147: -- MERGE NOT POSSIBLE
1148: l_merge_possible_code := 'E';
1149: -- Add message in PA_UTILS
1150: IF (p_calling_mode = 'INCLUDE') THEN
1151: PA_UTILS.ADD_MESSAGE
1152: ( p_app_short_name => 'PA',
1153: p_msg_name => 'PA_FP_CI_TIME_PHASE_DIFF',

Line 1151: PA_UTILS.ADD_MESSAGE

1147: -- MERGE NOT POSSIBLE
1148: l_merge_possible_code := 'E';
1149: -- Add message in PA_UTILS
1150: IF (p_calling_mode = 'INCLUDE') THEN
1151: PA_UTILS.ADD_MESSAGE
1152: ( p_app_short_name => 'PA',
1153: p_msg_name => 'PA_FP_CI_TIME_PHASE_DIFF',
1154: p_token1 => 'CHG_DOC',
1155: p_value1 => l_src_ci_number

Line 1158: PA_UTILS.ADD_MESSAGE

1154: p_token1 => 'CHG_DOC',
1155: p_value1 => l_src_ci_number
1156: );
1157: ELSIF (p_calling_mode = 'IMPLEMENT') THEN
1158: PA_UTILS.ADD_MESSAGE
1159: ( p_app_short_name => 'PA',
1160: p_msg_name => 'PA_FP_CIM_TIME_PHASE_DIFF',
1161: p_token1 => 'PLAN_TYPE',
1162: p_value1 => l_targ_pt_name

Line 1166: PA_UTILS.ADD_MESSAGE

1162: p_value1 => l_targ_pt_name
1163:
1164: );
1165: ELSIF (p_calling_mode = 'SUBMIT') THEN
1166: PA_UTILS.ADD_MESSAGE
1167: ( p_app_short_name => 'PA',
1168: p_msg_name => 'PA_FP_CIS_TIME_PHASE_DIFF'
1169: );
1170:

Line 1201: -- Add message in PA_UTILS

1197: ) THEN
1198: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 25');
1199: -- MERGE NOT POSSIBLE
1200: l_merge_possible_code := 'E';
1201: -- Add message in PA_UTILS
1202: IF (p_calling_mode = 'INCLUDE') THEN
1203: PA_UTILS.ADD_MESSAGE
1204: ( p_app_short_name => 'PA',
1205: p_msg_name => 'PA_FP_CI_INV_VER_TYPE_MATCH',

Line 1203: PA_UTILS.ADD_MESSAGE

1199: -- MERGE NOT POSSIBLE
1200: l_merge_possible_code := 'E';
1201: -- Add message in PA_UTILS
1202: IF (p_calling_mode = 'INCLUDE') THEN
1203: PA_UTILS.ADD_MESSAGE
1204: ( p_app_short_name => 'PA',
1205: p_msg_name => 'PA_FP_CI_INV_VER_TYPE_MATCH',
1206: p_token1 => 'CHG_DOC',
1207: p_value1 => l_src_ci_number

Line 1210: PA_UTILS.ADD_MESSAGE

1206: p_token1 => 'CHG_DOC',
1207: p_value1 => l_src_ci_number
1208: );
1209: ELSIF (p_calling_mode = 'IMPLEMENT') THEN
1210: PA_UTILS.ADD_MESSAGE
1211: ( p_app_short_name => 'PA',
1212: p_msg_name => 'PA_FP_CIM_INV_VER_TYPE_MATCH',
1213: p_token1 => 'PLAN_TYPE',
1214: p_value1 => l_targ_pt_name

Line 1218: PA_UTILS.ADD_MESSAGE

1214: p_value1 => l_targ_pt_name
1215:
1216: );
1217: ELSIF (p_calling_mode = 'SUBMIT') THEN
1218: PA_UTILS.ADD_MESSAGE
1219: ( p_app_short_name => 'PA',
1220: p_msg_name => 'PA_FP_CIS_INV_VER_TYPE_MATCH'
1221: );
1222:

Line 1242: -- Add message in PA_UTILS

1238: IF (l_t_fin_plan_pref_code = 'REVENUE_ONLY') THEN
1239: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 16****');
1240: -- MERGE NOT POSSIBLE
1241: l_merge_possible_code := 'E';
1242: -- Add message in PA_UTILS
1243: IF (p_calling_mode = 'INCLUDE') THEN
1244: PA_UTILS.ADD_MESSAGE
1245: ( p_app_short_name => 'PA',
1246: p_msg_name => 'PA_FP_CI_INV_PREF_CODE_MATCH',

Line 1244: PA_UTILS.ADD_MESSAGE

1240: -- MERGE NOT POSSIBLE
1241: l_merge_possible_code := 'E';
1242: -- Add message in PA_UTILS
1243: IF (p_calling_mode = 'INCLUDE') THEN
1244: PA_UTILS.ADD_MESSAGE
1245: ( p_app_short_name => 'PA',
1246: p_msg_name => 'PA_FP_CI_INV_PREF_CODE_MATCH',
1247: p_token1 => 'CHG_DOC',
1248: p_value1 => l_src_ci_number

Line 1251: PA_UTILS.ADD_MESSAGE

1247: p_token1 => 'CHG_DOC',
1248: p_value1 => l_src_ci_number
1249: );
1250: ELSIF (p_calling_mode = 'IMPLEMENT') THEN
1251: PA_UTILS.ADD_MESSAGE
1252: ( p_app_short_name => 'PA',
1253: p_msg_name => 'PA_FP_CIM_INV_PREF_CODE_MATCH',
1254: p_token1 => 'PLAN_TYPE',
1255: p_value1 => l_targ_pt_name

Line 1259: PA_UTILS.ADD_MESSAGE

1255: p_value1 => l_targ_pt_name
1256:
1257: );
1258: ELSIF (p_calling_mode = 'SUBMIT') THEN
1259: PA_UTILS.ADD_MESSAGE
1260: ( p_app_short_name => 'PA',
1261: p_msg_name => 'PA_FP_CIS_INV_PREF_CODE_MATCH'
1262: );
1263:

Line 1283: -- Add message in PA_UTILS

1279: IF (l_t_fin_plan_pref_code = 'COST_ONLY') THEN
1280: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 18');
1281: -- MERGE NOT POSSIBLE
1282: l_merge_possible_code := 'E';
1283: -- Add message in PA_UTILS
1284: IF (p_calling_mode = 'INCLUDE') THEN
1285: PA_UTILS.ADD_MESSAGE
1286: ( p_app_short_name => 'PA',
1287: p_msg_name => 'PA_FP_CI_INV_PREF_CODE_MATCH',

Line 1285: PA_UTILS.ADD_MESSAGE

1281: -- MERGE NOT POSSIBLE
1282: l_merge_possible_code := 'E';
1283: -- Add message in PA_UTILS
1284: IF (p_calling_mode = 'INCLUDE') THEN
1285: PA_UTILS.ADD_MESSAGE
1286: ( p_app_short_name => 'PA',
1287: p_msg_name => 'PA_FP_CI_INV_PREF_CODE_MATCH',
1288: p_token1 => 'CHG_DOC',
1289: p_value1 => l_src_ci_number

Line 1293: PA_UTILS.ADD_MESSAGE

1289: p_value1 => l_src_ci_number
1290:
1291: );
1292: ELSIF (p_calling_mode = 'IMPLEMENT') THEN
1293: PA_UTILS.ADD_MESSAGE
1294: ( p_app_short_name => 'PA',
1295: p_msg_name => 'PA_FP_CIM_INV_PREF_CODE_MATCH',
1296: p_token1 => 'PLAN_TYPE',
1297: p_value1 => l_targ_pt_name

Line 1300: PA_UTILS.ADD_MESSAGE

1296: p_token1 => 'PLAN_TYPE',
1297: p_value1 => l_targ_pt_name
1298: );
1299: ELSIF (p_calling_mode = 'SUBMIT') THEN
1300: PA_UTILS.ADD_MESSAGE
1301: ( p_app_short_name => 'PA',
1302: p_msg_name => 'PA_FP_CIS_INV_PREF_CODE_MATCH'
1303: );
1304:

Line 1328: -- Add message in PA_UTILS

1324: IF (l_t_version_type = 'COST') THEN
1325: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 21***');
1326: -- MERGE NOT POSSIBLE
1327: l_merge_possible_code := 'E';
1328: -- Add message in PA_UTILS
1329: IF (p_calling_mode = 'INCLUDE') THEN
1330: PA_UTILS.ADD_MESSAGE
1331: ( p_app_short_name => 'PA',
1332: p_msg_name => 'PA_FP_CI_INV_PREF_CODE_MATCH',

Line 1330: PA_UTILS.ADD_MESSAGE

1326: -- MERGE NOT POSSIBLE
1327: l_merge_possible_code := 'E';
1328: -- Add message in PA_UTILS
1329: IF (p_calling_mode = 'INCLUDE') THEN
1330: PA_UTILS.ADD_MESSAGE
1331: ( p_app_short_name => 'PA',
1332: p_msg_name => 'PA_FP_CI_INV_PREF_CODE_MATCH',
1333: p_token1 => 'CHG_DOC',
1334: p_value1 => l_src_ci_number

Line 1338: PA_UTILS.ADD_MESSAGE

1334: p_value1 => l_src_ci_number
1335:
1336: );
1337: ELSIF (p_calling_mode = 'IMPLEMENT') THEN
1338: PA_UTILS.ADD_MESSAGE
1339: ( p_app_short_name => 'PA',
1340: p_msg_name => 'PA_FP_CIM_INV_PREF_CODE_MATCH',
1341: p_token1 => 'PLAN_TYPE',
1342: p_value1 => l_targ_pt_name

Line 1346: PA_UTILS.ADD_MESSAGE

1342: p_value1 => l_targ_pt_name
1343:
1344: );
1345: ELSIF (p_calling_mode = 'SUBMIT') THEN
1346: PA_UTILS.ADD_MESSAGE
1347: ( p_app_short_name => 'PA',
1348: p_msg_name => 'PA_FP_CIS_INV_PREF_CODE_MATCH'
1349: );
1350:

Line 1368: -- Add message in PA_UTILS

1364: IF (l_t_version_type = 'REVENUE') THEN
1365: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 23***');
1366: -- MERGE NOT POSSIBLE
1367: l_merge_possible_code := 'E';
1368: -- Add message in PA_UTILS
1369: IF (p_calling_mode = 'INCLUDE') THEN
1370: PA_UTILS.ADD_MESSAGE
1371: ( p_app_short_name => 'PA',
1372: p_msg_name => 'PA_FP_CI_INV_PREF_CODE_MATCH',

Line 1370: PA_UTILS.ADD_MESSAGE

1366: -- MERGE NOT POSSIBLE
1367: l_merge_possible_code := 'E';
1368: -- Add message in PA_UTILS
1369: IF (p_calling_mode = 'INCLUDE') THEN
1370: PA_UTILS.ADD_MESSAGE
1371: ( p_app_short_name => 'PA',
1372: p_msg_name => 'PA_FP_CI_INV_PREF_CODE_MATCH',
1373: p_token1 => 'CHG_DOC',
1374: p_value1 => l_src_ci_number

Line 1378: PA_UTILS.ADD_MESSAGE

1374: p_value1 => l_src_ci_number
1375:
1376: );
1377: ELSIF (p_calling_mode = 'IMPLEMENT') THEN
1378: PA_UTILS.ADD_MESSAGE
1379: ( p_app_short_name => 'PA',
1380: p_msg_name => 'PA_FP_CIM_INV_PREF_CODE_MATCH',
1381: p_token1 => 'PLAN_TYPE',
1382: p_value1 => l_targ_pt_name

Line 1386: PA_UTILS.ADD_MESSAGE

1382: p_value1 => l_targ_pt_name
1383:
1384: );
1385: ELSIF (p_calling_mode = 'SUBMIT') THEN
1386: PA_UTILS.ADD_MESSAGE
1387: ( p_app_short_name => 'PA',
1388: p_msg_name => 'PA_FP_CIS_INV_PREF_CODE_MATCH'
1389: );
1390:

Line 1418: -- Add message in PA_UTILS

1414: ) THEN
1415: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_MERGE_POSSIBLE - 25');
1416: -- MERGE NOT POSSIBLE
1417: l_merge_possible_code := 'E';
1418: -- Add message in PA_UTILS
1419: IF (p_calling_mode = 'INCLUDE') THEN
1420: PA_UTILS.ADD_MESSAGE
1421: ( p_app_short_name => 'PA',
1422: p_msg_name => 'PA_FP_CI_INV_VER_TYPE_MATCH',

Line 1420: PA_UTILS.ADD_MESSAGE

1416: -- MERGE NOT POSSIBLE
1417: l_merge_possible_code := 'E';
1418: -- Add message in PA_UTILS
1419: IF (p_calling_mode = 'INCLUDE') THEN
1420: PA_UTILS.ADD_MESSAGE
1421: ( p_app_short_name => 'PA',
1422: p_msg_name => 'PA_FP_CI_INV_VER_TYPE_MATCH',
1423: p_token1 => 'CHG_DOC',
1424: p_value1 => l_src_ci_number

Line 1428: PA_UTILS.ADD_MESSAGE

1424: p_value1 => l_src_ci_number
1425:
1426: );
1427: ELSIF (p_calling_mode = 'IMPLEMENT') THEN
1428: PA_UTILS.ADD_MESSAGE
1429: ( p_app_short_name => 'PA',
1430: p_msg_name => 'PA_FP_CIM_INV_VER_TYPE_MATCH',
1431: p_token1 => 'PLAN_TYPE',
1432: p_value1 => l_targ_pt_name

Line 1436: PA_UTILS.ADD_MESSAGE

1432: p_value1 => l_targ_pt_name
1433:
1434: );
1435: ELSIF (p_calling_mode = 'SUBMIT') THEN
1436: PA_UTILS.ADD_MESSAGE
1437: ( p_app_short_name => 'PA',
1438: p_msg_name => 'PA_FP_CIS_INV_VER_TYPE_MATCH'
1439: );
1440:

Line 1570: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1566: throw an error as this mismatch cannot be handled in auto-baseline */
1567:
1568: x_return_status := FND_API.G_RET_STS_ERROR;
1569:
1570: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1571: p_msg_name => 'PA_FP_CHK_FUNDING_LVL');
1572: END IF;
1573: ELSE -- p_proposed_fund_level IS NULL
1574: pa_billing_core.check_funding_level (p_project_id,

Line 1599: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1595: where as Budget planning level is at project level
1596: throw an error as this mismatch cannot be handled in auto-baseline */
1597:
1598: x_return_status := FND_API.G_RET_STS_ERROR;
1599: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1600: p_msg_name => 'PA_FP_CHK_FUNDING_LVL');
1601: END IF;
1602: END IF;
1603:

Line 1662: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1658: close c1;
1659:
1660: IF l_found = 'Y' then
1661: x_return_status := FND_API.G_RET_STS_ERROR;
1662: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1663: p_msg_name => 'PA_FP_AGR_CI_NO_DELETE');
1664: END IF;
1665:
1666:

Line 1734: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1730: close c1;
1731:
1732: IF l_found = 'Y' then
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1734: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1735: p_msg_name => 'PA_FP_AGR_CUR_NO_CHANGE');
1736: END IF;
1737:
1738:

Line 1920: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1916: IF P_PA_DEBUG_MODE = 'Y' THEN
1917: pa_debug.write('Is_Create_CI_Version_Allowed: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
1918: END IF;
1919:
1920: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1921: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1922:
1923: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
1924: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2157: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

2153:
2154: -- raise error if the ci version cant be created
2155: x_return_status := FND_API.G_RET_STS_ERROR;
2156:
2157: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2158: p_msg_name => 'PA_FP_CI_VERSION_NOT_ALLOWED');
2159: RETURN;
2160: ELSE
2161: x_version_allowed_flag := 'Y';

Line 2229: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2225: END IF;
2226:
2227: IF p_agreement_number IS NULL THEN
2228: x_return_status := FND_API.G_RET_STS_ERROR;
2229: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2230: p_msg_name => 'PA_FP_AGR_NUM_REQ' );
2231: pa_debug.reset_err_stack;
2232: RETURN;
2233: END IF;

Line 2249: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2245: RETURN;
2246: EXCEPTION
2247: WHEN NO_DATA_FOUND THEN
2248: x_return_status := FND_API.G_RET_STS_ERROR;
2249: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2250: p_msg_name => 'PA_FP_AGR_INVALID',
2251: p_token1 => 'AGREEMENT_NUMBER',
2252: p_value1 => p_agreement_number);
2253: pa_debug.reset_err_stack;

Line 2387: PA_UTILS.ADD_MESSAGE

2383: and patl.language = userenv('LANG');
2384:
2385: EXCEPTION
2386: WHEN NO_DATA_FOUND THEN
2387: PA_UTILS.ADD_MESSAGE
2388: ( p_app_short_name => 'PA',
2389: p_msg_name => 'PA_FP_CI_NO_VERSION_DATA_FOUND');
2390: ----DBMS_OUTPUT.PUT_LINE('FP_CI_GET_VERSION_DETAILS - 2***');
2391: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2529: pa_utils.add_message

2525: l_msg_name := 'PA_FP_CI_AB_NO_CW';
2526: ELSE
2527: l_msg_name := 'PA_FP_APRV_CUR_WORK_NOT_EXISTS';
2528: END IF;
2529: pa_utils.add_message
2530: ( p_app_short_name => 'PA',
2531: p_msg_name => l_msg_name,
2532: p_token1 => 'PROJECT',
2533: p_value1 => l_project_name,

Line 2886: PA_UTILS.ADD_MESSAGE

2882: AND fin_plan_type_id = l_ci_aprv_plan_type_id
2883: AND fin_plan_version_id = l_ci_aprv_cw_bv_id;
2884: EXCEPTION
2885: WHEN NO_DATA_FOUND THEN
2886: PA_UTILS.ADD_MESSAGE
2887: ( p_app_short_name => 'PA',
2888: p_msg_name => 'PA_FP_CI_NO_PLAN_LVL_DATA_FND');
2889: x_return_status := FND_API.G_RET_STS_ERROR;
2890: END;

Line 2955: PA_UTILS.ADD_MESSAGE

2951: AND fin_plan_version_id = l_ci_aprv_cw_bv_id;
2952:
2953: EXCEPTION
2954: WHEN NO_DATA_FOUND THEN
2955: PA_UTILS.ADD_MESSAGE
2956: ( p_app_short_name => 'PA',
2957: p_msg_name => 'PA_FP_CI_NO_PLAN_LVL_DATA_FND');
2958: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_COPY_POSSIBLE - 2***');
2959: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3021: PA_UTILS.ADD_MESSAGE

3017: x_msg_data := NULL;
3018:
3019: ELSE
3020: IF (l_time_phase_code_flag = 'N') THEN
3021: PA_UTILS.ADD_MESSAGE
3022: ( p_app_short_name => 'PA',
3023: p_msg_name => 'PA_FP_CI_C_NO_SP_TIME_PHASE'
3024: );
3025: END IF;

Line 3028: PA_UTILS.ADD_MESSAGE

3024: );
3025: END IF;
3026:
3027: IF (p_source_plan_level_code <> l_target_plan_level_code) THEN
3028: PA_UTILS.ADD_MESSAGE
3029: ( p_app_short_name => 'PA',
3030: p_msg_name => 'PA_FP_CI_C_INV_PLAN_LVL_MATCH'
3031: );
3032: END IF;

Line 3034: PA_UTILS.ADD_MESSAGE

3030: p_msg_name => 'PA_FP_CI_C_INV_PLAN_LVL_MATCH'
3031: );
3032: END IF;
3033: IF (p_source_time_phased_code <> l_target_time_phased_code) THEN
3034: PA_UTILS.ADD_MESSAGE
3035: ( p_app_short_name => 'PA',
3036: p_msg_name => 'PA_FP_CI_C_TIME_PHASE_DIFF'
3037: );
3038: END IF;

Line 3040: PA_UTILS.ADD_MESSAGE

3036: p_msg_name => 'PA_FP_CI_C_TIME_PHASE_DIFF'
3037: );
3038: END IF;
3039: IF (p_source_resource_list_id <> l_target_resource_list_id) THEN
3040: PA_UTILS.ADD_MESSAGE
3041: ( p_app_short_name => 'PA',
3042: p_msg_name => 'PA_FP_CI_C_RES_LIST_DIFF'
3043: );
3044: END IF;

Line 3045: PA_UTILS.ADD_MESSAGE

3041: ( p_app_short_name => 'PA',
3042: p_msg_name => 'PA_FP_CI_C_RES_LIST_DIFF'
3043: );
3044: END IF;
3045: PA_UTILS.ADD_MESSAGE
3046: ( p_app_short_name => 'PA',
3047: p_msg_name => 'PA_FP_CI_NO_COPY',
3048: p_token1 => 'CI_ID',
3049: p_value1 => l_token_ci_id,

Line 3230: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

3226: pa_debug.g_err_stage := 'No Budget Version for the CI';
3227: pa_debug.write('Fp_Ci_Impact_Submit_Chk: ' || l_module_name,
3228: pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3229: END IF;
3230: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3231: p_msg_name => 'PA_FP_CI_VERSION_NOT_FOUND');
3232: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3233:
3234: ELSE

Line 3251: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

3247:
3248: IF 'Y' = pa_fin_plan_utils.does_bv_have_rej_lines
3249: (p_budget_version_id => l_ci_version_id_tbl(i))
3250: THEN
3251: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3252: p_msg_name => 'PA_FP_CI_REJ_LINES_EXST_TO_SUB');
3253: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3254: END IF;
3255:

Line 3443: PA_UTILS.ADD_MESSAGE

3439: PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
3440: pa_debug.g_err_stage:= 'p_ci_id = '|| to_char(p_ci_id);
3441: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
3442: END IF;
3443: PA_UTILS.ADD_MESSAGE
3444: (p_app_short_name => 'PA',
3445: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3446: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3447:

Line 3710: PA_UTILS.ADD_MESSAGE

3706: l_message_code := 'PA_FP_CIM_INVP_RES_TO_RES_GRP';
3707: elsif p_calling_mode = 'SUBMIT' then
3708: l_message_code := 'PA_FP_CIS_INVP_RES_TO_RES_GRP';
3709: end if;
3710: PA_UTILS.ADD_MESSAGE
3711: ( p_app_short_name => 'PA',
3712: p_msg_name => l_message_code );
3713:
3714: elsif l_source_plan_level = 'R' AND

Line 3880: PA_UTILS.ADD_MESSAGE

3876: l_message_code := 'PA_FP_CIM_INV_RES_TO_RES_GRP';
3877: elsif p_calling_mode = 'SUBMIT' then
3878: l_message_code := 'PA_FP_CIS_INV_RES_TO_RES_GRP';
3879: end if;
3880: PA_UTILS.ADD_MESSAGE
3881: ( p_app_short_name => 'PA',
3882: p_msg_name => l_message_code );
3883:
3884: elsif p_s_fin_plan_level_code <> 'P' and p_t_fin_plan_level_code <> 'P' then

Line 3893: PA_UTILS.ADD_MESSAGE

3889: l_message_code := 'PA_FP_CI_INV_RES_TO_RES_GRP';
3890: elsif p_calling_mode = 'IMPLEMENT' then
3891: l_message_code := 'PA_FP_CIM_INV_RES_TO_RES_GRP';
3892: end if;
3893: PA_UTILS.ADD_MESSAGE
3894: ( p_app_short_name => 'PA',
3895: p_msg_name => l_message_code );
3896: end if;
3897: end if;

Line 3903: PA_UTILS.ADD_MESSAGE

3899: if
3900: ( p_s_fin_plan_level_code = 'L' and p_t_fin_plan_level_code = 'L' ) OR
3901: ( p_s_fin_plan_level_code = 'T' and p_t_fin_plan_level_code = 'T' ) OR
3902: ( p_s_fin_plan_level_code in ( 'T','L','M') and p_t_fin_plan_level_code = 'P' ) THEN
3903: PA_UTILS.ADD_MESSAGE
3904: ( p_app_short_name => 'PA',
3905: p_msg_name => 'PA_FP_CI_INV_S_TASK_DATA',
3906: p_token1 => 'TASK_NAME',
3907: p_value1 => c1_rec.task_name,

Line 3913: PA_UTILS.ADD_MESSAGE

3909: p_value2 => c1_rec.task_number );
3910:
3911: elsif p_s_fin_plan_level_code <> 'P' and p_t_fin_plan_level_code <> 'P' then
3912: IF c1_rec.task_id = l_target_task_id THEN
3913: PA_UTILS.ADD_MESSAGE
3914: ( p_app_short_name => 'PA',
3915: p_msg_name => 'PA_FP_CI_INV_S_TASK_DATA',
3916: p_token1 => 'TASK_NAME',
3917: p_value1 => c1_rec.task_name,

Line 3921: PA_UTILS.ADD_MESSAGE

3917: p_value1 => c1_rec.task_name,
3918: p_token2 => 'TASK_NO',
3919: p_value2 => c1_rec.task_number );
3920: ELSE
3921: PA_UTILS.ADD_MESSAGE
3922: ( p_app_short_name => 'PA',
3923: p_msg_name => 'PA_FP_CI_INV_ST_TASK_DATA',
3924: p_token1 => 'S_TASK_NAME',
3925: p_value1 => c1_rec.task_name,

Line 4177: PA_UTILS.ADD_MESSAGE

4173: elsif p_calling_mode = 'SUBMIT' then
4174: l_message_code := 'PA_FP_CIS_INV_TSK_LVL';
4175:
4176: end if;
4177: PA_UTILS.ADD_MESSAGE
4178: ( p_app_short_name => 'PA',
4179: p_msg_name => l_message_code );
4180:
4181: end if; /* error msg header flag check */

Line 4182: PA_UTILS.ADD_MESSAGE

4178: ( p_app_short_name => 'PA',
4179: p_msg_name => l_message_code );
4180:
4181: end if; /* error msg header flag check */
4182: PA_UTILS.ADD_MESSAGE
4183: ( p_app_short_name => 'PA',
4184: p_msg_name => 'PA_FP_CI_INV_S_TASK_DATA',
4185: p_token1 => 'TASK_NAME',
4186: p_value1 => l_target_task_name,

Line 4919: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

4915: IF l_debug_mode = 'Y' THEN
4916: pa_debug.g_err_stage:='p_project_id is null';
4917: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
4918: END IF;
4919: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4920: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4921: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4922: END IF;
4923:

Line 7103: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

7099: IF l_debug_mode = 'Y' THEN
7100: pa_debug.g_err_stage:='p_project_id is null';
7101: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
7102: END IF;
7103: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
7104: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
7105: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7106: END IF;
7107:

Line 7118: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

7114: IF l_debug_mode = 'Y' THEN
7115: pa_debug.g_err_stage:='p_budget_version_id is null';
7116: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
7117: END IF;
7118: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
7119: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
7120: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7121: END IF;
7122:

Line 7155: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

7151: IF l_debug_mode = 'Y' THEN
7152: pa_debug.g_err_stage:='p_budget_version_id is invalid - fetching version type';
7153: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
7154: END IF;
7155: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
7156: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
7157: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7158: END;
7159: ELSE

Line 7188: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

7184: IF l_debug_mode = 'Y' THEN
7185: pa_debug.g_err_stage:='p_budget_version_id is invalid - fetching fin plan type id';
7186: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);
7187: END IF;
7188: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
7189: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
7190: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7191: END;
7192: ELSE

Line 7710: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

7706: pa_debug.write(l_mod_name,pa_debug.g_err_stage,l_debug_level5);
7707: END IF;
7708:
7709:
7710: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
7711: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
7712: p_token1 => l_token_name,
7713: p_value1 => l_mod_name);
7714:

Line 7961: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

7957: pa_debug.write(l_mod_name,pa_debug.g_err_stage,l_debug_level5);
7958: END IF;
7959:
7960:
7961: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
7962: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
7963: p_token1 => l_token_name,
7964: p_value1 => l_mod_name);
7965:

Line 8614: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

8610:
8611: END IF;
8612:
8613:
8614: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
8615: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
8616: p_token1 => l_token_name,
8617: p_value1 => l_mod_name);
8618:

Line 9202: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

9198: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
9199:
9200: END IF;
9201:
9202: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9203: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
9204: p_token1 => 'PROCEDURENAME',
9205: p_value1 => l_module_name);
9206:

Line 9595: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

9591: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
9592:
9593: END IF;
9594:
9595: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9596: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
9597: p_token1 => 'PROCEDURENAME',
9598: p_value1 => l_module_name);
9599:

Line 9901: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

9897: pa_debug.g_err_stage:='p_ci_id = '||p_ci_id;
9898: pa_debug.write('get_txn_curr_code_of_ci_ver: ' || g_module_name,pa_debug.g_err_stage,5);
9899: END IF;
9900:
9901: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
9902: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
9903: p_token1 => 'PROCEDURENAME',
9904: p_value1 => 'PAFPCIUB.get_txn_curr_code_of_ci_ver');
9905:

Line 10013: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

10009: IF l_debug_mode = 'Y' THEN
10010: pa_debug.g_err_stage:='Input p_ci_type_id is NULL';
10011: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
10012: END IF;
10013: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
10014: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
10015: p_token1 => 'PROCEDURENAME',
10016: p_value1 => 'PAFPCIUB.validate_fp_ci_type_delete');
10017: pa_debug.reset_curr_function;