DBA Data[Home] [Help]

APPS.CSD_REPAIR_HISTORY_PVT dependencies on STANDARD

Line 39: -- Standard Start of API savepoint

35: l_api_version_number CONSTANT NUMBER := 1.0;
36: l_return_status_full VARCHAR2(1);
37: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT CREATE_REPAIR_HISTORY_PVT;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT CREATE_REPAIR_HISTORY_PVT;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
44: p_api_version_number,
45: l_api_name,
46: G_PKG_NAME)

Line 235: -- Standard check for p_commit

231: --
232: -- End of API body
233: --
234:
235: -- Standard check for p_commit
236: IF FND_API.to_Boolean( p_commit )
237: THEN
238: COMMIT WORK;
239: END IF;

Line 246: -- Standard call to get message count and if count is 1, get message info.

242: -- Debug Message
243: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
244:
245:
246: -- Standard call to get message count and if count is 1, get message info.
247: FND_MSG_PUB.Count_And_Get
248: ( p_count => x_msg_count,
249: p_data => x_msg_data
250: );

Line 398: -- Standard Start of API savepoint

394: -- travi ovn validation
395: l_OBJECT_VERSION_NUMBER NUMBER;
396:
397: BEGIN
398: -- Standard Start of API savepoint
399: SAVEPOINT UPDATE_REPAIR_HISTORY_PVT;
400:
401: -- Standard call to check for call compatibility.
402: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

397: BEGIN
398: -- Standard Start of API savepoint
399: SAVEPOINT UPDATE_REPAIR_HISTORY_PVT;
400:
401: -- Standard call to check for call compatibility.
402: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
403: p_api_version_number,
404: l_api_name,
405: G_PKG_NAME)

Line 660: -- Standard check for p_commit

656: --
657: -- End of API body.
658: --
659:
660: -- Standard check for p_commit
661: IF FND_API.to_Boolean( p_commit )
662: THEN
663: COMMIT WORK;
664: END IF;

Line 671: -- Standard call to get message count and if count is 1, get message info.

667: -- Debug Message
668: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
669:
670:
671: -- Standard call to get message count and if count is 1, get message info.
672: FND_MSG_PUB.Count_And_Get
673: ( p_count => x_msg_count,
674: p_data => x_msg_data
675: );

Line 749: -- Standard Start of API savepoint

745: l_api_name CONSTANT VARCHAR2(30) := 'Delete_repair_history';
746: l_api_version_number CONSTANT NUMBER := 1.0;
747: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
748: BEGIN
749: -- Standard Start of API savepoint
750: SAVEPOINT DELETE_REPAIR_HISTORY_PVT;
751:
752: -- Standard call to check for call compatibility.
753: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

748: BEGIN
749: -- Standard Start of API savepoint
750: SAVEPOINT DELETE_REPAIR_HISTORY_PVT;
751:
752: -- Standard call to check for call compatibility.
753: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
754: p_api_version_number,
755: l_api_name,
756: G_PKG_NAME)

Line 822: -- Standard check for p_commit

818: --
819: -- End of API body
820: --
821:
822: -- Standard check for p_commit
823: IF FND_API.to_Boolean( p_commit )
824: THEN
825: COMMIT WORK;
826: END IF;

Line 833: -- Standard call to get message count and if count is 1, get message info.

829: -- Debug Message
830: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
831:
832:
833: -- Standard call to get message count and if count is 1, get message info.
834: FND_MSG_PUB.Count_And_Get
835: ( p_count => x_msg_count,
836: p_data => x_msg_data
837: );

Line 1344: -- Standard Start of API savepoint

1340: -- Local scratch record
1341: l_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;
1342: l_crit_REPH_rec CSD_REPAIR_HISTORY_Pvt.REPH_Rec_Type;
1343: BEGIN
1344: -- Standard Start of API savepoint
1345: SAVEPOINT GET_REPAIR_HISTORY_PVT;
1346:
1347: -- Standard call to check for call compatibility.
1348: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1343: BEGIN
1344: -- Standard Start of API savepoint
1345: SAVEPOINT GET_REPAIR_HISTORY_PVT;
1346:
1347: -- Standard call to check for call compatibility.
1348: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1349: p_api_version_number,
1350: l_api_name,
1351: G_PKG_NAME)

Line 1515: -- Standard call to get message count and if count is 1, get message info.

1511: -- Debug Message
1512: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: ' || l_api_name || 'end');
1513:
1514:
1515: -- Standard call to get message count and if count is 1, get message info.
1516: FND_MSG_PUB.Count_And_Get
1517: ( p_count => x_msg_count,
1518: p_data => x_msg_data
1519: );

Line 1603: -- Standard call to get message count and if count is 1, get message info.

1599: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1600: NULL;
1601: END IF;
1602:
1603: -- Standard call to get message count and if count is 1, get message info.
1604: FND_MSG_PUB.Count_And_Get
1605: ( p_count => x_msg_count,
1606: p_data => x_msg_data
1607: );

Line 1650: -- Standard call to get message count and if count is 1, get message info.

1646: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1647: NULL;
1648: END IF;
1649:
1650: -- Standard call to get message count and if count is 1, get message info.
1651: FND_MSG_PUB.Count_And_Get
1652: ( p_count => x_msg_count,
1653: p_data => x_msg_data
1654: );

Line 1704: -- Standard call to get message count and if count is 1, get message info.

1700: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1701: NULL;
1702: END IF;
1703:
1704: -- Standard call to get message count and if count is 1, get message info.
1705: FND_MSG_PUB.Count_And_Get
1706: ( p_count => x_msg_count,
1707: p_data => x_msg_data
1708: );

Line 1758: -- Standard call to get message count and if count is 1, get message info.

1754: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1755: NULL;
1756: END IF;
1757:
1758: -- Standard call to get message count and if count is 1, get message info.
1759: FND_MSG_PUB.Count_And_Get
1760: ( p_count => x_msg_count,
1761: p_data => x_msg_data
1762: );

Line 1814: -- Standard call to get message count and if count is 1, get message info.

1810: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1811: NULL;
1812: END IF;
1813:
1814: -- Standard call to get message count and if count is 1, get message info.
1815: FND_MSG_PUB.Count_And_Get
1816: ( p_count => x_msg_count,
1817: p_data => x_msg_data
1818: );

Line 1868: -- Standard call to get message count and if count is 1, get message info.

1864: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1865: NULL;
1866: END IF;
1867:
1868: -- Standard call to get message count and if count is 1, get message info.
1869: FND_MSG_PUB.Count_And_Get
1870: ( p_count => x_msg_count,
1871: p_data => x_msg_data
1872: );

Line 1915: -- Standard call to get message count and if count is 1, get message info.

1911: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1912: NULL;
1913: END IF;
1914:
1915: -- Standard call to get message count and if count is 1, get message info.
1916: FND_MSG_PUB.Count_And_Get
1917: ( p_count => x_msg_count,
1918: p_data => x_msg_data
1919: );

Line 1962: -- Standard call to get message count and if count is 1, get message info.

1958: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1959: NULL;
1960: END IF;
1961:
1962: -- Standard call to get message count and if count is 1, get message info.
1963: FND_MSG_PUB.Count_And_Get
1964: ( p_count => x_msg_count,
1965: p_data => x_msg_data
1966: );

Line 2009: -- Standard call to get message count and if count is 1, get message info.

2005: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2006: NULL;
2007: END IF;
2008:
2009: -- Standard call to get message count and if count is 1, get message info.
2010: FND_MSG_PUB.Count_And_Get
2011: ( p_count => x_msg_count,
2012: p_data => x_msg_data
2013: );

Line 2056: -- Standard call to get message count and if count is 1, get message info.

2052: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2053: NULL;
2054: END IF;
2055:
2056: -- Standard call to get message count and if count is 1, get message info.
2057: FND_MSG_PUB.Count_And_Get
2058: ( p_count => x_msg_count,
2059: p_data => x_msg_data
2060: );

Line 2103: -- Standard call to get message count and if count is 1, get message info.

2099: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2100: NULL;
2101: END IF;
2102:
2103: -- Standard call to get message count and if count is 1, get message info.
2104: FND_MSG_PUB.Count_And_Get
2105: ( p_count => x_msg_count,
2106: p_data => x_msg_data
2107: );

Line 2150: -- Standard call to get message count and if count is 1, get message info.

2146: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2147: NULL;
2148: END IF;
2149:
2150: -- Standard call to get message count and if count is 1, get message info.
2151: FND_MSG_PUB.Count_And_Get
2152: ( p_count => x_msg_count,
2153: p_data => x_msg_data
2154: );

Line 2197: -- Standard call to get message count and if count is 1, get message info.

2193: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2194: NULL;
2195: END IF;
2196:
2197: -- Standard call to get message count and if count is 1, get message info.
2198: FND_MSG_PUB.Count_And_Get
2199: ( p_count => x_msg_count,
2200: p_data => x_msg_data
2201: );

Line 2244: -- Standard call to get message count and if count is 1, get message info.

2240: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2241: NULL;
2242: END IF;
2243:
2244: -- Standard call to get message count and if count is 1, get message info.
2245: FND_MSG_PUB.Count_And_Get
2246: ( p_count => x_msg_count,
2247: p_data => x_msg_data
2248: );

Line 2291: -- Standard call to get message count and if count is 1, get message info.

2287: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2288: NULL;
2289: END IF;
2290:
2291: -- Standard call to get message count and if count is 1, get message info.
2292: FND_MSG_PUB.Count_And_Get
2293: ( p_count => x_msg_count,
2294: p_data => x_msg_data
2295: );

Line 2338: -- Standard call to get message count and if count is 1, get message info.

2334: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2335: NULL;
2336: END IF;
2337:
2338: -- Standard call to get message count and if count is 1, get message info.
2339: FND_MSG_PUB.Count_And_Get
2340: ( p_count => x_msg_count,
2341: p_data => x_msg_data
2342: );

Line 2385: -- Standard call to get message count and if count is 1, get message info.

2381: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2382: NULL;
2383: END IF;
2384:
2385: -- Standard call to get message count and if count is 1, get message info.
2386: FND_MSG_PUB.Count_And_Get
2387: ( p_count => x_msg_count,
2388: p_data => x_msg_data
2389: );

Line 2432: -- Standard call to get message count and if count is 1, get message info.

2428: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2429: NULL;
2430: END IF;
2431:
2432: -- Standard call to get message count and if count is 1, get message info.
2433: FND_MSG_PUB.Count_And_Get
2434: ( p_count => x_msg_count,
2435: p_data => x_msg_data
2436: );

Line 2479: -- Standard call to get message count and if count is 1, get message info.

2475: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2476: NULL;
2477: END IF;
2478:
2479: -- Standard call to get message count and if count is 1, get message info.
2480: FND_MSG_PUB.Count_And_Get
2481: ( p_count => x_msg_count,
2482: p_data => x_msg_data
2483: );

Line 2526: -- Standard call to get message count and if count is 1, get message info.

2522: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2523: NULL;
2524: END IF;
2525:
2526: -- Standard call to get message count and if count is 1, get message info.
2527: FND_MSG_PUB.Count_And_Get
2528: ( p_count => x_msg_count,
2529: p_data => x_msg_data
2530: );

Line 2573: -- Standard call to get message count and if count is 1, get message info.

2569: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2570: NULL;
2571: END IF;
2572:
2573: -- Standard call to get message count and if count is 1, get message info.
2574: FND_MSG_PUB.Count_And_Get
2575: ( p_count => x_msg_count,
2576: p_data => x_msg_data
2577: );

Line 2620: -- Standard call to get message count and if count is 1, get message info.

2616: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2617: NULL;
2618: END IF;
2619:
2620: -- Standard call to get message count and if count is 1, get message info.
2621: FND_MSG_PUB.Count_And_Get
2622: ( p_count => x_msg_count,
2623: p_data => x_msg_data
2624: );

Line 2667: -- Standard call to get message count and if count is 1, get message info.

2663: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2664: NULL;
2665: END IF;
2666:
2667: -- Standard call to get message count and if count is 1, get message info.
2668: FND_MSG_PUB.Count_And_Get
2669: ( p_count => x_msg_count,
2670: p_data => x_msg_data
2671: );

Line 2714: -- Standard call to get message count and if count is 1, get message info.

2710: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2711: NULL;
2712: END IF;
2713:
2714: -- Standard call to get message count and if count is 1, get message info.
2715: FND_MSG_PUB.Count_And_Get
2716: ( p_count => x_msg_count,
2717: p_data => x_msg_data
2718: );

Line 2761: -- Standard call to get message count and if count is 1, get message info.

2757: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2758: NULL;
2759: END IF;
2760:
2761: -- Standard call to get message count and if count is 1, get message info.
2762: FND_MSG_PUB.Count_And_Get
2763: ( p_count => x_msg_count,
2764: p_data => x_msg_data
2765: );

Line 2808: -- Standard call to get message count and if count is 1, get message info.

2804: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2805: NULL;
2806: END IF;
2807:
2808: -- Standard call to get message count and if count is 1, get message info.
2809: FND_MSG_PUB.Count_And_Get
2810: ( p_count => x_msg_count,
2811: p_data => x_msg_data
2812: );

Line 2855: -- Standard call to get message count and if count is 1, get message info.

2851: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2852: NULL;
2853: END IF;
2854:
2855: -- Standard call to get message count and if count is 1, get message info.
2856: FND_MSG_PUB.Count_And_Get
2857: ( p_count => x_msg_count,
2858: p_data => x_msg_data
2859: );

Line 2902: -- Standard call to get message count and if count is 1, get message info.

2898: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2899: NULL;
2900: END IF;
2901:
2902: -- Standard call to get message count and if count is 1, get message info.
2903: FND_MSG_PUB.Count_And_Get
2904: ( p_count => x_msg_count,
2905: p_data => x_msg_data
2906: );

Line 2949: -- Standard call to get message count and if count is 1, get message info.

2945: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2946: NULL;
2947: END IF;
2948:
2949: -- Standard call to get message count and if count is 1, get message info.
2950: FND_MSG_PUB.Count_And_Get
2951: ( p_count => x_msg_count,
2952: p_data => x_msg_data
2953: );

Line 2996: -- Standard call to get message count and if count is 1, get message info.

2992: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2993: NULL;
2994: END IF;
2995:
2996: -- Standard call to get message count and if count is 1, get message info.
2997: FND_MSG_PUB.Count_And_Get
2998: ( p_count => x_msg_count,
2999: p_data => x_msg_data
3000: );

Line 3043: -- Standard call to get message count and if count is 1, get message info.

3039: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3040: NULL;
3041: END IF;
3042:
3043: -- Standard call to get message count and if count is 1, get message info.
3044: FND_MSG_PUB.Count_And_Get
3045: ( p_count => x_msg_count,
3046: p_data => x_msg_data
3047: );

Line 3090: -- Standard call to get message count and if count is 1, get message info.

3086: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3087: NULL;
3088: END IF;
3089:
3090: -- Standard call to get message count and if count is 1, get message info.
3091: FND_MSG_PUB.Count_And_Get
3092: ( p_count => x_msg_count,
3093: p_data => x_msg_data
3094: );

Line 3137: -- Standard call to get message count and if count is 1, get message info.

3133: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3134: NULL;
3135: END IF;
3136:
3137: -- Standard call to get message count and if count is 1, get message info.
3138: FND_MSG_PUB.Count_And_Get
3139: ( p_count => x_msg_count,
3140: p_data => x_msg_data
3141: );

Line 3184: -- Standard call to get message count and if count is 1, get message info.

3180: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3181: NULL;
3182: END IF;
3183:
3184: -- Standard call to get message count and if count is 1, get message info.
3185: FND_MSG_PUB.Count_And_Get
3186: ( p_count => x_msg_count,
3187: p_data => x_msg_data
3188: );

Line 3231: -- Standard call to get message count and if count is 1, get message info.

3227: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3228: NULL;
3229: END IF;
3230:
3231: -- Standard call to get message count and if count is 1, get message info.
3232: FND_MSG_PUB.Count_And_Get
3233: ( p_count => x_msg_count,
3234: p_data => x_msg_data
3235: );

Line 3278: -- Standard call to get message count and if count is 1, get message info.

3274: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3275: NULL;
3276: END IF;
3277:
3278: -- Standard call to get message count and if count is 1, get message info.
3279: FND_MSG_PUB.Count_And_Get
3280: ( p_count => x_msg_count,
3281: p_data => x_msg_data
3282: );

Line 3325: -- Standard call to get message count and if count is 1, get message info.

3321: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3322: NULL;
3323: END IF;
3324:
3325: -- Standard call to get message count and if count is 1, get message info.
3326: FND_MSG_PUB.Count_And_Get
3327: ( p_count => x_msg_count,
3328: p_data => x_msg_data
3329: );

Line 3406: -- Standard call to get message count and if count is 1, get message info.

3402: end if;
3403:
3404: END IF;
3405:
3406: -- Standard call to get message count and if count is 1, get message info.
3407: FND_MSG_PUB.Count_And_Get
3408: ( p_count => x_msg_count,
3409: p_data => x_msg_data
3410: );

Line 3449: -- Standard call to get message count and if count is 1, get message info.

3445:
3446: -- Debug Message
3447: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'API_INVALID_RECORD');
3448:
3449: -- Standard call to get message count and if count is 1, get message info.
3450: FND_MSG_PUB.Count_And_Get
3451: ( p_count => x_msg_count,
3452: p_data => x_msg_data
3453: );