[Home] [Help]
1245: when others then
1246: null;
1247: END;
1248:
1249: PO_DEBUG.put_line ('Before calling validate_effective_dates()');
1250:
1251: /*
1252: Validating the expiration date. Since this is a line, there is no
1253: pricebreak effective dates. Hence, null is being passed.
1259: null,
1260: l_exp_date,
1261: l_errormsg);
1262:
1263: PO_DEBUG.put_line ('After calling validate_effective_dates()');
1264:
1265: if (l_errormsg is not null) then
1266: po_interface_errors_sv1.handle_interface_errors(
1267: 'PO_DOCS_OPEN_INTERFACE',
1283: END IF; --if blanket
1284:
1285:
1286: --
1287: PO_DEBUG.put_line ('Start validating services line types');
1288:
1289: -- Bug 3652094:
1290: -- Services enabled check is extended to all new line types
1291: IF (p_order_type_lookup_code IN ('FIXED PRICE', 'RATE')) THEN
1352:
1353: IF (p_job_business_group_id IS NOT NULL) THEN
1354:
1355: IF (g_po_pdoi_write_to_file = 'Y') THEN
1356: PO_DEBUG.put_line('**Start validating job_business_group_id: '||
1357: p_job_business_group_id);
1358: END IF;
1359:
1360: IF nvl(HR_GENERAL.get_xbg_profile,'N') = 'N' THEN
1359:
1360: IF nvl(HR_GENERAL.get_xbg_profile,'N') = 'N' THEN
1361:
1362: IF (g_po_pdoi_write_to_file = 'Y') THEN
1363: PO_DEBUG.put_line('Validate against FSP');
1364: END IF;
1365:
1366: SELECT COUNT(FSP.business_group_id)
1367: INTO x_count
1370:
1371: IF x_count < 1 THEN
1372:
1373: IF (g_po_pdoi_write_to_file = 'Y') THEN
1374: PO_DEBUG.put_line('ERROR: xbg profile is N but ' ||
1375: 'job_business_group_id not in FSP');
1376: END IF;
1377:
1378: l_valid_business_group_id := 'N';
1403:
1404: ELSE --nvl(HR_GENERAL.get_xbg_profile,'N') = 'N'
1405:
1406: IF (g_po_pdoi_write_to_file = 'Y') THEN
1407: PO_DEBUG.put_line('Validate against PBG');
1408: END IF;
1409:
1410: SELECT COUNT(PBG.business_group_id)
1411: INTO x_count
1416:
1417: IF (x_count < 1) THEN
1418:
1419: IF (g_po_pdoi_write_to_file = 'Y') THEN
1420: PO_DEBUG.put_line('ERROR: xbg profile is Y and ' ||
1421: 'job_business_group_id not in PBG');
1422: END IF;
1423:
1424: l_valid_business_group_id := 'N';
1449:
1450: END IF; --nvl(HR_GENERAL.get_xbg_profile,'N') = 'N'
1451:
1452: IF (g_po_pdoi_write_to_file = 'Y') THEN
1453: PO_DEBUG.put_line('**Done validating job_business_group_id');
1454: END IF;
1455:
1456: END IF; --IF (p_job_business_group_id IS NOT NULL)
1457: --
1489:
1490: IF l_valid_business_group_id = 'Y' THEN
1491:
1492: IF (g_po_pdoi_write_to_file = 'Y') THEN
1493: PO_DEBUG.put_line('**Start validating job_id: '||p_job_id ||
1494: ' against job_business_group_id: '||
1495: p_job_business_group_id);
1496: END IF;
1497:
1498: IF nvl(HR_GENERAL.get_xbg_profile,'N') = 'N'
1499: OR p_job_business_group_id IS NULL THEN
1500:
1501: IF (g_po_pdoi_write_to_file = 'Y') THEN
1502: PO_DEBUG.put_line('Validate against FSP since xbg_profile=N '||
1503: 'or job_business_group_id is null');
1504: END IF;
1505:
1506: SELECT COUNT(PJ.job_id)
1515: AND NVL(TRUNC(PJ.date_to), TRUNC(sysdate));
1516: ELSE --if HR: xbg profile = 'Y' and x_job_business_group_id not null
1517:
1518: IF (g_po_pdoi_write_to_file = 'Y') THEN
1519: PO_DEBUG.put_line('Validate against PBG since xbg_profile=Y '||
1520: 'and job_business_group_id not null');
1521: END IF;
1522:
1523: SELECT COUNT(PJ.job_id)
1536:
1537: IF (x_count < 1) THEN
1538:
1539: IF (g_po_pdoi_write_to_file = 'Y') THEN
1540: PO_DEBUG.put_line('ERROR: job_id/business_group_id combination '||
1541: 'is invalid');
1542: END IF;
1543:
1544: PO_INTERFACE_ERRORS_SV1.handle_interface_errors(
1565: X_header_processable_flag => x_header_processable_flag);
1566: END IF;
1567:
1568: IF (g_po_pdoi_write_to_file = 'Y') THEN
1569: PO_DEBUG.put_line('**Done validating job_id/business_group_id');
1570: END IF;
1571:
1572: END IF; --IF l_valid_business_group_id = 'Y'
1573: --