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.OE_BULK_ORDER_IMPORT_PVT dependencies on FND_API

Line 56: x_return_status := FND_API.G_RET_STS_SUCCESS;

52: l_start_time NUMBER;
53: l_end_time NUMBER;
54: BEGIN
55:
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
58: ------------------------------------------------------------
59: -- Initialize Request level globals/variables, these will be
60: -- used in the batch processing APIs later.

Line 116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

112: OE_BULK_MSG_PUB.Add_Exc_Msg
113: ( G_PKG_NAME
114: , 'Initialize_Request'
115: );
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117: END Initialize_Request;
118:
119: PROCEDURE Initialize_Batch
120: ( x_return_status OUT NOCOPY VARCHAR2

Line 129: x_return_status := FND_API.G_RET_STS_SUCCESS;

125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
126: --
127: BEGIN
128:
129: x_return_status := FND_API.G_RET_STS_SUCCESS;
130:
131: ------------------------------------------------------------
132: -- Initialize Org Level globals/variables
133: -- used in the batch processing APIs later.

Line 182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

178: OE_BULK_MSG_PUB.Add_Exc_Msg
179: ( G_PKG_NAME
180: , 'Initialize_Batch'
181: );
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: END Initialize_Batch;
184:
185:
186: PROCEDURE Post_Process

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

189: , x_return_status OUT NOCOPY VARCHAR
190: )IS
191: BEGIN
192:
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194:
195: -- No need to delete records if it is validation only mode
196:
197: if p_validate_only = 'Y' then

Line 312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

308: OE_BULK_MSG_PUB.Add_Exc_Msg
309: ( G_PKG_NAME
310: , 'Post_Process'
311: );
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: END Post_Process;
314:
315:
316: ---------------------------------------------------------------------

Line 344: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;

340: , p_validate_configurations IN VARCHAR2 DEFAULT 'Y'
341: , p_schedule_configurations IN VARCHAR2 DEFAULT 'N'
342: )
343: IS
344: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
345: l_change_sequence VARCHAR2(50);
346: l_order_source_id NUMBER;
347: l_orig_sys_document_ref VARCHAR2(50);
348: l_orig_sys_line_ref VARCHAR2(50);

Line 465: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)

461: AND nvl(h.force_apply_flag,'Y') = 'Y'
462: AND h.orig_sys_document_ref = l.orig_sys_document_ref(+)
463: AND h.order_source_id = l.order_source_id(+)
464: AND h.org_id = l.org_id(+)
465: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)
466: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)
467: AND nvl(l.error_flag(+),'N') = 'N'
468: AND nvl(l.rejected_flag(+),'N') = 'N'
469: AND nvl (h.payment_type_code, ' ') <> 'CREDIT_CARD'

Line 466: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)

462: AND h.orig_sys_document_ref = l.orig_sys_document_ref(+)
463: AND h.order_source_id = l.order_source_id(+)
464: AND h.org_id = l.org_id(+)
465: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)
466: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)
467: AND nvl(l.error_flag(+),'N') = 'N'
468: AND nvl(l.rejected_flag(+),'N') = 'N'
469: AND nvl (h.payment_type_code, ' ') <> 'CREDIT_CARD'
470: AND nvl(h.order_source_id,0) <> 10

Line 541: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)

537: AND h.orig_sys_document_ref = l.orig_sys_document_ref(+)
538: AND h.order_source_id = l.order_source_id(+)
539: AND h.org_id IS NOT NULL
540: AND h.org_id = l.org_id(+)
541: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)
542: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)
543: AND nvl(l.error_flag(+),'N') = 'N'
544: AND nvl(l.rejected_flag(+),'N') = 'N'
545: AND h.org_id = nvl(p_operating_unit,h.org_id)

Line 542: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)

538: AND h.order_source_id = l.order_source_id(+)
539: AND h.org_id IS NOT NULL
540: AND h.org_id = l.org_id(+)
541: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)
542: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)
543: AND nvl(l.error_flag(+),'N') = 'N'
544: AND nvl(l.rejected_flag(+),'N') = 'N'
545: AND h.org_id = nvl(p_operating_unit,h.org_id)
546: -- Do not process orders with manual sales credits, manual

Line 594: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)

590: AND nvl(h.force_apply_flag,'Y') = 'Y'
591: AND h.orig_sys_document_ref = l.orig_sys_document_ref(+)
592: AND h.order_source_id = l.order_source_id(+)
593: AND nvl(h.org_id, l_default_org_id) = nvl(l.org_id(+), l_default_org_id)
594: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)
595: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)
596: AND nvl(l.error_flag(+),'N') = 'N'
597: AND nvl(l.rejected_flag(+),'N') = 'N'
598: AND (h.org_id is NULL AND

Line 595: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)

591: AND h.orig_sys_document_ref = l.orig_sys_document_ref(+)
592: AND h.order_source_id = l.order_source_id(+)
593: AND nvl(h.org_id, l_default_org_id) = nvl(l.org_id(+), l_default_org_id)
594: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)
595: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)
596: AND nvl(l.error_flag(+),'N') = 'N'
597: AND nvl(l.rejected_flag(+),'N') = 'N'
598: AND (h.org_id is NULL AND
599: l_default_org_id = nvl(p_operating_unit,l_default_org_id))

Line 1311: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1307: , p_rtrim_data => p_rtrim_data -- 3390458
1308: , x_return_status => l_return_status
1309: );
1310:
1311: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1312: retcode := 2;
1313: errbuf := 'Please check the log file for error messages';
1314: RETURN;
1315: END IF;

Line 1345: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1341: Initialize_Batch
1342: ( x_return_status => l_return_status
1343: );
1344:
1345: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1346: retcode := 2;
1347: errbuf := 'Please check the log file for error messages';
1348: RETURN;
1349: END IF;

Line 1395: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1391: OE_MSG_PUB.Save_Messages(OE_Bulk_Order_PVT.G_REQUEST_ID);
1392:
1393:
1394: -- Process_Batch will only return unexp error or success result
1395: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1396:
1397: UPDATE oe_headers_iface_all
1398: SET error_flag = 'Y'
1399: WHERE batch_id = l_batch_id;