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 CSP_PARTS_REQUIREMENT

Line 1: PACKAGE BODY CSP_PARTS_REQUIREMENT AS

1: PACKAGE BODY CSP_PARTS_REQUIREMENT AS
2: /* $Header: cspvprqb.pls 120.19.12020000.7 2013/03/06 17:28:09 htank ship $ */
3:
4: -- Purpose: Create/Update/Cancel Internal Parts Requirements for Spares
5: --

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'csp_parts_requirement';

7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------
9: -- phegde 05/17/01 Created new package body
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'csp_parts_requirement';
12: G_FILE_NAME CONSTANT VARCHAR2(30) := 'cspvprqb.pls';
13:
14: G_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
15: g_old_tsk_asgn_sts_id number;

Line 134: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type

130: PROCEDURE process_requirement
131: ( p_api_version IN NUMBER
132: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
134: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
135: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
136: ,p_create_order_flag IN VARCHAR2
137: ,x_return_status OUT NOCOPY VARCHAR2
138: ,x_msg_count OUT NOCOPY NUMBER

Line 135: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type

131: ( p_api_version IN NUMBER
132: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
134: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
135: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
136: ,p_create_order_flag IN VARCHAR2
137: ,x_return_status OUT NOCOPY VARCHAR2
138: ,x_msg_count OUT NOCOPY NUMBER
139: ,x_msg_data OUT NOCOPY VARCHAR2

Line 169: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;

165:
166: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
167: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
168: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
169: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;
170: j NUMBER;
171:
172: --Record types and tbl types for finding availability of parts
173: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;

Line 448: l_rqmt_header_Rec.address_type := l_header_rec.address_type;-- csp_parts_Requirement.G_ADDR_RESOURCE;

444: l_rqmt_header_Rec.last_update_date := l_today;
445: l_rqmt_header_Rec.last_update_login := nvl(l_login_id, -1);
446: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
447: l_rqmt_header_Rec.timezone_id := nvl(l_timezone_id, FND_API.G_MISS_NUM);
448: l_rqmt_header_Rec.address_type := l_header_rec.address_type;-- csp_parts_Requirement.G_ADDR_RESOURCE;
449: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
450: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
451: l_rqmt_header_Rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);
452: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);

Line 790: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type

786: PROCEDURE csptrreq_fm_order(
787: p_api_version IN NUMBER
788: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
789: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
790: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
791: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
792: ,x_return_status OUT NOCOPY VARCHAR2
793: ,x_msg_count OUT NOCOPY NUMBER
794: ,x_msg_data OUT NOCOPY VARCHAR2

Line 791: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type

787: p_api_version IN NUMBER
788: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
789: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
790: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
791: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
792: ,x_return_status OUT NOCOPY VARCHAR2
793: ,x_msg_count OUT NOCOPY NUMBER
794: ,x_msg_data OUT NOCOPY VARCHAR2
795: ) IS

Line 1129: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type

1125: PROCEDURE csptrreq_order_res(
1126: p_api_version IN NUMBER
1127: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1128: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1129: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
1130: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
1131: ,x_return_status OUT NOCOPY VARCHAR2
1132: ,x_msg_count OUT NOCOPY NUMBER
1133: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1130: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type

1126: p_api_version IN NUMBER
1127: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1128: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1129: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
1130: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
1131: ,x_return_status OUT NOCOPY VARCHAR2
1132: ,x_msg_count OUT NOCOPY NUMBER
1133: ,x_msg_data OUT NOCOPY VARCHAR2
1134: ) IS

Line 1209: 'csp.plsql.csp_parts_requirement.csptrreq_order_res',

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
1213: || ', l_header_Rec.ship_to_location_id = ' || l_header_Rec.ship_to_location_id);

Line 1235: 'csp.plsql.csp_parts_requirement.csptrreq_order_res',

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
1239: || ', l_org_id = ' || l_org_id);

Line 1278: 'csp.plsql.csp_parts_requirement.csptrreq_order_res',

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:
1282: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1546: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type

1542: PROCEDURE save_rqmt_line(
1543: p_api_version IN NUMBER
1544: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1545: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1546: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
1547: ,px_line_tbl IN OUT NOCOPY csp_parts_requirement.Line_tbl_type
1548: ,x_return_status OUT NOCOPY VARCHAR2
1549: ,x_msg_count OUT NOCOPY NUMBER
1550: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1547: ,px_line_tbl IN OUT NOCOPY csp_parts_requirement.Line_tbl_type

1543: p_api_version IN NUMBER
1544: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1545: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1546: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
1547: ,px_line_tbl IN OUT NOCOPY csp_parts_requirement.Line_tbl_type
1548: ,x_return_status OUT NOCOPY VARCHAR2
1549: ,x_msg_count OUT NOCOPY NUMBER
1550: ,x_msg_data OUT NOCOPY VARCHAR2
1551: )IS

Line 1554: l_header_rec csp_parts_requirement.Header_rec_type;

1550: ,x_msg_data OUT NOCOPY VARCHAR2
1551: )IS
1552: l_api_version_number CONSTANT NUMBER := 1.0;
1553: l_api_name CONSTANT VARCHAR2(30) := 'save_rqmt_line';
1554: l_header_rec csp_parts_requirement.Header_rec_type;
1555: l_line_tbl csp_parts_requirement.Line_Tbl_type;
1556: l_line_rec Line_rec_type;
1557: l_user_id NUMBER;
1558: l_login_id NUMBER;

Line 1555: l_line_tbl csp_parts_requirement.Line_Tbl_type;

1551: )IS
1552: l_api_version_number CONSTANT NUMBER := 1.0;
1553: l_api_name CONSTANT VARCHAR2(30) := 'save_rqmt_line';
1554: l_header_rec csp_parts_requirement.Header_rec_type;
1555: l_line_tbl csp_parts_requirement.Line_Tbl_type;
1556: l_line_rec Line_rec_type;
1557: l_user_id NUMBER;
1558: l_login_id NUMBER;
1559: l_today DATE;

Line 2039: ,p_line_tbl IN OUT NOCOPY csp_parts_requirement.Rqmt_Line_tbl_type

2035: PROCEDURE delete_rqmt_line(
2036: p_api_version IN NUMBER
2037: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
2038: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2039: ,p_line_tbl IN OUT NOCOPY csp_parts_requirement.Rqmt_Line_tbl_type
2040: ,x_return_status OUT NOCOPY VARCHAR2
2041: ,x_msg_count OUT NOCOPY NUMBER
2042: ,x_msg_data OUT NOCOPY VARCHAR2
2043: ) IS

Line 2115: ,x_line_Tbl OUT NOCOPY csp_parts_requirement.Line_tbl_type

2111: p_api_version IN NUMBER
2112: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
2113: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2114: ,p_header_id IN NUMBER
2115: ,x_line_Tbl OUT NOCOPY csp_parts_requirement.Line_tbl_type
2116: ,x_avail_flag OUT NOCOPY VARCHAR2
2117: ,x_return_status OUT NOCOPY VARCHAR2
2118: ,x_msg_count OUT NOCOPY NUMBER
2119: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2124: l_header_rec csp_parts_requirement.Header_rec_type;

2120: )IS
2121: l_api_version_number CONSTANT NUMBER := 1.0;
2122: l_api_name CONSTANT VARCHAR2(30) := 'check_availability';
2123: l_count NUMBER;
2124: l_header_rec csp_parts_requirement.Header_rec_type;
2125: l_line_rec csp_parts_requirement.line_rec_type;
2126: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2127: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2128: EXCP_USER_DEFINED EXCEPTION;

Line 2125: l_line_rec csp_parts_requirement.line_rec_type;

2121: l_api_version_number CONSTANT NUMBER := 1.0;
2122: l_api_name CONSTANT VARCHAR2(30) := 'check_availability';
2123: l_count NUMBER;
2124: l_header_rec csp_parts_requirement.Header_rec_type;
2125: l_line_rec csp_parts_requirement.line_rec_type;
2126: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2127: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2128: EXCP_USER_DEFINED EXCEPTION;
2129: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;

Line 2126: l_line_tbl csp_parts_Requirement.line_Tbl_type;

2122: l_api_name CONSTANT VARCHAR2(30) := 'check_availability';
2123: l_count NUMBER;
2124: l_header_rec csp_parts_requirement.Header_rec_type;
2125: l_line_rec csp_parts_requirement.line_rec_type;
2126: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2127: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2128: EXCP_USER_DEFINED EXCEPTION;
2129: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;
2130: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;

Line 2379: l_header_rec csp_parts_requirement.Header_rec_type;

2375: )IS
2376: l_api_version_number CONSTANT NUMBER := 1.0;
2377: l_api_name CONSTANT VARCHAR2(30) := 'create_order';
2378: l_count NUMBER;
2379: l_header_rec csp_parts_requirement.Header_rec_type;
2380: l_line_rec csp_parts_requirement.line_rec_type;
2381: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2382: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2383: l_po_line_Tbl csp_parts_requirement.line_tbl_type;

Line 2380: l_line_rec csp_parts_requirement.line_rec_type;

2376: l_api_version_number CONSTANT NUMBER := 1.0;
2377: l_api_name CONSTANT VARCHAR2(30) := 'create_order';
2378: l_count NUMBER;
2379: l_header_rec csp_parts_requirement.Header_rec_type;
2380: l_line_rec csp_parts_requirement.line_rec_type;
2381: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2382: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2383: l_po_line_Tbl csp_parts_requirement.line_tbl_type;
2384: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

Line 2381: l_line_tbl csp_parts_Requirement.line_Tbl_type;

2377: l_api_name CONSTANT VARCHAR2(30) := 'create_order';
2378: l_count NUMBER;
2379: l_header_rec csp_parts_requirement.Header_rec_type;
2380: l_line_rec csp_parts_requirement.line_rec_type;
2381: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2382: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2383: l_po_line_Tbl csp_parts_requirement.line_tbl_type;
2384: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2385: EXCP_USER_DEFINED EXCEPTION;

Line 2382: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;

2378: l_count NUMBER;
2379: l_header_rec csp_parts_requirement.Header_rec_type;
2380: l_line_rec csp_parts_requirement.line_rec_type;
2381: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2382: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2383: l_po_line_Tbl csp_parts_requirement.line_tbl_type;
2384: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2385: EXCP_USER_DEFINED EXCEPTION;
2386: I NUMBER;

Line 2383: l_po_line_Tbl csp_parts_requirement.line_tbl_type;

2379: l_header_rec csp_parts_requirement.Header_rec_type;
2380: l_line_rec csp_parts_requirement.line_rec_type;
2381: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2382: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2383: l_po_line_Tbl csp_parts_requirement.line_tbl_type;
2384: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2385: EXCP_USER_DEFINED EXCEPTION;
2386: I NUMBER;
2387: J NUMBER;

Line 2418: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

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:
2422: SAVEPOINT create_order_PUB;

Line 2448: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

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;
2452:

Line 2464: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

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:
2468: IF (l_count > 0) THEN

Line 2491: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

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
2495: || ', l_header_Rec.ship_to_location_id = ' || l_header_Rec.ship_to_location_id

Line 2528: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

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
2532: || ', l_line_Rec.revision = ' || l_line_Rec.revision

Line 2563: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

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(
2567: p_api_version => l_api_version_number

Line 2578: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

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:
2582: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2604: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

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
2608: when no_data_found then

Line 2611: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

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;
2615: null;

Line 2705: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

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;
2709: EXCEPTION

Line 2706: 'Returning from csp.plsql.CSP_PARTS_REQUIREMENT.create_order with return status = '

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;
2709: EXCEPTION
2710: WHEN EXCP_USER_DEFINED THEN

Line 2874: l_module varchar2(100) := 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE';

2870: l_tech_spec_pr number;
2871: l_ship_multi_src number;
2872: l_dest_ou number;
2873: l_rs_ou number;
2874: l_module varchar2(100) := 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE';
2875: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;
2876: l_order_number varchar2(100);
2877: l_dest_org_name varchar2(240);
2878:

Line 3099: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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(
3103: p_api_version_number => 1.0,

Line 3117: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
3121: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 3125: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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(
3129: p_api_version_number => 1.0,

Line 3143: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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
3147: rollback to csp_correct_req_record;

Line 3905: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
3909: open get_task_asg_sts_id;

Line 3915: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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',
3919: 'g_old_tsk_asgn_sts_id = ' || g_old_tsk_asgn_sts_id);

Line 3918: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
3922: SELECT nvl(cancelled_flag, 'N')

Line 3929: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
3933: if l_o_assg_sts_flag = 'Y' then

Line 3944: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
3948: if l_assg_sts_flag = 'Y' then

Line 3953: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
3957: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 3968: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
3972: SELECT nvl(accepted_flag, 'N')

Line 3979: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
3983: if l_assg_sts_flag = 'Y' then

Line 3987: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
3991: savepoint csp_book_order;

Line 3998: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
4002: if l_oe_header_id is not null then

Line 4006: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
4010: CSP_PARTS_ORDER.book_order(

Line 4019: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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',
4023: 'x_return_status = ' || x_return_status);

Line 4022: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
4026: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 4044: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
4048: SELECT nvl(cancelled_flag, 'N')

Line 4055: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
4059: if l_assg_sts_flag = 'Y' then

Line 4063: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
4067: CSP_SCH_INT_PVT.CLEAN_REQUIREMENT(

Line 4077: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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:
4081: if x_return_status = 'C' then

Line 4097: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

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;
4101:

Line 4256: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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:
4260: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4268: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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
4272: || ', l_resource_type_code = ' || l_resource_type_code);

Line 4281: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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:
4285: for cr in get_blank_req_header loop

Line 4290: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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:
4294: -- we need to default following things

Line 4314: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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;
4318:

Line 4325: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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:
4329: if l_ship_to_location_id is null then

Line 4351: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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:
4355: if l_dflt_ship_add_prf = 'TASK' then

Line 4392: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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);
4396: end if;

Line 4405: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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',
4409: 'l_party_site_id = ' || l_party_site_id

Line 4408: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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
4412: || ', l_org_id = ' || l_org_id);

Line 4452: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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',
4456: 'x_return_status = ' || x_return_status

Line 4455: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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
4459: || ', l_ship_hz_loc_id = ' || l_ship_hz_loc_id);

Line 4473: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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',
4477: 'l_ship_to_location_id = ' || l_ship_to_location_id);

Line 4476: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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',
4480: 'l_ship_to_type = ' || l_ship_to_type);

Line 4479: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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:
4483: CSP_REQUIREMENT_HEADERS_PKG.Update_Row(

Line 4497: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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:
4501: end loop;

Line 4506: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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;
4510:

Line 4513: l_log_module varchar2(100) := 'csp.plsql.csp_parts_requirement.task_assignment_pre_delete';

4509: END;
4510:
4511: PROCEDURE TASK_ASSIGNMENT_PRE_DELETE(x_return_status out nocopy varchar2)
4512: IS
4513: l_log_module varchar2(100) := 'csp.plsql.csp_parts_requirement.task_assignment_pre_delete';
4514: l_task_assignment_id NUMBER;
4515: x_msg_data varchar2(4000);
4516: x_msg_count number;
4517: l_task_id number;

Line 4587: 'csp.plsql.csp_parts_requirement.'||p_procedure,

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;
4591: