DBA Data[Home] [Help]

APPS.PO_EMAIL_GENERATE dependencies on PO_COMMUNICATION_PVT

Line 1389: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);

1385: if (l_ship_to_count > 1) then
1386: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1387: /* Bug 9356725*/
1388: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1389: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1390: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
1391: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
1392: l_document := l_document || '
' || l_ship_cust_name || NL;
1393: l_document := l_document || '
' || l_ship_cont_name || NL;

Line 1390: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();

1386: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1387: /* Bug 9356725*/
1388: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1389: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1390: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
1391: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
1392: l_document := l_document || '
' || l_ship_cust_name || NL;
1393: l_document := l_document || '
' || l_ship_cont_name || NL;
1394: END IF;

Line 1391: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();

1387: /* Bug 9356725*/
1388: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1389: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1390: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
1391: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
1392: l_document := l_document || '
' || l_ship_cust_name || NL;
1393: l_document := l_document || '
' || l_ship_cont_name || NL;
1394: END IF;
1395: /* Bug 9356725*/

Line 1436: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);

1432: else
1433: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1434: /* Bug 9356725*/
1435: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1436: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1437: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
1438: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
1439: l_document := l_document || '
' || l_ship_cust_name || NL;
1440: l_document := l_document || '
' || l_ship_cont_name || NL;

Line 1437: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();

1433: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1434: /* Bug 9356725*/
1435: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1436: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1437: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
1438: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
1439: l_document := l_document || '
' || l_ship_cust_name || NL;
1440: l_document := l_document || '
' || l_ship_cont_name || NL;
1441: END IF;

Line 1438: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();

1434: /* Bug 9356725*/
1435: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1436: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1437: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
1438: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
1439: l_document := l_document || '
' || l_ship_cust_name || NL;
1440: l_document := l_document || '
' || l_ship_cont_name || NL;
1441: END IF;
1442: /* Bug 9356725*/

Line 1691: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);

1687: if (l_ship_to_count > 1) then
1688: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1689: /* Bug 9356725*/
1690: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1691: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1692: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
1693: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
1694: l_document := l_document || '
' || l_ship_cust_name || NL;
1695: l_document := l_document || '
' || l_ship_cont_name || NL;

Line 1692: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();

1688: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1689: /* Bug 9356725*/
1690: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1691: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1692: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
1693: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
1694: l_document := l_document || '
' || l_ship_cust_name || NL;
1695: l_document := l_document || '
' || l_ship_cont_name || NL;
1696: END IF;

Line 1693: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();

1689: /* Bug 9356725*/
1690: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1691: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1692: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
1693: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
1694: l_document := l_document || '
' || l_ship_cust_name || NL;
1695: l_document := l_document || '
' || l_ship_cont_name || NL;
1696: END IF;
1697: /* Bug 9356725*/

Line 1749: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);

1745: -- more than one shipment
1746: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1747: /* Bug 9356725*/
1748: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1749: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1750: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
1751: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
1752: l_document := l_document || '
' || l_ship_cust_name || NL;
1753: l_document := l_document || '
' || l_ship_cont_name || NL;

Line 1750: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();

1746: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || NL;
1747: /* Bug 9356725*/
1748: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1749: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1750: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
1751: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
1752: l_document := l_document || '
' || l_ship_cust_name || NL;
1753: l_document := l_document || '
' || l_ship_cont_name || NL;
1754: END IF;

Line 1751: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();

1747: /* Bug 9356725*/
1748: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
1749: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
1750: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
1751: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
1752: l_document := l_document || '
' || l_ship_cust_name || NL;
1753: l_document := l_document || '
' || l_ship_cont_name || NL;
1754: END IF;
1755: /* Bug 9356725*/

Line 2384: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);

2380: if (l_ship_to_count > 1) then
2381: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || ': ' || NL;
2382: /* Bug 9356725*/
2383: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
2384: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
2385: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
2386: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
2387: l_document := l_document || ' ' || l_ship_cust_name || NL;
2388: l_document := l_document || ' ' || l_ship_cont_name || NL;

Line 2385: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();

2381: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_SHIP_TO_SMALL') || ': ' || NL;
2382: /* Bug 9356725*/
2383: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
2384: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
2385: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
2386: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
2387: l_document := l_document || ' ' || l_ship_cust_name || NL;
2388: l_document := l_document || ' ' || l_ship_cont_name || NL;
2389: END IF;

Line 2386: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();

2382: /* Bug 9356725*/
2383: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
2384: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
2385: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
2386: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
2387: l_document := l_document || ' ' || l_ship_cust_name || NL;
2388: l_document := l_document || ' ' || l_ship_cont_name || NL;
2389: END IF;
2390: /* Bug 9356725*/

Line 2406: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);

2402: l_document := l_document || ' ' || l_hrl_country || NL ;
2403: ELSE
2404: /* Bug 9356725*/
2405: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
2406: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
2407: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
2408: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
2409: l_document := l_document || ' ' || l_ship_cust_name || NL;
2410: l_document := l_document || ' ' || l_ship_cont_name || NL;

Line 2407: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();

2403: ELSE
2404: /* Bug 9356725*/
2405: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
2406: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
2407: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
2408: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
2409: l_document := l_document || ' ' || l_ship_cust_name || NL;
2410: l_document := l_document || ' ' || l_ship_cont_name || NL;
2411: END IF;

Line 2408: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();

2404: /* Bug 9356725*/
2405: IF(l_line_loc.drop_ship_flag = 'Y') THEN -- Check for dropship flag If details present then display the same
2406: l_drop_ship:= PO_COMMUNICATION_PVT.get_drop_ship_details(l_line_loc.line_location_id);
2407: l_ship_cust_name := PO_COMMUNICATION_PVT.getShipCustName();
2408: l_ship_cont_name := PO_COMMUNICATION_PVT.getShipContName();
2409: l_document := l_document || ' ' || l_ship_cust_name || NL;
2410: l_document := l_document || ' ' || l_ship_cont_name || NL;
2411: END IF;
2412: /* Bug 9356725*/