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.

[Home] [Help]

APPS.PO_PDOI_ITEM_PROCESS_PVT dependencies on FND_API

Line 121: IF (l_items.error_flag_tbl(i) = FND_API.g_TRUE) THEN

117: -- remove records that has derivation errors on location attrs;
118: -- we won't create/update items for such records
119: FOR i IN 1..l_items.rec_count
120: LOOP
121: IF (l_items.error_flag_tbl(i) = FND_API.g_TRUE) THEN
122: l_unprocessed_row_tbl.DELETE(i);
123:
124: IF (PO_LOG.d_stmt) THEN
125: PO_LOG.stmt(d_module, d_position, 'record removed due to ' ||

Line 133: FND_API.g_TRUE;

129: END IF;
130:
131: -- set corresponding po_line's error_flag to 'Y'
132: x_lines.error_flag_tbl(l_items.line_ref_index_tbl(i)) :=
133: FND_API.g_TRUE;
134:
135: END IF;
136: END LOOP;
137:

Line 278: FND_API.g_TRUE) THEN

274: l_index := l_unprocessed_row_tbl.FIRST;
275: WHILE (l_index IS NOT NULL)
276: LOOP
277: IF (x_lines.error_flag_tbl(l_items.line_ref_index_tbl(l_index)) =
278: FND_API.g_TRUE) THEN
279: IF (PO_LOG.d_stmt) THEN
280: PO_LOG.stmt(d_module, d_position, 'reject item on index',
281: l_index);
282: END IF;

Line 385: WHERE p_lines.error_flag_tbl(i) = FND_API.g_FALSE

381: p_lines.intf_line_id_tbl(i),
382: p_lines.hd_po_header_id_tbl(i),
383: p_lines.draft_id_tbl(i)
384: FROM DUAL
385: WHERE p_lines.error_flag_tbl(i) = FND_API.g_FALSE
386: AND p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE
387: AND p_lines.purchase_basis_tbl(i) NOT IN ('TEMP LABOR', 'SERVICES')
388: AND (p_lines.item_tbl(i) IS NOT NULL OR
389: p_lines.item_id_tbl(i) IS NOT NULL);

Line 386: AND p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE

382: p_lines.hd_po_header_id_tbl(i),
383: p_lines.draft_id_tbl(i)
384: FROM DUAL
385: WHERE p_lines.error_flag_tbl(i) = FND_API.g_FALSE
386: AND p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE
387: AND p_lines.purchase_basis_tbl(i) NOT IN ('TEMP LABOR', 'SERVICES')
388: AND (p_lines.item_tbl(i) IS NOT NULL OR
389: p_lines.item_id_tbl(i) IS NOT NULL);
390:

Line 478: FND_API.g_FALSE,

474: fnd_global.conc_program_id,
475: sysdate,
476:
477: -- error_flag
478: FND_API.g_FALSE,
479:
480: -- reference index in po_lines
481: gt.num1
482: BULK COLLECT INTO

Line 797: l_exist_in_inv_org_tbl(l_index) := FND_API.g_FALSE;

793: --l_item_ref_tbl(x_items.ln_item_tbl(l_index)) := l_index;
794: -- Bug 6956962
795:
796: -- set initial values for l_exist_in_xxx_org_tbl to 'N'
797: l_exist_in_inv_org_tbl(l_index) := FND_API.g_FALSE;
798: l_exist_in_master_org_tbl(l_index) := FND_API.g_FALSE;
799: l_exist_in_ship_to_org_tbl(l_index) := FND_API.g_FALSE;
800: END IF;
801:

Line 798: l_exist_in_master_org_tbl(l_index) := FND_API.g_FALSE;

794: -- Bug 6956962
795:
796: -- set initial values for l_exist_in_xxx_org_tbl to 'N'
797: l_exist_in_inv_org_tbl(l_index) := FND_API.g_FALSE;
798: l_exist_in_master_org_tbl(l_index) := FND_API.g_FALSE;
799: l_exist_in_ship_to_org_tbl(l_index) := FND_API.g_FALSE;
800: END IF;
801:
802: l_index := x_unprocessed_row_tbl.NEXT(l_index);

Line 799: l_exist_in_ship_to_org_tbl(l_index) := FND_API.g_FALSE;

795:
796: -- set initial values for l_exist_in_xxx_org_tbl to 'N'
797: l_exist_in_inv_org_tbl(l_index) := FND_API.g_FALSE;
798: l_exist_in_master_org_tbl(l_index) := FND_API.g_FALSE;
799: l_exist_in_ship_to_org_tbl(l_index) := FND_API.g_FALSE;
800: END IF;
801:
802: l_index := x_unprocessed_row_tbl.NEXT(l_index);
803: END LOOP;

Line 855: l_exist_in_inv_org_tbl(l_index) := FND_API.g_TRUE;

851: x_items.ship_to_org_id_tbl(l_index));
852: END IF;
853:
854: IF (l_org_id_tbl(i) = PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN
855: l_exist_in_inv_org_tbl(l_index) := FND_API.g_TRUE;
856: x_items.ln_item_id_tbl(l_index) := l_item_id_tbl(i);
857: END IF;
858:
859: IF (l_org_id_tbl(i) = PO_PDOI_PARAMS.g_sys.master_inv_org_id) THEN

Line 860: l_exist_in_master_org_tbl(l_index) := FND_API.g_TRUE;

856: x_items.ln_item_id_tbl(l_index) := l_item_id_tbl(i);
857: END IF;
858:
859: IF (l_org_id_tbl(i) = PO_PDOI_PARAMS.g_sys.master_inv_org_id) THEN
860: l_exist_in_master_org_tbl(l_index) := FND_API.g_TRUE;
861: x_items.ln_item_id_tbl(l_index) := l_item_id_tbl(i);
862: END IF;
863:
864: IF (l_org_id_tbl(i) = x_items.ship_to_org_id_tbl(l_index)) THEN

Line 865: l_exist_in_ship_to_org_tbl(l_index) := FND_API.g_TRUE;

861: x_items.ln_item_id_tbl(l_index) := l_item_id_tbl(i);
862: END IF;
863:
864: IF (l_org_id_tbl(i) = x_items.ship_to_org_id_tbl(l_index)) THEN
865: l_exist_in_ship_to_org_tbl(l_index) := FND_API.g_TRUE;
866: x_items.ln_item_id_tbl(l_index) := l_item_id_tbl(i);
867: END IF;
868: END LOOP;
869:

Line 890: IF (l_exist_in_inv_org_tbl(l_index) = FND_API.g_FALSE OR

886: PO_LOG.stmt(d_module, d_position, 'item_id',
887: x_items.ln_item_id_tbl(l_index));
888: END IF;
889:
890: IF (l_exist_in_inv_org_tbl(l_index) = FND_API.g_FALSE OR
891: l_exist_in_ship_to_org_tbl(l_index) = FND_API.g_FALSE) THEN
892: -- set whether item needs to be created in inv/master org
893: IF (l_exist_in_master_org_tbl(l_index) = FND_API.g_FALSE) THEN
894: x_create_in_master_index_tbl(l_index) := l_index;

Line 891: l_exist_in_ship_to_org_tbl(l_index) = FND_API.g_FALSE) THEN

887: x_items.ln_item_id_tbl(l_index));
888: END IF;
889:
890: IF (l_exist_in_inv_org_tbl(l_index) = FND_API.g_FALSE OR
891: l_exist_in_ship_to_org_tbl(l_index) = FND_API.g_FALSE) THEN
892: -- set whether item needs to be created in inv/master org
893: IF (l_exist_in_master_org_tbl(l_index) = FND_API.g_FALSE) THEN
894: x_create_in_master_index_tbl(l_index) := l_index;
895:

Line 893: IF (l_exist_in_master_org_tbl(l_index) = FND_API.g_FALSE) THEN

889:
890: IF (l_exist_in_inv_org_tbl(l_index) = FND_API.g_FALSE OR
891: l_exist_in_ship_to_org_tbl(l_index) = FND_API.g_FALSE) THEN
892: -- set whether item needs to be created in inv/master org
893: IF (l_exist_in_master_org_tbl(l_index) = FND_API.g_FALSE) THEN
894: x_create_in_master_index_tbl(l_index) := l_index;
895:
896: IF (l_exist_in_inv_org_tbl(l_index) = FND_API.g_FALSE AND
897: PO_PDOI_PARAMS.g_sys.master_inv_org_id <>

Line 896: IF (l_exist_in_inv_org_tbl(l_index) = FND_API.g_FALSE AND

892: -- set whether item needs to be created in inv/master org
893: IF (l_exist_in_master_org_tbl(l_index) = FND_API.g_FALSE) THEN
894: x_create_in_master_index_tbl(l_index) := l_index;
895:
896: IF (l_exist_in_inv_org_tbl(l_index) = FND_API.g_FALSE AND
897: PO_PDOI_PARAMS.g_sys.master_inv_org_id <>
898: PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN
899: x_create_in_inv_index_tbl(l_index) := l_index;
900: END IF;

Line 906: IF (l_exist_in_ship_to_org_tbl(l_index) = FND_API.g_FALSE AND

902:
903: d_position := 50;
904:
905: -- set flag for whether item needs to be created in ship_to org
906: IF (l_exist_in_ship_to_org_tbl(l_index) = FND_API.g_FALSE AND
907: x_items.ship_to_org_id_tbl(l_index) IS NOT NULL AND
908: x_items.ship_to_org_id_tbl(l_index) <> PO_PDOI_PARAMS.g_sys.master_inv_org_id AND
909: x_items.ship_to_org_id_tbl(l_index) <> PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN
910: x_create_in_ship_to_index_tbl(l_index) := l_index;

Line 1363: x_items.error_flag_tbl(l_index) := FND_API.g_TRUE;

1359: p_column_name => l_column_name_tbl(i),
1360: p_column_value => NULL
1361: );
1362:
1363: x_items.error_flag_tbl(l_index) := FND_API.g_TRUE;
1364: END LOOP;
1365:
1366: IF (PO_LOG.d_proc) THEN
1367: PO_LOG.proc_end (d_module);

Line 1505: p_init_msg_list => FND_API.g_TRUE,

1501: LOOP
1502: EGO_ITEM_PUB.Process_Item
1503: (
1504: p_api_version => 1.0,
1505: p_init_msg_list => FND_API.g_TRUE,
1506: p_commit => FND_API.g_TRUE,
1507: p_Transaction_Type => 'UPDATE',
1508: p_Inventory_Item_Id => x_items.ln_item_id_tbl(l_index),
1509: p_Organization_Id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,

Line 1506: p_commit => FND_API.g_TRUE,

1502: EGO_ITEM_PUB.Process_Item
1503: (
1504: p_api_version => 1.0,
1505: p_init_msg_list => FND_API.g_TRUE,
1506: p_commit => FND_API.g_TRUE,
1507: p_Transaction_Type => 'UPDATE',
1508: p_Inventory_Item_Id => x_items.ln_item_id_tbl(l_index),
1509: p_Organization_Id => PO_PDOI_PARAMS.g_sys.def_inv_org_id,
1510: p_description => NVL(x_items.ln_item_desc_tbl(l_index), EGO_ITEM_PUB.G_MISS_CHAR),

Line 1527: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1523: END IF;
1524:
1525: d_position := 50;
1526:
1527: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1528: -- error handling
1529: Error_Handler.GET_MESSAGE_LIST
1530: (
1531: x_message_list => l_message_list

Line 1565: x_items.error_flag_tbl(l_index) := FND_API.g_TRUE;

1561: p_column_value => NULL
1562: );
1563: END LOOP;
1564:
1565: x_items.error_flag_tbl(l_index) := FND_API.g_TRUE;
1566: END IF;
1567:
1568: l_index := l_update_index_tbl.NEXT(l_index);
1569: END LOOP;