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.

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 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

234: OE_BULK_MSG_PUB.Add_Exc_Msg
235: ( G_PKG_NAME
236: , 'Post_Process'
237: );
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: END Post_Process;
240:
241:
242: ---------------------------------------------------------------------

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

266: , p_validate_configurations IN VARCHAR2 DEFAULT 'Y'
267: , p_schedule_configurations IN VARCHAR2 DEFAULT 'N'
268: )
269: IS
270: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
271: l_change_sequence VARCHAR2(50);
272: l_order_source_id NUMBER;
273: l_orig_sys_document_ref VARCHAR2(50);
274: l_orig_sys_line_ref VARCHAR2(50);

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

367: AND nvl(h.force_apply_flag,'Y') = 'Y'
368: AND h.orig_sys_document_ref = l.orig_sys_document_ref(+)
369: AND h.order_source_id = l.order_source_id(+)
370: AND h.org_id = l.org_id(+)
371: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)
372: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)
373: AND nvl(l.error_flag(+),'N') = 'N'
374: AND nvl(l.rejected_flag(+),'N') = 'N'
375: AND nvl (h.payment_type_code, ' ') <> 'CREDIT_CARD'

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

368: AND h.orig_sys_document_ref = l.orig_sys_document_ref(+)
369: AND h.order_source_id = l.order_source_id(+)
370: AND h.org_id = l.org_id(+)
371: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)
372: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)
373: AND nvl(l.error_flag(+),'N') = 'N'
374: AND nvl(l.rejected_flag(+),'N') = 'N'
375: AND nvl (h.payment_type_code, ' ') <> 'CREDIT_CARD'
376: AND nvl(h.order_source_id,0) <> 10

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

443: AND h.orig_sys_document_ref = l.orig_sys_document_ref(+)
444: AND h.order_source_id = l.order_source_id(+)
445: AND h.org_id IS NOT NULL
446: AND h.org_id = l.org_id(+)
447: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)
448: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)
449: AND nvl(l.error_flag(+),'N') = 'N'
450: AND nvl(l.rejected_flag(+),'N') = 'N'
451: AND h.org_id = nvl(p_operating_unit,h.org_id)

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

444: AND h.order_source_id = l.order_source_id(+)
445: AND h.org_id IS NOT NULL
446: AND h.org_id = l.org_id(+)
447: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)
448: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)
449: AND nvl(l.error_flag(+),'N') = 'N'
450: AND nvl(l.rejected_flag(+),'N') = 'N'
451: AND h.org_id = nvl(p_operating_unit,h.org_id)
452: -- Do not process orders with manual sales credits, manual

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

496: AND nvl(h.force_apply_flag,'Y') = 'Y'
497: AND h.orig_sys_document_ref = l.orig_sys_document_ref(+)
498: AND h.order_source_id = l.order_source_id(+)
499: AND nvl(h.org_id, l_default_org_id) = nvl(l.org_id(+), l_default_org_id)
500: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)
501: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)
502: AND nvl(l.error_flag(+),'N') = 'N'
503: AND nvl(l.rejected_flag(+),'N') = 'N'
504: AND (h.org_id is NULL AND

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

497: AND h.orig_sys_document_ref = l.orig_sys_document_ref(+)
498: AND h.order_source_id = l.order_source_id(+)
499: AND nvl(h.org_id, l_default_org_id) = nvl(l.org_id(+), l_default_org_id)
500: AND nvl(h.change_sequence, FND_API.G_MISS_CHAR)
501: = nvl(l.change_sequence(+), FND_API.G_MISS_CHAR)
502: AND nvl(l.error_flag(+),'N') = 'N'
503: AND nvl(l.rejected_flag(+),'N') = 'N'
504: AND (h.org_id is NULL AND
505: l_default_org_id = nvl(p_operating_unit,l_default_org_id))

Line 1216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1212: , p_rtrim_data => p_rtrim_data -- 3390458
1213: , x_return_status => l_return_status
1214: );
1215:
1216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1217: retcode := 2;
1218: errbuf := 'Please check the log file for error messages';
1219: RETURN;
1220: END IF;

Line 1250: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1246: Initialize_Batch
1247: ( x_return_status => l_return_status
1248: );
1249:
1250: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1251: retcode := 2;
1252: errbuf := 'Please check the log file for error messages';
1253: RETURN;
1254: END IF;

Line 1300: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1296: OE_MSG_PUB.Save_Messages(OE_Bulk_Order_PVT.G_REQUEST_ID);
1297:
1298:
1299: -- Process_Batch will only return unexp error or success result
1300: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1301:
1302: UPDATE oe_headers_iface_all
1303: SET error_flag = 'Y'
1304: WHERE batch_id = l_batch_id;