1353: c_distribution_num,
1354: c_level_altered,
1355: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
1356: 'ICX_ACCEPTANCE_DUE_DATE',
1357: to_char(p_po_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1358: to_char(p_po_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1359: );
1360: END IF;
1361:
1354: c_level_altered,
1355: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
1356: 'ICX_ACCEPTANCE_DUE_DATE',
1357: to_char(p_po_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1358: to_char(p_po_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1359: );
1360: END IF;
1361:
1362: v_progress := '280';
1407: c_distribution_num,
1408: c_level_altered,
1409: --fnd_message.get_String('PO', 'POS_EFFECTIVE_DATE'),
1410: 'ICX_EFFECTIVE_DATE',
1411: to_char(p_po_from.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1412: to_char(p_po_to.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1413: );
1414: END IF;
1415:
1408: c_level_altered,
1409: --fnd_message.get_String('PO', 'POS_EFFECTIVE_DATE'),
1410: 'ICX_EFFECTIVE_DATE',
1411: to_char(p_po_from.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1412: to_char(p_po_to.start_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1413: );
1414: END IF;
1415:
1416: v_progress := '300';
1435: c_distribution_num,
1436: c_level_altered,
1437: --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
1438: 'ICX_EXPIRATION_DATE',
1439: to_char(p_po_from.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1440: to_char(p_po_to.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1441: );
1442: END IF;
1443:
1436: c_level_altered,
1437: --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
1438: 'ICX_EXPIRATION_DATE',
1439: to_char(p_po_from.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1440: to_char(p_po_to.end_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1441: );
1442: END IF;
1443:
1444: v_progress := '310';
1717: c_distribution_num,
1718: c_level_altered,
1719: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
1720: 'ICX_ACCEPTANCE_DUE_DATE',
1721: to_char(p_release_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1722: to_char(p_release_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1723: );
1724: END IF;
1725:
1718: c_level_altered,
1719: --fnd_message.get_String('PO', 'POS_ACCEPTANCE_DUE_DATE'),
1720: 'ICX_ACCEPTANCE_DUE_DATE',
1721: to_char(p_release_from.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1722: to_char(p_release_to.acceptance_due_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1723: );
1724: END IF;
1725:
1726: v_progress := '380';
1797: c_distribution_num,
1798: c_level_altered,
1799: --fnd_message.get_String('PO', 'POS_RELEASE_DATE'),
1800: 'ICX_RELEASE_DATE',
1801: to_char(p_release_from.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1802: to_char(p_release_to.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1803: );
1804: END IF;
1805:
1798: c_level_altered,
1799: --fnd_message.get_String('PO', 'POS_RELEASE_DATE'),
1800: 'ICX_RELEASE_DATE',
1801: to_char(p_release_from.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
1802: to_char(p_release_to.release_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
1803: );
1804: END IF;
1805:
1806: EXCEPTION
2512: c_distribution_num,
2513: c_level_altered,
2514: --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
2515: 'ICX_EXPIRATION_DATE',
2516: to_char(p_line_from.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2517: to_char(p_line_to.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2518: );
2519: END IF;
2520:
2513: c_level_altered,
2514: --fnd_message.get_String('PO', 'POS_EXPIRATION_DATE'),
2515: 'ICX_EXPIRATION_DATE',
2516: to_char(p_line_from.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2517: to_char(p_line_to.expiration_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2518: );
2519: END IF;
2520:
2521: EXCEPTION
2795: c_distribution_num,
2796: c_level_altered,
2797: --fnd_message.get_String('PO', 'POS_PROMISED_DATE'),
2798: 'ICX_PROMISED_DATE',
2799: to_char(p_loc_from.promised_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2800: to_char(p_loc_to.promised_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2801:
2802: );
2803: END IF;
2796: c_level_altered,
2797: --fnd_message.get_String('PO', 'POS_PROMISED_DATE'),
2798: 'ICX_PROMISED_DATE',
2799: to_char(p_loc_from.promised_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2800: to_char(p_loc_to.promised_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2801:
2802: );
2803: END IF;
2804:
2824: c_distribution_num,
2825: c_level_altered,
2826: --fnd_message.get_String('PO', 'POS_NEED_BY_DATE'),
2827: 'ICX_NEED_BY_DATE',
2828: to_char(p_loc_from.need_by_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2829: to_char(p_loc_to.need_by_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2830: );
2831: END IF;
2832:
2825: c_level_altered,
2826: --fnd_message.get_String('PO', 'POS_NEED_BY_DATE'),
2827: 'ICX_NEED_BY_DATE',
2828: to_char(p_loc_from.need_by_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2829: to_char(p_loc_to.need_by_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2830: );
2831: END IF;
2832:
2833: v_progress := '670';
2852: c_distribution_num,
2853: c_level_altered,
2854: --fnd_message.get_String('PO', 'POS_LAST_ACCEPT_DATE'),
2855: 'ICX_LAST_ACCEPT_DATE',
2856: to_char(p_loc_from.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2857: to_char(p_loc_to.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2858: );
2859: END IF;
2860:
2853: c_level_altered,
2854: --fnd_message.get_String('PO', 'POS_LAST_ACCEPT_DATE'),
2855: 'ICX_LAST_ACCEPT_DATE',
2856: to_char(p_loc_from.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')),
2857: to_char(p_loc_to.last_accept_date,fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK'))
2858: );
2859: END IF;
2860:
2861: v_progress := '680';