DBA Data[Home] [Help]

APPS.CSD_SOO_PVT dependencies on STANDARD

Line 51: /* STANDARD PARAMETERS */

47: /* Function name: DEBUG */
48: /* Description : Logs the debug message */
49: /* Called from : Called from Update API */
50: /* */
51: /* STANDARD PARAMETERS */
52: /* In Parameters : */
53: /* p_message Required Debug message that needs to be logged */
54: /* p_mod_name Required Module name */
55: /* p_severity_level Required Severity level */

Line 57: /* NON-STANDARD PARAMETERS */

53: /* p_message Required Debug message that needs to be logged */
54: /* p_mod_name Required Module name */
55: /* p_severity_level Required Severity level */
56: /* Output Parameters: */
57: /* NON-STANDARD PARAMETERS */
58: /* In Parameters */
59: /* Out parameters */
60: /* Change Hist : */
61: /* 09/20/03 vlakaman Initial Creation. */

Line 151: -- Standard Variables

147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2)
150: IS
151: -- Standard Variables
152: l_api_name CONSTANT VARCHAR2(20) := 'GET_DOCUMENT_STATUS';
153: l_api_version CONSTANT NUMBER := 1.0;
154:
155: -- Variables used in FND Log

Line 221: -- Standard call to check for call compatibility.

217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218:
219: -- Log the api name in the log file
220: Debug('At the Beginning of Get_Document_Status',l_mod_name,1);
221: -- Standard call to check for call compatibility.
222: IF NOT FND_API.Compatible_API_Call (l_api_version,
223: p_api_version,
224: l_api_name ,
225: G_PKG_NAME ) THEN

Line 333: -- Standard Variables

329: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
330: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
331: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM)
332: IS
333: -- Standard Variables
334: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_JOB';
335: l_api_version CONSTANT NUMBER := 1.0;
336:
337: -- Variables in FND log

Line 367: -- Standard call to check for call compatibility.

363:
364: -- Log the api name in the log file
365: Debug('At the Beginning of Refresh_Job', l_mod_name, 1);
366:
367: -- Standard call to check for call compatibility.
368: IF NOT FND_API.Compatible_API_Call (l_api_version,
369: p_api_version,
370: l_api_name ,
371: G_PKG_NAME)

Line 571: -- Standard check of p_commit.

567: END IF;
568: END IF;
569: END LOOP;
570:
571: -- Standard check of p_commit.
572: IF FND_API.To_Boolean( p_commit ) THEN
573: COMMIT WORK;
574: END IF;
575:

Line 634: -- Standard Variables

630: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
631: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
632: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM)
633: IS
634: -- Standard Variables
635: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_SR';
636: l_api_version CONSTANT NUMBER := 1.0;
637:
638: -- Variables in FND log

Line 667: -- Standard call to check for call compatibility.

663:
664: -- Log the api name in the log file
665: Debug('At the Beginning of Refresh_SR', l_mod_name, 1);
666:
667: -- Standard call to check for call compatibility.
668: IF NOT FND_API.Compatible_API_Call (l_api_version,
669: p_api_version,
670: l_api_name ,
671: G_PKG_NAME)

Line 864: -- Standard check of p_commit.

860: END IF;
861: END IF;
862: END LOOP;
863:
864: -- Standard check of p_commit.
865: IF FND_API.To_Boolean( p_commit ) THEN
866: COMMIT WORK;
867: END IF;
868:

Line 928: -- Standard Variables

924: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
925: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
926: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM)
927: IS
928: -- Standard Variables
929: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_SR_TASK';
930: l_api_version CONSTANT NUMBER := 1.0;
931:
932: -- Variables in FND log

Line 961: -- Standard call to check for call compatibility.

957:
958: -- Log the api name in the log file
959: Debug('At the Beginning of Refresh_SR_Task', l_mod_name, 1);
960:
961: -- Standard call to check for call compatibility.
962: IF NOT FND_API.Compatible_API_Call (l_api_version,
963: p_api_version,
964: l_api_name ,
965: G_PKG_NAME)

Line 1162: -- Standard check of p_commit.

1158: END IF;
1159: END IF;
1160: END LOOP;
1161:
1162: -- Standard check of p_commit.
1163: IF FND_API.To_Boolean( p_commit ) THEN
1164: COMMIT WORK;
1165: END IF;
1166:

Line 1226: -- Standard Variables

1222: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1223: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
1224: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM)
1225: IS
1226: -- Standard Variables
1227: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_PURCHASE_REQ';
1228: l_api_version CONSTANT NUMBER := 1.0;
1229:
1230: -- Variables in FND log

Line 1266: -- Standard call to check for call compatibility.

1262:
1263: -- Log the api name in the log file
1264: Debug('At the Beginning of Refresh_Purchase_Req', l_mod_name, 1);
1265:
1266: -- Standard call to check for call compatibility.
1267: IF NOT FND_API.Compatible_API_Call (l_api_version,
1268: p_api_version,
1269: l_api_name ,
1270: G_PKG_NAME)

Line 1474: -- Standard check of p_commit.

1470: END IF;
1471: END IF;
1472: END LOOP;
1473:
1474: -- Standard check of p_commit.
1475: IF FND_API.To_Boolean( p_commit ) THEN
1476: COMMIT WORK;
1477: END IF;
1478:

Line 1538: -- Standard Variables

1534: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1535: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
1536: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM)
1537: IS
1538: -- Standard Variables
1539: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_INTERNAL_REQ';
1540: l_api_version CONSTANT NUMBER := 1.0;
1541:
1542: -- Variables in FND log

Line 1588: -- Standard call to check for call compatibility.

1584:
1585: -- Log the api name in the log file
1586: Debug('At the Beginning of Refresh_Internal_Req', l_mod_name, 1);
1587:
1588: -- Standard call to check for call compatibility.
1589: IF NOT FND_API.Compatible_API_Call (l_api_version,
1590: p_api_version,
1591: l_api_name ,
1592: G_PKG_NAME)

Line 1801: -- Standard check of p_commit.

1797: CLOSE c_get_order_header_id;
1798: END IF;
1799: END LOOP;
1800:
1801: -- Standard check of p_commit.
1802: IF FND_API.To_Boolean( p_commit ) THEN
1803: COMMIT WORK;
1804: END IF;
1805:

Line 1865: -- Standard Variables

1861: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1862: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
1863: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM)
1864: IS
1865: -- Standard Variables
1866: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_INT_SALES_ORDER';
1867: l_api_version CONSTANT NUMBER := 1.0;
1868:
1869: -- Variables in FND log

Line 1899: -- Standard call to check for call compatibility.

1895:
1896: -- Log the api name in the log file
1897: Debug('At the Beginning of Refresh_Int_Sales_Order', l_mod_name, 1);
1898:
1899: -- Standard call to check for call compatibility.
1900: IF NOT FND_API.Compatible_API_Call (l_api_version,
1901: p_api_version,
1902: l_api_name ,
1903: G_PKG_NAME)

Line 2105: -- Standard check of p_commit.

2101: update_int_order_header_id(l_order_header_id);
2102: END IF;
2103: END LOOP;
2104:
2105: -- Standard check of p_commit.
2106: IF FND_API.To_Boolean( p_commit ) THEN
2107: COMMIT WORK;
2108: END IF;
2109:

Line 2169: -- Standard Variables

2165: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2166: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
2167: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM)
2168: IS
2169: -- Standard Variables
2170: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_RMA';
2171: l_api_version CONSTANT NUMBER := 1.0;
2172:
2173: -- Variables in FND log

Line 2202: -- Standard call to check for call compatibility.

2198:
2199: -- Log the api name in the log file
2200: Debug('At the Beginning of Refresh_RMA', l_mod_name, 1);
2201:
2202: -- Standard call to check for call compatibility.
2203: IF NOT FND_API.Compatible_API_Call (l_api_version,
2204: p_api_version,
2205: l_api_name ,
2206: G_PKG_NAME)

Line 2408: -- Standard check of p_commit.

2404: update_rma_ro_line_id(l_repair_line_id);
2405: END IF;
2406: END LOOP;
2407:
2408: -- Standard check of p_commit.
2409: IF FND_API.To_Boolean( p_commit ) THEN
2410: COMMIT WORK;
2411: END IF;
2412:

Line 2471: -- Standard Variables

2467: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2468: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
2469: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM)
2470: IS
2471: -- Standard Variables
2472: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_RMA_THIRD_PARTY';
2473: l_api_version CONSTANT NUMBER := 1.0;
2474:
2475: -- Variables in FND log

Line 2504: -- Standard call to check for call compatibility.

2500:
2501: -- Log the api name in the log file
2502: Debug('At the Beginning of Refresh_RMA_Third_Party', l_mod_name, 1);
2503:
2504: -- Standard call to check for call compatibility.
2505: IF NOT FND_API.Compatible_API_Call (l_api_version,
2506: p_api_version,
2507: l_api_name ,
2508: G_PKG_NAME)

Line 2711: -- Standard check of p_commit.

2707: update_rma_ro_line_id(l_repair_line_id);
2708: END IF;
2709: END LOOP;
2710:
2711: -- Standard check of p_commit.
2712: IF FND_API.To_Boolean( p_commit ) THEN
2713: COMMIT WORK;
2714: END IF;
2715:

Line 2775: -- Standard Variables

2771: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2772: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
2773: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM)
2774: IS
2775: -- Standard Variables
2776: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_SHIP';
2777: l_api_version CONSTANT NUMBER := 1.0;
2778:
2779: -- Variables in FND log

Line 2808: -- Standard call to check for call compatibility.

2804:
2805: -- Log the api name in the log file
2806: Debug('At the Beginning of Refresh_Ship', l_mod_name, 1);
2807:
2808: -- Standard call to check for call compatibility.
2809: IF NOT FND_API.Compatible_API_Call (l_api_version,
2810: p_api_version,
2811: l_api_name ,
2812: G_PKG_NAME)

Line 3015: -- Standard check of p_commit.

3011: update_ship_ro_line_id(l_repair_line_id);
3012: END IF;
3013: END LOOP;
3014:
3015: -- Standard check of p_commit.
3016: IF FND_API.To_Boolean( p_commit ) THEN
3017: COMMIT WORK;
3018: END IF;
3019:

Line 3079: -- Standard Variables

3075: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3076: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
3077: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM)
3078: IS
3079: -- Standard Variables
3080: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_SHIP_THIRD_PARTY';
3081: l_api_version CONSTANT NUMBER := 1.0;
3082:
3083: -- Variables in FND log

Line 3112: -- Standard call to check for call compatibility.

3108:
3109: -- Log the api name in the log file
3110: Debug('At the Beginning of Refresh_Ship_Third_Party', l_mod_name, 1);
3111:
3112: -- Standard call to check for call compatibility.
3113: IF NOT FND_API.Compatible_API_Call (l_api_version,
3114: p_api_version,
3115: l_api_name ,
3116: G_PKG_NAME)

Line 3319: -- Standard check of p_commit.

3315: update_ship_ro_line_id(l_repair_line_id);
3316: END IF;
3317: END LOOP;
3318:
3319: -- Standard check of p_commit.
3320: IF FND_API.To_Boolean( p_commit ) THEN
3321: COMMIT WORK;
3322: END IF;
3323:

Line 3383: -- Standard Variables

3379: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3380: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
3381: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM)
3382: IS
3383: -- Standard Variables
3384: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH_DELIVERY';
3385: l_api_version CONSTANT NUMBER := 1.0;
3386:
3387: -- Variables in FND log

Line 3416: -- Standard call to check for call compatibility.

3412:
3413: -- Log the api name in the log file
3414: Debug('At the Beginning of Refresh_Delivery', l_mod_name, 1);
3415:
3416: -- Standard call to check for call compatibility.
3417: IF NOT FND_API.Compatible_API_Call (l_api_version,
3418: p_api_version,
3419: l_api_name ,
3420: G_PKG_NAME)

Line 3459: wnd.delivery_type = 'STANDARD'

3455: oel.line_id = wdd.source_line_id AND
3456: wdd.delivery_detail_id = wda.delivery_detail_id AND
3457: wdd.source_code = 'OE' AND
3458: wnd.delivery_id = wda.delivery_id and
3459: wnd.delivery_type = 'STANDARD'
3460: and dpt.estimate_detail_id = edt.estimate_detail_id
3461: and edt.order_line_id = oel.line_id
3462: and dpt.repair_line_id = dra.repair_line_id
3463: and orgd.organization_id(+) = wnd.organization_id

Line 3627: -- Standard check of p_commit.

3623: update_ship_ro_line_id(l_repair_line_id);
3624: END IF;
3625: END LOOP;
3626:
3627: -- Standard check of p_commit.
3628: IF FND_API.To_Boolean( p_commit ) THEN
3629: COMMIT WORK;
3630: END IF;
3631:

Line 3697: -- Standard Variables

3693: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
3694: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
3695: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM)
3696: IS
3697: -- Standard Variables
3698: l_api_name CONSTANT VARCHAR2(30) := 'REFRESH';
3699: l_api_version CONSTANT NUMBER := 1.0;
3700:
3701: -- Variables in FND log

Line 3744: -- Standard call to check for call compatibility.

3740:
3741: -- Log the api name in the log file
3742: Debug('At the Beginning of Refresh', l_mod_name, 1);
3743:
3744: -- Standard call to check for call compatibility.
3745: IF NOT FND_API.Compatible_API_Call (l_api_version,
3746: p_api_version,
3747: l_api_name ,
3748: G_PKG_NAME)

Line 4354: -- Standard check of p_commit.

4350: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4351: x_return_status := l_return_status;
4352: END IF;
4353:
4354: -- Standard check of p_commit.
4355: IF FND_API.To_Boolean( p_commit ) THEN
4356: COMMIT WORK;
4357: END IF;
4358: