APPS.CSP_RECEIVE_PVT dependencies on FND_LOG

Line 346: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

342:
343: -- bug # 10425434
344: -- change context to operating unit where you want to receive the part
345:
346: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
348: 'Trying to get org_id for p_receive_hdr_rec.receipt_header_id = '
349: || p_receive_hdr_rec.receipt_header_id);
350: end if;

Line 347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

343: -- bug # 10425434
344: -- change context to operating unit where you want to receive the part
345:
346: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
348: 'Trying to get org_id for p_receive_hdr_rec.receipt_header_id = '
349: || p_receive_hdr_rec.receipt_header_id);
350: end if;
351:

Line 362: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

358: AND rownum = 1;
359:
360: l_org_org_id := mo_global.get_current_org_id;
361:
362: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
364: 'l_org_id = ' || l_org_id);
365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
366: 'l_org_org_id = ' || l_org_org_id);

Line 363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

359:
360: l_org_org_id := mo_global.get_current_org_id;
361:
362: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
364: 'l_org_id = ' || l_org_id);
365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
366: 'l_org_org_id = ' || l_org_org_id);
367: end if;

Line 365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

361:
362: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
364: 'l_org_id = ' || l_org_id);
365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
366: 'l_org_org_id = ' || l_org_org_id);
367: end if;
368:
369: if l_org_org_id is null then

Line 374: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

370: po_moac_utils_pvt.INITIALIZE;
371: l_org_org_id := mo_global.get_current_org_id;
372: end if;
373:
374: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
376: 'l_org_id = ' || l_org_id);
377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
378: 'l_org_org_id = ' || l_org_org_id);

Line 375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

371: l_org_org_id := mo_global.get_current_org_id;
372: end if;
373:
374: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
376: 'l_org_id = ' || l_org_id);
377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
378: 'l_org_org_id = ' || l_org_org_id);
379: end if;

Line 377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

373:
374: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
375: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
376: 'l_org_id = ' || l_org_id);
377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
378: 'l_org_org_id = ' || l_org_org_id);
379: end if;
380:
381: if l_org_id <> nvl(l_org_org_id, -999) and l_org_id is not null then

Line 382: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

378: 'l_org_org_id = ' || l_org_org_id);
379: end if;
380:
381: if l_org_id <> nvl(l_org_org_id, -999) and l_org_id is not null then
382: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
383: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
384: 'changing context to l_org_id = ' || l_org_id);
385: end if;
386: po_moac_utils_pvt.set_org_context(l_org_id);

Line 383: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

379: end if;
380:
381: if l_org_id <> nvl(l_org_org_id, -999) and l_org_id is not null then
382: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
383: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
384: 'changing context to l_org_id = ' || l_org_id);
385: end if;
386: po_moac_utils_pvt.set_org_context(l_org_id);
387: end if;

Line 422: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: End If;
420:
421: -- bug # 10401140
422: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
424: 'p_receive_hdr_rec.receipt_num = ' || p_receive_hdr_rec.receipt_num);
425: end if;
426:

Line 423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

419: End If;
420:
421: -- bug # 10401140
422: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
423: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
424: 'p_receive_hdr_rec.receipt_num = ' || p_receive_hdr_rec.receipt_num);
425: end if;
426:
427: if p_receive_hdr_rec.receipt_num is null then

Line 436: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

432: else
433: l_rcpt_num := p_receive_hdr_rec.receipt_num;
434: end if;
435:
436: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
437: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
438: 'l_rcpt_num = ' || l_rcpt_num);
439: end if;
440:

Line 437: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

433: l_rcpt_num := p_receive_hdr_rec.receipt_num;
434: end if;
435:
436: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
437: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
438: 'l_rcpt_num = ' || l_rcpt_num);
439: end if;
440:
441: --

Line 576: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

572: End If;
573: --- Commit;
574:
575: if l_org_id <> l_org_org_id then
576: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
578: 'changing context to l_org_org_id = ' || l_org_org_id);
579: end if;
580: po_moac_utils_pvt.set_org_context(l_org_org_id);

Line 577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

573: --- Commit;
574:
575: if l_org_id <> l_org_org_id then
576: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
578: 'changing context to l_org_org_id = ' || l_org_org_id);
579: end if;
580: po_moac_utils_pvt.set_org_context(l_org_org_id);
581: end if;

Line 596: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

592: ,X_MSG_DATA => X_MESSAGE
593: ,X_RETURN_STATUS => X_RETURN_STATUS);
594:
595: if l_org_id <> l_org_org_id then
596: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
597: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
598: 'changing context to l_org_org_id = ' || l_org_org_id);
599: end if;
600: po_moac_utils_pvt.set_org_context(l_org_org_id);

Line 597: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

593: ,X_RETURN_STATUS => X_RETURN_STATUS);
594:
595: if l_org_id <> l_org_org_id then
596: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
597: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
598: 'changing context to l_org_org_id = ' || l_org_org_id);
599: end if;
600: po_moac_utils_pvt.set_org_context(l_org_org_id);
601: end if;

Line 614: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

610: ,X_MSG_DATA => X_MESSAGE
611: ,X_RETURN_STATUS => X_RETURN_STATUS);
612:
613: if l_org_id <> l_org_org_id then
614: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
615: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
616: 'changing context to l_org_org_id = ' || l_org_org_id);
617: end if;
618: po_moac_utils_pvt.set_org_context(l_org_org_id);

Line 615: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

611: ,X_RETURN_STATUS => X_RETURN_STATUS);
612:
613: if l_org_id <> l_org_org_id then
614: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
615: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
616: 'changing context to l_org_org_id = ' || l_org_org_id);
617: end if;
618: po_moac_utils_pvt.set_org_context(l_org_org_id);
619: end if;

Line 637: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

633: ,X_MSG_DATA => X_MESSAGE
634: ,X_RETURN_STATUS => X_RETURN_STATUS);
635:
636: if l_org_id <> l_org_org_id then
637: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
638: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
639: 'changing context to l_org_org_id = ' || l_org_org_id);
640: end if;
641: po_moac_utils_pvt.set_org_context(l_org_org_id);

Line 638: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

634: ,X_RETURN_STATUS => X_RETURN_STATUS);
635:
636: if l_org_id <> l_org_org_id then
637: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
638: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
639: 'changing context to l_org_org_id = ' || l_org_org_id);
640: end if;
641: po_moac_utils_pvt.set_org_context(l_org_org_id);
642: end if;

Line 2237: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2233:
2234: l_module_name varchar2(100) := 'csp.plsql.csp_receive_pvt.rcv_online_request';
2235: BEGIN
2236:
2237: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2238: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2239: 'Begin for p_group_id = ' || p_group_id);
2240: end if;
2241:

Line 2238: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

2234: l_module_name varchar2(100) := 'csp.plsql.csp_receive_pvt.rcv_online_request';
2235: BEGIN
2236:
2237: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2238: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2239: 'Begin for p_group_id = ' || p_group_id);
2240: end if;
2241:
2242: x_return_status := fnd_api.g_ret_sts_success;

Line 2252: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2248: NULL, NULL, NULL, NULL, NULL, NULL,
2249: NULL, NULL, NULL, NULL, NULL, NULL,
2250: NULL, NULL, NULL, NULL, NULL, NULL);
2251:
2252: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2253: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2254: 'rc = ' || rc);
2255: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2256: 'l_outcome = ' || l_outcome);

Line 2253: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

2249: NULL, NULL, NULL, NULL, NULL, NULL,
2250: NULL, NULL, NULL, NULL, NULL, NULL);
2251:
2252: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2253: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2254: 'rc = ' || rc);
2255: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2256: 'l_outcome = ' || l_outcome);
2257: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 2255: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

2251:
2252: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2253: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2254: 'rc = ' || rc);
2255: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2256: 'l_outcome = ' || l_outcome);
2257: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2258: 'l_message = ' || l_message);
2259: end if;

Line 2257: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

2253: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2254: 'rc = ' || rc);
2255: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2256: 'l_outcome = ' || l_outcome);
2257: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2258: 'l_message = ' || l_message);
2259: end if;
2260:
2261: IF (rc = 1) THEN

Line 2283: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2279: select ERROR_MESSAGE INTO po_message
2280: from po_interface_errors
2281: where BATCH_ID = p_group_id;
2282:
2283: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2284: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2285: 'po_message = ' || po_message);
2286: end if;
2287:

Line 2284: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

2280: from po_interface_errors
2281: where BATCH_ID = p_group_id;
2282:
2283: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2284: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2285: 'po_message = ' || po_message);
2286: end if;
2287:
2288: FND_MESSAGE.set_name('CSP', 'CSP_ATP');

Line 2361: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2357: IF (r_val20 IS NOT NULL) THEN
2358: x_str := x_str || ' ' || r_val20;
2359: END IF;
2360:
2361: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2363: 'x_str = ' || x_str);
2364: end if;
2365:

Line 2362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

2358: x_str := x_str || ' ' || r_val20;
2359: END IF;
2360:
2361: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2362: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
2363: 'x_str = ' || x_str);
2364: end if;
2365:
2366: if l_message is not null then