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.PO_DELREC_PVT dependencies on FND_LOG

Line 197: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194:
195:
196: x_progress:='000';
197: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Check API Call Compatibility');
199: END IF;
200: -- Standard call to check for call compatibility.
201: IF NOT FND_API.Compatible_API_Call

Line 198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Check API Call Compatibility');

194:
195:
196: x_progress:='000';
197: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
198: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Check API Call Compatibility');
199: END IF;
200: -- Standard call to check for call compatibility.
201: IF NOT FND_API.Compatible_API_Call
202: (

Line 235: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

231: l_action_rec.Caller := 'PO';
232: l_action_rec.Phase := '';
233:
234: x_progress:='010';
235: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
236: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Check action ' || p_action);
237: END IF;
238: IF (p_action IN ('APPROVE_DOCUMENT', 'APPROVE', 'APPROVE AND RESERVE')) THEN
239: l_action_rec.action_code := 'APPROVE_PO';

Line 236: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Check action ' || p_action);

232: l_action_rec.Phase := '';
233:
234: x_progress:='010';
235: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
236: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Check action ' || p_action);
237: END IF;
238: IF (p_action IN ('APPROVE_DOCUMENT', 'APPROVE', 'APPROVE AND RESERVE')) THEN
239: l_action_rec.action_code := 'APPROVE_PO';
240: ELSIF (p_action = 'CANCEL') THEN

Line 277: IF(FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

273: -- : changed exception to log and early
274: -- return. Previously, calls to create_update_delrec were
275: -- filtered for the action, but OTM responds to a different
276: -- set of actions, so the filters have been removed.
277: IF(FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
278: FND_LOG.string(FND_LOG.level_statement, c_log_head || l_api_name,
279: 'Unrecognized command for FTE: ' || p_action ||
280: ', returning.');
281: END IF;

Line 278: FND_LOG.string(FND_LOG.level_statement, c_log_head || l_api_name,

274: -- return. Previously, calls to create_update_delrec were
275: -- filtered for the action, but OTM responds to a different
276: -- set of actions, so the filters have been removed.
277: IF(FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
278: FND_LOG.string(FND_LOG.level_statement, c_log_head || l_api_name,
279: 'Unrecognized command for FTE: ' || p_action ||
280: ', returning.');
281: END IF;
282: RETURN;

Line 289: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

285:
286: -- The following is for query data to create delivery record for:
287: -- Standard PO, Standard PO referencing GA or Contract
288: x_progress:='015';
289: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
290: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Check doc type is ' || p_doc_type || ' doc subtype is ' || p_doc_subtype || '
291: doc id is ' || p_doc_id || ' line id is ' || p_line_id || ' line location id is ' || p_line_location_id );
292: END IF;
293:

Line 290: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Check doc type is ' || p_doc_type || ' doc subtype is ' || p_doc_subtype || '

286: -- The following is for query data to create delivery record for:
287: -- Standard PO, Standard PO referencing GA or Contract
288: x_progress:='015';
289: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
290: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Check doc type is ' || p_doc_type || ' doc subtype is ' || p_doc_subtype || '
291: doc id is ' || p_doc_id || ' line id is ' || p_line_id || ' line location id is ' || p_line_location_id );
292: END IF;
293:
294: /* Bug 7232644: Checking of the value of the shipping control before calling the

Line 314: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

310:
311: --Bug#5009715 We should only call FTE API when Shipping Control is SUPPLIER or BUYER
312: IF (nvl(l_shipping_control,'NONE') = 'NONE') THEN
313: IF g_fnd_debug = 'Y' THEN
314: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
315: FND_LOG.string(
316: log_level => FND_LOG.LEVEL_STATEMENT,
317: module => c_log_head || l_api_name || '.begin',
318: message => 'FTE API is not called because shipping control is set to NULL or NONE'

Line 315: FND_LOG.string(

311: --Bug#5009715 We should only call FTE API when Shipping Control is SUPPLIER or BUYER
312: IF (nvl(l_shipping_control,'NONE') = 'NONE') THEN
313: IF g_fnd_debug = 'Y' THEN
314: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
315: FND_LOG.string(
316: log_level => FND_LOG.LEVEL_STATEMENT,
317: module => c_log_head || l_api_name || '.begin',
318: message => 'FTE API is not called because shipping control is set to NULL or NONE'
319: );

Line 316: log_level => FND_LOG.LEVEL_STATEMENT,

312: IF (nvl(l_shipping_control,'NONE') = 'NONE') THEN
313: IF g_fnd_debug = 'Y' THEN
314: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
315: FND_LOG.string(
316: log_level => FND_LOG.LEVEL_STATEMENT,
317: module => c_log_head || l_api_name || '.begin',
318: message => 'FTE API is not called because shipping control is set to NULL or NONE'
319: );
320: END IF;

Line 404: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

400: -- Bug 3581992 START
401: IF (g_debug_stmt) THEN
402: debug_fte_rec(l_fte_rec); -- Log the contents of l_fte_rec.
403: END IF;
404: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
405: -- Bug 3581992 END
406:
407: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Call WSH_BULK_PROCESS_GRP.create_update_delivery_details');
408: END IF;

Line 407: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Call WSH_BULK_PROCESS_GRP.create_update_delivery_details');

403: END IF;
404: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
405: -- Bug 3581992 END
406:
407: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Call WSH_BULK_PROCESS_GRP.create_update_delivery_details');
408: END IF;
409:
410: -- Bug 3602512 START
411: -- Do not call the FTE API if we do not have any records in l_fte_rec.

Line 500: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

496: -- Bug 3581992 START
497: IF (g_debug_stmt) THEN
498: debug_fte_rec(l_fte_rec); -- Log the contents of l_fte_rec.
499: END IF;
500: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
501: -- Bug 3581992 END
502:
503: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Call WSH_BULK_PROCESS_GRP.create_update_delivery_details');
504: END IF;

Line 503: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Call WSH_BULK_PROCESS_GRP.create_update_delivery_details');

499: END IF;
500: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
501: -- Bug 3581992 END
502:
503: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name ||'.begin', 'Call WSH_BULK_PROCESS_GRP.create_update_delivery_details');
504: END IF;
505:
506: -- Bug 3602512 START
507: -- Do not call the FTE API if we do not have any records in l_fte_rec.

Line 549: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

545: WHEN FND_API.G_EXC_ERROR THEN
546: ROLLBACK TO create_update_delrec;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: IF g_fnd_debug = 'Y' THEN
549: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
550: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||x_msg_data);
551: END IF;
552: END IF;
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 550: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||x_msg_data);

546: ROLLBACK TO create_update_delrec;
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: IF g_fnd_debug = 'Y' THEN
549: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
550: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||x_msg_data);
551: END IF;
552: END IF;
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: ROLLBACK TO create_update_delrec;

Line 557: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: ROLLBACK TO create_update_delrec;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: IF g_fnd_debug = 'Y' THEN
557: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
558: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||sqlcode);
559: END IF;
560: END IF;
561: WHEN OTHERS THEN

Line 558: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||sqlcode);

554: ROLLBACK TO create_update_delrec;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: IF g_fnd_debug = 'Y' THEN
557: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
558: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||sqlcode);
559: END IF;
560: END IF;
561: WHEN OTHERS THEN
562: ROLLBACK TO create_update_delrec;

Line 565: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN

561: WHEN OTHERS THEN
562: ROLLBACK TO create_update_delrec;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF g_fnd_debug = 'Y' THEN
565: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
566: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||sqlcode);
567: END IF;
568: END IF;
569: END;

Line 566: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||sqlcode);

562: ROLLBACK TO create_update_delrec;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF g_fnd_debug = 'Y' THEN
565: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) THEN
566: FND_LOG.string(FND_LOG.LEVEL_EXCEPTION,c_log_head || l_api_name ||'.EXCEPTION', 'Exception :'||x_progress||sqlcode);
567: END IF;
568: END IF;
569: END;
570:

Line 656: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

652: (p_action = 'MATCH')
653: THEN
654: l_transaction_type := 'MATCH';
655: END IF;
656: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
657: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', 'In make_rcv_call');
658: END IF;
659: -- INSERT INTO ben_test VALUES ('GOT HERE', SYSDATE);
660: IF (p_line_id IS NULL) THEN

Line 657: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', 'In make_rcv_call');

653: THEN
654: l_transaction_type := 'MATCH';
655: END IF;
656: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
657: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', 'In make_rcv_call');
658: END IF;
659: -- INSERT INTO ben_test VALUES ('GOT HERE', SYSDATE);
660: IF (p_line_id IS NULL) THEN
661: -- IF (1 = 1) THEN

Line 1215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1211: AND rsh.ship_to_org_id = orf2.organization_id (+)
1212: AND (orf2.language = USERENV('LANG') OR orf2.language IS NULL);
1213:
1214: END IF;
1215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1216: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', 'After Queries, rows= ' || x_fte_rec.source_code.LAST);
1217: END IF;
1218: -- INSERT INTO ben_test VALUES ('GOT HERE TOO', SYSDATE);
1219: p_action_rec.ship_from_location_id := rcv_table_functions.get_rsh_row_from_id(p_header_id).ship_from_location_id;

Line 1216: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', 'After Queries, rows= ' || x_fte_rec.source_code.LAST);

1212: AND (orf2.language = USERENV('LANG') OR orf2.language IS NULL);
1213:
1214: END IF;
1215: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1216: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', 'After Queries, rows= ' || x_fte_rec.source_code.LAST);
1217: END IF;
1218: -- INSERT INTO ben_test VALUES ('GOT HERE TOO', SYSDATE);
1219: p_action_rec.ship_from_location_id := rcv_table_functions.get_rsh_row_from_id(p_header_id).ship_from_location_id;
1220:

Line 1233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1229: x_return_status => x_return_status,
1230: x_msg_count => l_msg_count,
1231: x_msg_data => l_msg_data
1232: );
1233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1234: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', 'RS: ' || x_return_status || ' x_msg_data: ' || l_msg_data);
1235: END IF;
1236: --INSERT INTO ben_test VALUES ('RS: ' || x_return_status || ' x_msg_data: ' || l_msg_data, SYSDATE);
1237: EXCEPTION

Line 1234: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', 'RS: ' || x_return_status || ' x_msg_data: ' || l_msg_data);

1230: x_msg_count => l_msg_count,
1231: x_msg_data => l_msg_data
1232: );
1233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1234: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', 'RS: ' || x_return_status || ' x_msg_data: ' || l_msg_data);
1235: END IF;
1236: --INSERT INTO ben_test VALUES ('RS: ' || x_return_status || ' x_msg_data: ' || l_msg_data, SYSDATE);
1237: EXCEPTION
1238: WHEN NO_DATA_FOUND THEN

Line 1243: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1239: NULL;
1240: WHEN OTHERS THEN
1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1242: l_msg_data := 'Errm ' || sqlerrm;
1243: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1244: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', l_msg_data);
1245: END IF;
1246: -- INSERT INTO ben_test VALUES (l_msg_data, SYSDATE);
1247: RAISE;

Line 1244: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', l_msg_data);

1240: WHEN OTHERS THEN
1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1242: l_msg_data := 'Errm ' || sqlerrm;
1243: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1244: FND_LOG.string (FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name || '.begin', l_msg_data);
1245: END IF;
1246: -- INSERT INTO ben_test VALUES (l_msg_data, SYSDATE);
1247: RAISE;
1248:

Line 3500: -- FND log

3496: --Name: debug_fte_rec
3497: --Pre-reqs:
3498: -- None.
3499: --Modifies:
3500: -- FND log
3501: --Locks:
3502: -- None.
3503: --Function:
3504: -- Prints out some attributes of the FTE record to the FND log for debugging

Line 3504: -- Prints out some attributes of the FTE record to the FND log for debugging

3500: -- FND log
3501: --Locks:
3502: -- None.
3503: --Function:
3504: -- Prints out some attributes of the FTE record to the FND log for debugging
3505: -- purposes.
3506: --Parameters:
3507: --IN:
3508: --p_fte_rec