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

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

1203: SELECT Sysdate INTO l_today FROM dual;
1204: l_user_id := fnd_global.user_id;
1205: l_login_id := fnd_global.login_id;
1206:
1207: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1209: 'csp.plsql.csp_parts_requirement.csptrreq_order_res',
1210: 'l_header_rec.address_type = ' || l_header_rec.address_type
1211: || ', l_header_rec.incident_id = ' || l_header_rec.incident_id

Line 1208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1204: l_user_id := fnd_global.user_id;
1205: l_login_id := fnd_global.login_id;
1206:
1207: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1209: 'csp.plsql.csp_parts_requirement.csptrreq_order_res',
1210: 'l_header_rec.address_type = ' || l_header_rec.address_type
1211: || ', l_header_rec.incident_id = ' || l_header_rec.incident_id
1212: || ', l_header_rec.task_id = ' || l_header_rec.task_id

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

1229: open get_party_details(l_header_Rec.incident_id,l_header_Rec.ship_to_location_id) ;
1230: FETCH get_party_details INTO l_party_site_id,l_customer_id,l_cust_account_id, l_org_id;
1231: CLOSE get_party_details;
1232:
1233: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1235: 'csp.plsql.csp_parts_requirement.csptrreq_order_res',
1236: 'l_party_site_id = ' || l_party_site_id
1237: || ', l_customer_id = ' || l_customer_id

Line 1234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1230: FETCH get_party_details INTO l_party_site_id,l_customer_id,l_cust_account_id, l_org_id;
1231: CLOSE get_party_details;
1232:
1233: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1235: 'csp.plsql.csp_parts_requirement.csptrreq_order_res',
1236: 'l_party_site_id = ' || l_party_site_id
1237: || ', l_customer_id = ' || l_customer_id
1238: || ', l_cust_account_id = ' || l_cust_account_id

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

1272: ,x_return_status => l_return_status
1273: ,x_msg_count => l_msg_count
1274: ,x_msg_data => l_msg_data);
1275:
1276: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1277: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1278: 'csp.plsql.csp_parts_requirement.csptrreq_order_res',
1279: 'l_return_status = ' || l_return_status);
1280: end if;

Line 1277: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1273: ,x_msg_count => l_msg_count
1274: ,x_msg_data => l_msg_data);
1275:
1276: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1277: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1278: 'csp.plsql.csp_parts_requirement.csptrreq_order_res',
1279: 'l_return_status = ' || l_return_status);
1280: end if;
1281:

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

2412: FOR UPDATE of c.order_line_id NOWAIT;
2413:
2414: BEGIN
2415:
2416: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2417: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2418: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2419: 'Begin');
2420: end if;

Line 2417: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2413:
2414: BEGIN
2415:
2416: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2417: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2418: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2419: 'Begin');
2420: end if;
2421:

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

2442: SELECT Sysdate INTO l_today FROM dual;
2443: l_user_id := fnd_global.user_id;
2444: l_login_id := fnd_global.login_id;
2445:
2446: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2447: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2448: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2449: 'l_user_id = ' || l_user_id
2450: || ', l_login_id = ' || l_login_id);

Line 2447: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2443: l_user_id := fnd_global.user_id;
2444: l_login_id := fnd_global.login_id;
2445:
2446: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2447: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2448: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2449: 'l_user_id = ' || l_user_id
2450: || ', l_login_id = ' || l_login_id);
2451: end if;

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

2458: where crld.requirement_line_id(+) = crl.requirement_line_id
2459: and crl.requirement_header_id = p_header_id
2460: and crld.source_id is null;
2461:
2462: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2463: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2464: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2465: 'p_header_id is NOT NULL and number of lines for this requirement is = ' || l_count);
2466: end if;

Line 2463: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2459: and crl.requirement_header_id = p_header_id
2460: and crld.source_id is null;
2461:
2462: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2463: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2464: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2465: 'p_header_id is NOT NULL and number of lines for this requirement is = ' || l_count);
2466: end if;
2467:

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

2485: WHERE requirement_header_id = p_header_id;
2486:
2487: l_header_Rec.operation := G_OPR_CREATE;
2488:
2489: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2490: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2491: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2492: 'Part Req Header Data... '
2493: || 'l_header_rec.requirement_header_id = ' || l_header_rec.requirement_header_id

Line 2490: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2486:
2487: l_header_Rec.operation := G_OPR_CREATE;
2488:
2489: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2490: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2491: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2492: 'Part Req Header Data... '
2493: || 'l_header_rec.requirement_header_id = ' || l_header_rec.requirement_header_id
2494: || ', l_header_rec.order_type_id = ' || l_header_rec.order_type_id

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

2522: l_line_rec.source_subinventory,
2523: l_line_rec.shipping_method_code,
2524: l_line_rec.arrival_Date ;
2525:
2526: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2528: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2529: 'Part Req Line Data... '
2530: || 'l_line_rec.requirement_line_id = ' || l_line_rec.requirement_line_id

Line 2527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2523: l_line_rec.shipping_method_code,
2524: l_line_rec.arrival_Date ;
2525:
2526: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2528: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2529: 'Part Req Line Data... '
2530: || 'l_line_rec.requirement_line_id = ' || l_line_rec.requirement_line_id
2531: || ', l_line_rec.inventory_item_id = ' || l_line_rec.inventory_item_id

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

2557: END IF;
2558: END LOOP;
2559:
2560: IF (l_oe_line_tbl.COUNT > 0) THEN
2561: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2562: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2563: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2564: 'Calling csp_parts_order.process_order...');
2565: end if;

Line 2562: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2558: END LOOP;
2559:
2560: IF (l_oe_line_tbl.COUNT > 0) THEN
2561: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2562: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2563: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2564: 'Calling csp_parts_order.process_order...');
2565: end if;
2566: csp_parts_order.process_order(

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

2572: ,x_return_status => l_return_status
2573: ,x_msg_count => l_msg_count
2574: ,x_msg_data => l_msg_data
2575: );
2576: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2578: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2579: 'csp_parts_order.process_order return status = ' || l_return_status);
2580: end if;

Line 2577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2573: ,x_msg_count => l_msg_count
2574: ,x_msg_data => l_msg_data
2575: );
2576: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2578: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2579: 'csp_parts_order.process_order return status = ' || l_return_status);
2580: end if;
2581:

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

2598: INTO l_order_number
2599: FROM OE_ORDER_HEADERS_ALL
2600: WHERE header_id = l_header_Rec.order_header_id;
2601:
2602: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2603: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2604: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2605: 'l_order_number = ' || l_order_number);
2606: end if;

Line 2603: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2599: FROM OE_ORDER_HEADERS_ALL
2600: WHERE header_id = l_header_Rec.order_header_id;
2601:
2602: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2603: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2604: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2605: 'l_order_number = ' || l_order_number);
2606: end if;
2607: EXCEPTION

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

2605: 'l_order_number = ' || l_order_number);
2606: end if;
2607: EXCEPTION
2608: when no_data_found then
2609: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2610: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2611: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2612: 'No Data Found for l_header_rec.order_header_id = '
2613: || l_header_rec.order_header_id || ' in OE_ORDER_HEADERS_ALL');

Line 2610: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2606: end if;
2607: EXCEPTION
2608: when no_data_found then
2609: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2610: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2611: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2612: 'No Data Found for l_header_rec.order_header_id = '
2613: || l_header_rec.order_header_id || ' in OE_ORDER_HEADERS_ALL');
2614: end if;

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

2699: IF fnd_api.to_boolean(p_commit) THEN
2700: commit work;
2701: END IF;
2702: END If;
2703: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2705: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2706: 'Returning from csp.plsql.CSP_PARTS_REQUIREMENT.create_order with return status = '
2707: || x_return_status);

Line 2704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2700: commit work;
2701: END IF;
2702: END If;
2703: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2705: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2706: 'Returning from csp.plsql.CSP_PARTS_REQUIREMENT.create_order with return status = '
2707: || x_return_status);
2708: end if;

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

2903: WHERE d.requirement_line_id = l.requirement_line_id) = 0;
2904:
2905: BEGIN
2906:
2907: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2908: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Begin');
2909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
2910: 'l_task_assignment_id = ' || l_task_assignment_id
2911: || ', l_resource_id = ' || l_resource_id

Line 2908: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Begin');

2904:
2905: BEGIN
2906:
2907: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2908: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Begin');
2909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
2910: 'l_task_assignment_id = ' || l_task_assignment_id
2911: || ', l_resource_id = ' || l_resource_id
2912: || ', l_resource_type_code = ' || l_resource_type_code

Line 2909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

2905: BEGIN
2906:
2907: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2908: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Begin');
2909: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
2910: 'l_task_assignment_id = ' || l_task_assignment_id
2911: || ', l_resource_id = ' || l_resource_id
2912: || ', l_resource_type_code = ' || l_resource_type_code
2913: || ', l_rqmt_header_id = ' || l_rqmt_header_id

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

2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;
2926:
2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
2929: 'l_task_assignment_id = ' || l_task_assignment_id
2930: || ', l_task_id =' || l_task_id
2931: || ', l_resource_id = ' || l_resource_id

Line 2928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;
2926:
2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
2929: 'l_task_assignment_id = ' || l_task_assignment_id
2930: || ', l_task_id =' || l_task_id
2931: || ', l_resource_id = ' || l_resource_id
2932: || ', l_resource_type_code = ' || l_resource_type_code

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

2943: WHERE h.task_id = l_task_id
2944: AND h.task_assignment_id = l_task_assignment_id
2945: AND h.requirement_header_id = l.requirement_header_id;
2946:
2947: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2948: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
2949: 'l_oth_req_line = ' || l_oth_req_line);
2950: end if;
2951:

Line 2948: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

2944: AND h.task_assignment_id = l_task_assignment_id
2945: AND h.requirement_header_id = l.requirement_header_id;
2946:
2947: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2948: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
2949: 'l_oth_req_line = ' || l_oth_req_line);
2950: end if;
2951:
2952: if l_oth_req_line = 0 then

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

2956: if l_assignee_role = 'ASSIGNEE' then
2957: IF (l_Resource_id is not null and G_old_resource_id is not null and
2958: l_Resource_id <> G_old_resource_id)THEN
2959:
2960: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2961: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
2962: 'checking for re-assignment case...');
2963: end if;
2964:

Line 2961: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

2957: IF (l_Resource_id is not null and G_old_resource_id is not null and
2958: l_Resource_id <> G_old_resource_id)THEN
2959:
2960: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2961: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
2962: 'checking for re-assignment case...');
2963: end if;
2964:
2965: OPEN get_Resource_org_sub;

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

3093: l_sch_option.resource_type := l_resource_type_code;
3094: l_sch_option.start_time := l_booking_start_date;
3095: l_sch_option.transfer_cost := 9999999; --- this should be a high number to avoid cost check in choose option
3096:
3097: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3099: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3100: 'before calling CSP_SCH_INT_PVT.CHOOSE_OPTION...');
3101: end if;

Line 3098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3094: l_sch_option.start_time := l_booking_start_date;
3095: l_sch_option.transfer_cost := 9999999; --- this should be a high number to avoid cost check in choose option
3096:
3097: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3099: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3100: 'before calling CSP_SCH_INT_PVT.CHOOSE_OPTION...');
3101: end if;
3102: CSP_SCH_INT_PVT.CHOOSE_OPTION(

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

3111: x_return_status => x_return_status,
3112: x_msg_data => x_msg_data,
3113: x_msg_count => x_msg_count
3114: );
3115: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3116: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3117: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3118: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3119: end if;

Line 3116: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3112: x_msg_data => x_msg_data,
3113: x_msg_count => x_msg_count
3114: );
3115: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3116: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3117: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3118: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3119: end if;
3120:

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

3119: end if;
3120:
3121: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3122: -- now try to find the part in warehouse
3123: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3124: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3125: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3126: 'before calling CSP_SCH_INT_PVT.CHOOSE_OPTION...');
3127: end if;

Line 3124: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3120:
3121: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3122: -- now try to find the part in warehouse
3123: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3124: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3125: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3126: 'before calling CSP_SCH_INT_PVT.CHOOSE_OPTION...');
3127: end if;
3128: CSP_SCH_INT_PVT.CHOOSE_OPTION(

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

3137: x_return_status => x_return_status,
3138: x_msg_data => x_msg_data,
3139: x_msg_count => x_msg_count
3140: );
3141: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3142: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3143: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3144: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3145: end if;

Line 3142: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3138: x_msg_data => x_msg_data,
3139: x_msg_count => x_msg_count
3140: );
3141: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3142: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3143: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3144: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3145: end if;
3146: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

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

3221: and d.source_type = 'IO'
3222: AND d.source_id = oola.line_id
3223: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'PARTIALLY RECEIVED';
3224:
3225: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3226: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3227: 'l_partial_line = ' || l_partial_line);
3228: end if;
3229:

Line 3226: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3222: AND d.source_id = oola.line_id
3223: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) = 'PARTIALLY RECEIVED';
3224:
3225: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3226: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3227: 'l_partial_line = ' || l_partial_line);
3228: end if;
3229:
3230: if l_partial_line > 0 then

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

3262: AND oola.ordered_quantity = mr.reservation_quantity
3263: AND dres.source_type = 'RES'
3264: AND dres.source_id = mr.reservation_id;
3265:
3266: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3268: 'l_fl_rcvd_lines (R or S) = ' || l_fl_rcvd_lines);
3269: end if;
3270:

Line 3267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3263: AND dres.source_type = 'RES'
3264: AND dres.source_id = mr.reservation_id;
3265:
3266: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3268: 'l_fl_rcvd_lines (R or S) = ' || l_fl_rcvd_lines);
3269: end if;
3270:
3271: if l_fl_rcvd_lines > 0 then

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

3319: AND oola.ordered_quantity = mr.reservation_quantity
3320: AND dres.source_type = 'RES'
3321: AND dres.source_id = mr.reservation_id;
3322:
3323: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3325: 'l_fl_rcvd_lines = ' || l_fl_rcvd_lines);
3326: end if;
3327:

Line 3324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3320: AND dres.source_type = 'RES'
3321: AND dres.source_id = mr.reservation_id;
3322:
3323: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3325: 'l_fl_rcvd_lines = ' || l_fl_rcvd_lines);
3326: end if;
3327:
3328: if l_fl_rcvd_lines > 0 then

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

3354: AND l.requirement_line_id = dother.requirement_line_id
3355: AND dother.source_id <> dio.source_id
3356: AND dother.source_id <> dres.source_id;
3357:
3358: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3359: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3360: 'l_fl_rcvd_multi_source = ' || l_fl_rcvd_multi_source);
3361: end if;
3362:

Line 3359: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3355: AND dother.source_id <> dio.source_id
3356: AND dother.source_id <> dres.source_id;
3357:
3358: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3359: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3360: 'l_fl_rcvd_multi_source = ' || l_fl_rcvd_multi_source);
3361: end if;
3362:
3363: if l_fl_rcvd_multi_source > 0 then

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

3406: AND dres.source_type = 'RES'
3407: AND dres.source_id = mr.reservation_id
3408: );
3409:
3410: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3412: 'l_oth_req_line = ' || l_oth_req_line);
3413: end if;
3414:

Line 3411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3407: AND dres.source_id = mr.reservation_id
3408: );
3409:
3410: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3412: 'l_oth_req_line = ' || l_oth_req_line);
3413: end if;
3414:
3415: if l_oth_req_line > 0 then

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

3459: AND dres.source_type = 'RES'
3460: AND dres.source_id = mr.reservation_id
3461: );
3462:
3463: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3464: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3465: 'l_non_src_line = ' || l_non_src_line);
3466: end if;
3467:

Line 3464: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3460: AND dres.source_id = mr.reservation_id
3461: );
3462:
3463: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3464: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3465: 'l_non_src_line = ' || l_non_src_line);
3466: end if;
3467:
3468: if l_non_src_line = 0 then

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

3467:
3468: if l_non_src_line = 0 then
3469: -- if we are here that means all the lines source have been
3470: -- already recived
3471: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3473: 'before calling move_parts_on_reassign...');
3474: end if;
3475: CSP_SCH_INT_PVT.move_parts_on_reassign(

Line 3472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3468: if l_non_src_line = 0 then
3469: -- if we are here that means all the lines source have been
3470: -- already recived
3471: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3473: 'before calling move_parts_on_reassign...');
3474: end if;
3475: CSP_SCH_INT_PVT.move_parts_on_reassign(
3476: p_task_id => l_task_id,

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

3482: x_return_status => x_return_status,
3483: x_msg_count => x_msg_count,
3484: x_msg_data => x_msg_data
3485: );
3486: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3487: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3488: 'after calling move_parts_on_reassign...x_return_status=' || x_return_status);
3489: end if;
3490: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 3487: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3483: x_msg_count => x_msg_count,
3484: x_msg_data => x_msg_data
3485: );
3486: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3487: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3488: 'after calling move_parts_on_reassign...x_return_status=' || x_return_status);
3489: end if;
3490: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3491: x_return_status := FND_API.G_RET_STS_ERROR;

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

3514: AND d.source_type = 'IO'
3515: AND d.source_id = oola.line_id
3516: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');
3517:
3518: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3519: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3520: 'l_shpd_lines = ' || l_shpd_lines);
3521: end if;
3522:

Line 3519: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3515: AND d.source_id = oola.line_id
3516: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED');
3517:
3518: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3519: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3520: 'l_shpd_lines = ' || l_shpd_lines);
3521: end if;
3522:
3523: if l_shpd_lines > 0 then

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

3528: WHERE h.task_id = l_task_id
3529: AND h.task_assignment_id = l_Task_Assignment_id
3530: AND h.address_type IN ('R', 'S');
3531:
3532: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3534: 'l_tech_spec_pr = ' || l_tech_spec_pr);
3535: end if;
3536:

Line 3533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3529: AND h.task_assignment_id = l_Task_Assignment_id
3530: AND h.address_type IN ('R', 'S');
3531:
3532: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3534: 'l_tech_spec_pr = ' || l_tech_spec_pr);
3535: end if;
3536:
3537: if l_tech_spec_pr > 0 then

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

3580: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
3581: AND dother.requirement_line_id = l.requirement_line_id
3582: AND dother.source_id <> d.source_id;
3583:
3584: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3586: 'l_ship_multi_src = ' || l_ship_multi_src);
3587: end if;
3588:

Line 3585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3581: AND dother.requirement_line_id = l.requirement_line_id
3582: AND dother.source_id <> d.source_id;
3583:
3584: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3585: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3586: 'l_ship_multi_src = ' || l_ship_multi_src);
3587: end if;
3588:
3589: if l_ship_multi_src > 0 then

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

3623: AND d.source_id = oola.line_id
3624: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
3625: );
3626:
3627: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3628: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3629: 'l_oth_req_line = ' || l_oth_req_line);
3630: end if;
3631:

Line 3628: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3624: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
3625: );
3626:
3627: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3628: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3629: 'l_oth_req_line = ' || l_oth_req_line);
3630: end if;
3631:
3632: if l_oth_req_line > 0 then

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

3667: AND d.source_id = oola.line_id
3668: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
3669: );
3670:
3671: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3672: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3673: 'l_non_src_line = ' || l_non_src_line);
3674: end if;
3675:

Line 3672: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3668: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) in ('SHIPPED', 'EXPECTED')
3669: );
3670:
3671: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3672: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3673: 'l_non_src_line = ' || l_non_src_line);
3674: end if;
3675:
3676: if l_non_src_line = 0 then

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

3697: l_requirement_header.destination_subinventory := l_subinventory_code;
3698: l_requirement_header.resource_type := l_resource_type_code;
3699: l_requirement_header.resource_id := l_resource_id;
3700:
3701: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3702: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3703: 'before calling Update_requirement_headers...');
3704: end if;
3705: CSP_Requirement_Headers_PVT.Update_requirement_headers(

Line 3702: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3698: l_requirement_header.resource_type := l_resource_type_code;
3699: l_requirement_header.resource_id := l_resource_id;
3700:
3701: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3702: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3703: 'before calling Update_requirement_headers...');
3704: end if;
3705: CSP_Requirement_Headers_PVT.Update_requirement_headers(
3706: P_Api_Version_Number => 1.0,

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

3711: X_Return_Status => x_return_status,
3712: X_Msg_Count => x_msg_count,
3713: x_msg_data => x_msg_data
3714: );
3715: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3717: 'after calling Update_requirement_headers...x_return_status=' || x_return_status);
3718: end if;
3719:

Line 3716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3712: X_Msg_Count => x_msg_count,
3713: x_msg_data => x_msg_data
3714: );
3715: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3717: 'after calling Update_requirement_headers...x_return_status=' || x_return_status);
3718: end if;
3719:
3720: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

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

3741: end if;
3742: end if;
3743: end if;
3744:
3745: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3747: 'before making call to CLEAN_REQUIREMENT...');
3748: end if;
3749:

Line 3746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3742: end if;
3743: end if;
3744:
3745: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3747: 'before making call to CLEAN_REQUIREMENT...');
3748: end if;
3749:
3750: CSP_SCH_INT_PVT.CLEAN_REQUIREMENT(

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

3754: x_msg_count => x_msg_count,
3755: x_msg_data => x_msg_data
3756: );
3757:
3758: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3759: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3760: 'after making call to CLEAN_REQUIREMENT... x_return_status = ' || x_return_status);
3761: end if;
3762:

Line 3759: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3755: x_msg_data => x_msg_data
3756: );
3757:
3758: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3759: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3760: 'after making call to CLEAN_REQUIREMENT... x_return_status = ' || x_return_status);
3761: end if;
3762:
3763: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

3766: l_sch_option.resource_type := l_resource_type_code;
3767: l_sch_option.start_time := l_booking_start_date;
3768: l_sch_option.transfer_cost := 9999999; --- this should be a high number to avoid cost check in choose option
3769:
3770: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3771: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3772: 'before calling CSP_SCH_INT_PVT.CHOOSE_OPTION...');
3773: end if;
3774: CSP_SCH_INT_PVT.CHOOSE_OPTION(

Line 3771: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3767: l_sch_option.start_time := l_booking_start_date;
3768: l_sch_option.transfer_cost := 9999999; --- this should be a high number to avoid cost check in choose option
3769:
3770: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3771: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3772: 'before calling CSP_SCH_INT_PVT.CHOOSE_OPTION...');
3773: end if;
3774: CSP_SCH_INT_PVT.CHOOSE_OPTION(
3775: p_api_version_number => 1.0,

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

3783: x_return_status => x_return_status,
3784: x_msg_data => x_msg_data,
3785: x_msg_count => x_msg_count
3786: );
3787: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3788: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3789: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3790: end if;
3791:

Line 3788: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3784: x_msg_data => x_msg_data,
3785: x_msg_count => x_msg_count
3786: );
3787: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3788: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3789: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3790: end if;
3791:
3792: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

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

3790: end if;
3791:
3792: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3793: -- now try to find the part in warehouse
3794: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3796: 'before calling CSP_SCH_INT_PVT.CHOOSE_OPTION...');
3797: end if;
3798: CSP_SCH_INT_PVT.CHOOSE_OPTION(

Line 3795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3791:
3792: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3793: -- now try to find the part in warehouse
3794: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3796: 'before calling CSP_SCH_INT_PVT.CHOOSE_OPTION...');
3797: end if;
3798: CSP_SCH_INT_PVT.CHOOSE_OPTION(
3799: p_api_version_number => 1.0,

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

3807: x_return_status => x_return_status,
3808: x_msg_data => x_msg_data,
3809: x_msg_count => x_msg_count
3810: );
3811: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3812: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3813: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3814: end if;
3815: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 3812: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3808: x_msg_data => x_msg_data,
3809: x_msg_count => x_msg_count
3810: );
3811: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3812: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3813: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3814: end if;
3815: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3816: FND_MSG_PUB.initialize;

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

3847: l_requirement_header.destination_subinventory := l_subinventory_code;
3848: l_requirement_header.resource_type := l_resource_type_code;
3849: l_requirement_header.resource_id := l_resource_id;
3850:
3851: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3852: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3853: 'before calling Update_requirement_headers...');
3854: end if;
3855: CSP_Requirement_Headers_PVT.Update_requirement_headers(

Line 3852: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3848: l_requirement_header.resource_type := l_resource_type_code;
3849: l_requirement_header.resource_id := l_resource_id;
3850:
3851: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3852: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3853: 'before calling Update_requirement_headers...');
3854: end if;
3855: CSP_Requirement_Headers_PVT.Update_requirement_headers(
3856: P_Api_Version_Number => 1.0,

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

3861: X_Return_Status => x_return_status,
3862: X_Msg_Count => x_msg_count,
3863: x_msg_data => x_msg_data
3864: );
3865: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3867: 'after calling Update_requirement_headers...x_return_status=' || x_return_status);
3868: end if;
3869:

Line 3866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

3862: X_Msg_Count => x_msg_count,
3863: x_msg_data => x_msg_data
3864: );
3865: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3867: 'after calling Update_requirement_headers...x_return_status=' || x_return_status);
3868: end if;
3869:
3870: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

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

3899: return;
3900: -- this else part is to book the order
3901: else
3902:
3903: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3904: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3905: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3906: 'checking for task assignment status change...');
3907: end if;

Line 3904: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3900: -- this else part is to book the order
3901: else
3902:
3903: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3904: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3905: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3906: 'checking for task assignment status change...');
3907: end if;
3908:

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

3909: open get_task_asg_sts_id;
3910: fetch get_task_asg_sts_id into l_assignment_status_id;
3911: close get_task_asg_sts_id;
3912:
3913: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3914: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3915: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3916: 'l_assignment_status_id = ' || l_assignment_status_id);
3917: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3914: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3910: fetch get_task_asg_sts_id into l_assignment_status_id;
3911: close get_task_asg_sts_id;
3912:
3913: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3914: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3915: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3916: 'l_assignment_status_id = ' || l_assignment_status_id);
3917: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3918: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

Line 3917: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3913: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3914: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3915: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3916: 'l_assignment_status_id = ' || l_assignment_status_id);
3917: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3918: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3919: 'g_old_tsk_asgn_sts_id = ' || g_old_tsk_asgn_sts_id);
3920: end if;
3921:

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

3923: INTO l_o_assg_sts_flag
3924: FROM JTF_TASK_STATUSES_B
3925: WHERE task_status_id = g_old_tsk_asgn_sts_id;
3926:
3927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3929: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3930: 'l_o_assg_sts_flag = ' || l_o_assg_sts_flag);
3931: end if;

Line 3928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3924: FROM JTF_TASK_STATUSES_B
3925: WHERE task_status_id = g_old_tsk_asgn_sts_id;
3926:
3927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3929: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3930: 'l_o_assg_sts_flag = ' || l_o_assg_sts_flag);
3931: end if;
3932:

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

3938: WHERE task_status_id = l_assignment_status_id
3939: and (nvl(assigned_flag, 'N') = 'Y'
3940: or nvl(accepted_flag, 'N') = 'Y' or nvl(planned_flag, 'N') = 'Y');
3941:
3942: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3943: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3944: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3945: 'l_assg_sts_flag = ' || l_assg_sts_flag);
3946: end if;

Line 3943: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3939: and (nvl(assigned_flag, 'N') = 'Y'
3940: or nvl(accepted_flag, 'N') = 'Y' or nvl(planned_flag, 'N') = 'Y');
3941:
3942: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3943: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3944: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3945: 'l_assg_sts_flag = ' || l_assg_sts_flag);
3946: end if;
3947:

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

3947:
3948: if l_assg_sts_flag = 'Y' then
3949: TASK_ASSIGNMENT_POST_INSERT(x_return_status => x_return_status);
3950:
3951: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3953: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3954: 'after calling TASK_ASSIGNMENT_POST_INSERT.... x_return_status = ' || x_return_status);
3955: end if;

Line 3952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3948: if l_assg_sts_flag = 'Y' then
3949: TASK_ASSIGNMENT_POST_INSERT(x_return_status => x_return_status);
3950:
3951: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3953: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3954: 'after calling TASK_ASSIGNMENT_POST_INSERT.... x_return_status = ' || x_return_status);
3955: end if;
3956:

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

3962:
3963: end if;
3964:
3965:
3966: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3968: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3969: 'checking for accepted status change');
3970: end if;

Line 3967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3963: end if;
3964:
3965:
3966: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3967: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3968: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3969: 'checking for accepted status change');
3970: end if;
3971:

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

3973: INTO l_assg_sts_flag
3974: FROM JTF_TASK_STATUSES_B
3975: WHERE task_status_id = l_assignment_status_id;
3976:
3977: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3978: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3979: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3980: 'l_assg_sts_flag = ' || l_assg_sts_flag);
3981: end if;

Line 3978: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3974: FROM JTF_TASK_STATUSES_B
3975: WHERE task_status_id = l_assignment_status_id;
3976:
3977: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3978: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3979: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3980: 'l_assg_sts_flag = ' || l_assg_sts_flag);
3981: end if;
3982:

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

3981: end if;
3982:
3983: if l_assg_sts_flag = 'Y' then
3984:
3985: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3986: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3987: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3988: 'fetching entered status order header_id...');
3989: end if;

Line 3986: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3982:
3983: if l_assg_sts_flag = 'Y' then
3984:
3985: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3986: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3987: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3988: 'fetching entered status order header_id...');
3989: end if;
3990:

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

3992: for cr in get_order_header_id loop
3993:
3994: l_oe_header_id := cr.header_id;
3995:
3996: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3997: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3998: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3999: 'l_oe_header_id = ' || l_oe_header_id);
4000: end if;

Line 3997: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

3993:
3994: l_oe_header_id := cr.header_id;
3995:
3996: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3997: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3998: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3999: 'l_oe_header_id = ' || l_oe_header_id);
4000: end if;
4001:

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

4000: end if;
4001:
4002: if l_oe_header_id is not null then
4003:
4004: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4005: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4006: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4007: 'before calling CSP_PARTS_ORDER.book_order ...');
4008: end if;

Line 4005: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4001:
4002: if l_oe_header_id is not null then
4003:
4004: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4005: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4006: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4007: 'before calling CSP_PARTS_ORDER.book_order ...');
4008: end if;
4009:

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

4013: x_msg_count => x_msg_count,
4014: x_msg_data => x_msg_data
4015: );
4016:
4017: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4018: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4019: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4020: 'after calling CSP_PARTS_ORDER.book_order ...');
4021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4018: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4014: x_msg_data => x_msg_data
4015: );
4016:
4017: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4018: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4019: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4020: 'after calling CSP_PARTS_ORDER.book_order ...');
4021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4022: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

Line 4021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4017: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4018: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4019: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4020: 'after calling CSP_PARTS_ORDER.book_order ...');
4021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4022: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4023: 'x_return_status = ' || x_return_status);
4024: end if;
4025:

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

4038: end if;
4039: end loop;
4040: end if; -- if l_assg_sts_flag = 'Y' then -- accepted
4041:
4042: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4043: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4044: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4045: 'checking for cancelled status change');
4046: end if;

Line 4043: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4039: end loop;
4040: end if; -- if l_assg_sts_flag = 'Y' then -- accepted
4041:
4042: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4043: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4044: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4045: 'checking for cancelled status change');
4046: end if;
4047:

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

4049: INTO l_assg_sts_flag
4050: FROM JTF_TASK_STATUSES_B
4051: WHERE task_status_id = l_assignment_status_id;
4052:
4053: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4055: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4056: 'l_assg_sts_flag = ' || l_assg_sts_flag);
4057: end if;

Line 4054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4050: FROM JTF_TASK_STATUSES_B
4051: WHERE task_status_id = l_assignment_status_id;
4052:
4053: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4055: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4056: 'l_assg_sts_flag = ' || l_assg_sts_flag);
4057: end if;
4058:

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

4057: end if;
4058:
4059: if l_assg_sts_flag = 'Y' then
4060:
4061: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4062: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4063: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4064: 'before calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT...');
4065: end if;

Line 4062: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4058:
4059: if l_assg_sts_flag = 'Y' then
4060:
4061: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4062: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4063: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4064: 'before calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT...');
4065: end if;
4066:

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

4071: x_msg_count => x_msg_count,
4072: x_msg_data => x_msg_data
4073: );
4074:
4075: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4077: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4078: 'after calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT... x_return_status = ' || x_return_status);
4079: end if;

Line 4076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4072: x_msg_data => x_msg_data
4073: );
4074:
4075: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4077: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4078: 'after calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT... x_return_status = ' || x_return_status);
4079: end if;
4080:

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

4091: end if; -- if l_assg_sts_flag = 'Y' then -- cancelled
4092: END IF;
4093: END IF;
4094:
4095: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4096: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4097: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4098: 'done ...');
4099: end if;

Line 4096: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4092: END IF;
4093: END IF;
4094:
4095: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4096: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4097: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4098: 'done ...');
4099: end if;
4100: END;

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

4250: AND csp.resource_type = l_resource_type_code;
4251:
4252: BEGIN
4253:
4254: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4255: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4256: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4257: 'Begin');
4258: end if;

Line 4255: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4251:
4252: BEGIN
4253:
4254: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4255: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4256: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4257: 'Begin');
4258: end if;
4259:

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

4262: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4263: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
4264: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
4265:
4266: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4268: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4269: 'l_task_assignment_id = ' || l_task_assignment_id
4270: || ', l_assignee_role = ' || l_assignee_role

Line 4267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4263: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
4264: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
4265:
4266: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4268: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4269: 'l_task_assignment_id = ' || l_task_assignment_id
4270: || ', l_assignee_role = ' || l_assignee_role
4271: || ', l_resource_id = ' || l_resource_id

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

4275: if l_assignee_role = 'ASSIGNEE' then
4276:
4277: -- check any requirement without task_assignment_id, if yes popuplate assignment details...
4278:
4279: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4280: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4281: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4282: 'checking if there is no task assignment posted on the part req...');
4283: end if;

Line 4280: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4276:
4277: -- check any requirement without task_assignment_id, if yes popuplate assignment details...
4278:
4279: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4280: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4281: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4282: 'checking if there is no task assignment posted on the part req...');
4283: end if;
4284:

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

4284:
4285: for cr in get_blank_req_header loop
4286: l_rqmt_header_id := cr.requirement_header_id;
4287:
4288: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4290: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4291: 'found one l_rqmt_header_id = ' || l_rqmt_header_id);
4292: end if;

Line 4289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4285: for cr in get_blank_req_header loop
4286: l_rqmt_header_id := cr.requirement_header_id;
4287:
4288: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4290: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4291: 'found one l_rqmt_header_id = ' || l_rqmt_header_id);
4292: end if;
4293:

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

4308: OPEN get_Resource_org_sub;
4309: FETCH get_resource_org_sub INTO l_organization_id, l_subinventory_code;
4310: CLOSE get_resource_org_sub;
4311:
4312: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4314: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4315: 'l_organization_id = ' || l_organization_id
4316: || ', l_subinventory_code = ' || l_subinventory_code);

Line 4313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4309: FETCH get_resource_org_sub INTO l_organization_id, l_subinventory_code;
4310: CLOSE get_resource_org_sub;
4311:
4312: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4314: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4315: 'l_organization_id = ' || l_organization_id
4316: || ', l_subinventory_code = ' || l_subinventory_code);
4317: end if;

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

4319: open get_current_ship_to(l_rqmt_header_id);
4320: fetch get_current_ship_to into l_ship_to_location_id, l_ship_to_type;
4321: close get_current_ship_to;
4322:
4323: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4325: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4326: 'l_ship_to_location_id = ' || l_ship_to_location_id);
4327: end if;

Line 4324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4320: fetch get_current_ship_to into l_ship_to_location_id, l_ship_to_type;
4321: close get_current_ship_to;
4322:
4323: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4325: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4326: 'l_ship_to_location_id = ' || l_ship_to_location_id);
4327: end if;
4328:

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

4345: l_dflt_ship_add_prf := 'NONE';
4346: end if;
4347:
4348:
4349: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4350: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4351: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4352: 'profile CSP_PART_REQ_DEF_SHIP_TO is l_dflt_ship_add_prf = ' || l_dflt_ship_add_prf);
4353: end if;

Line 4350: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4346: end if;
4347:
4348:
4349: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4350: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4351: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4352: 'profile CSP_PART_REQ_DEF_SHIP_TO is l_dflt_ship_add_prf = ' || l_dflt_ship_add_prf);
4353: end if;
4354:

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

4386: CLOSE get_resource_location;
4387:
4388: end if;
4389:
4390: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4391: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4392: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4393: 'l_ship_to_type = ' || l_ship_to_type
4394: || ', l_ship_to_location_id = ' || l_ship_to_location_id

Line 4391: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4387:
4388: end if;
4389:
4390: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4391: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4392: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4393: 'l_ship_to_type = ' || l_ship_to_type
4394: || ', l_ship_to_location_id = ' || l_ship_to_location_id
4395: || ', l_ship_hz_loc_id = ' || l_ship_hz_loc_id);

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

4399: /*
4400: if l_ship_to_location_id is null and nvl(l_ship_hz_loc_id, -999) <> -999 then
4401: -- need to generate HR_LOCATION_ID
4402:
4403: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4404: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4405: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4406: 'Before calling csp_ship_to_address_pvt.cust_inv_loc_link...');
4407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4404: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4400: if l_ship_to_location_id is null and nvl(l_ship_hz_loc_id, -999) <> -999 then
4401: -- need to generate HR_LOCATION_ID
4402:
4403: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4404: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4405: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4406: 'Before calling csp_ship_to_address_pvt.cust_inv_loc_link...');
4407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4408: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

Line 4407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4403: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4404: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4405: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4406: 'Before calling csp_ship_to_address_pvt.cust_inv_loc_link...');
4407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4408: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4409: 'l_party_site_id = ' || l_party_site_id
4410: || ', l_cust_act_id = ' || l_cust_act_id
4411: || ', l_cust_id = ' || l_cust_id

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

4446: ,x_msg_count => x_msg_count
4447: ,x_msg_data => x_msg_data
4448: );
4449:
4450: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4452: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4453: 'After calling csp_ship_to_address_pvt.cust_inv_loc_link...');
4454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4447: ,x_msg_data => x_msg_data
4448: );
4449:
4450: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4452: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4453: 'After calling csp_ship_to_address_pvt.cust_inv_loc_link...');
4454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4455: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

Line 4454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4450: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4452: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4453: 'After calling csp_ship_to_address_pvt.cust_inv_loc_link...');
4454: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4455: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4456: 'x_return_status = ' || x_return_status
4457: || ', x_msg_count = ' || x_msg_count
4458: || ', x_msg_data = ' || x_msg_data

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

4467: end if;
4468: */
4469: end if;
4470:
4471: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4473: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4474: 'before calling CSP_REQUIREMENT_HEADERS_PKG.Update_Row...');
4475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4468: */
4469: end if;
4470:
4471: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4473: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4474: 'before calling CSP_REQUIREMENT_HEADERS_PKG.Update_Row...');
4475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4476: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

Line 4475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4471: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4473: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4474: 'before calling CSP_REQUIREMENT_HEADERS_PKG.Update_Row...');
4475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4476: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4477: 'l_ship_to_location_id = ' || l_ship_to_location_id);
4478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4479: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

Line 4478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4474: 'before calling CSP_REQUIREMENT_HEADERS_PKG.Update_Row...');
4475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4476: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4477: 'l_ship_to_location_id = ' || l_ship_to_location_id);
4478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4479: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4480: 'l_ship_to_type = ' || l_ship_to_type);
4481: end if;
4482:

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

4491: p_SHIP_TO_LOCATION_ID => l_ship_to_location_id,
4492: p_ship_to_contact_id => null
4493: );
4494:
4495: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4496: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4497: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4498: 'after calling CSP_REQUIREMENT_HEADERS_PKG.Update_Row...');
4499: end if;

Line 4496: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4492: p_ship_to_contact_id => null
4493: );
4494:
4495: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4496: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4497: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4498: 'after calling CSP_REQUIREMENT_HEADERS_PKG.Update_Row...');
4499: end if;
4500:

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

4500:
4501: end loop;
4502: end if;
4503:
4504: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4506: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4507: 'done ...');
4508: end if;

Line 4505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4501: end loop;
4502: end if;
4503:
4504: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4505: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4506: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4507: 'done ...');
4508: end if;
4509: END;

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

4517: l_task_id number;
4518: l_dtl_count number;
4519: EXCP_USER_DEFINED EXCEPTION;
4520: BEGIN
4521: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4523: 'begin ...');
4524: end if;
4525:

Line 4522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,

4518: l_dtl_count number;
4519: EXCP_USER_DEFINED EXCEPTION;
4520: BEGIN
4521: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4523: 'begin ...');
4524: end if;
4525:
4526: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4526: x_return_status := FND_API.G_RET_STS_SUCCESS;
4527: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4528: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
4529:
4530: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4532: 'before calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT...');
4533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4534: 'l_task_assignment_id=' || l_task_assignment_id);

Line 4531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,

4527: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4528: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
4529:
4530: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4532: 'before calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT...');
4533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4534: 'l_task_assignment_id=' || l_task_assignment_id);
4535: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,

Line 4533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,

4529:
4530: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4532: 'before calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT...');
4533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4534: 'l_task_assignment_id=' || l_task_assignment_id);
4535: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4536: 'l_task_id=' || l_task_id);
4537: end if;

Line 4535: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,

4531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4532: 'before calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT...');
4533: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4534: 'l_task_assignment_id=' || l_task_assignment_id);
4535: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4536: 'l_task_id=' || l_task_id);
4537: end if;
4538:
4539: CSP_SCH_INT_PVT.CLEAN_REQUIREMENT(

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

4555: AND h.task_id = l_task_id
4556: AND h.requirement_header_id = l.requirement_header_id
4557: AND l.requirement_line_id = d.requirement_line_id;
4558:
4559: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4561: 'l_dtl_count=' || l_dtl_count);
4562: end if;
4563:

Line 4560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,

4556: AND h.requirement_header_id = l.requirement_header_id
4557: AND l.requirement_line_id = d.requirement_line_id;
4558:
4559: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4561: 'l_dtl_count=' || l_dtl_count);
4562: end if;
4563:
4564: if l_dtl_count > 0 then

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

4570: , p_data => x_msg_data);
4571: raise EXCP_USER_DEFINED;
4572: end if;
4573:
4574: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4576: 'after calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT... x_return_status = ' || x_return_status);
4577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4578: 'done ...');

Line 4575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,

4571: raise EXCP_USER_DEFINED;
4572: end if;
4573:
4574: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4576: 'after calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT... x_return_status = ' || x_return_status);
4577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4578: 'done ...');
4579: end if;

Line 4577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,

4573:
4574: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4576: 'after calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT... x_return_status = ' || x_return_status);
4577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4578: 'done ...');
4579: end if;
4580: END;
4581:

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

4581:
4582: procedure log(p_procedure in varchar2,p_message in varchar2) as
4583: begin
4584: --dbms_output.put_line(p_procedure||' - '||p_message);
4585: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4587: 'csp.plsql.csp_parts_requirement.'||p_procedure,
4588: p_message);
4589: end if;

Line 4586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4582: procedure log(p_procedure in varchar2,p_message in varchar2) as
4583: begin
4584: --dbms_output.put_line(p_procedure||' - '||p_message);
4585: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4586: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4587: 'csp.plsql.csp_parts_requirement.'||p_procedure,
4588: p_message);
4589: end if;
4590: end;