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.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 237: -- Standard check for p_commit

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

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

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

Line 400: -- Standard Start of API savepoint

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

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

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

Line 664: -- Standard check for p_commit

660: --
661: -- End of API body.
662: --
663:
664: -- Standard check for p_commit
665: IF FND_API.to_Boolean( p_commit )
666: THEN
667: COMMIT WORK;
668: END IF;

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

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

Line 753: -- Standard Start of API savepoint

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

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

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

Line 826: -- Standard check for p_commit

822: --
823: -- End of API body
824: --
825:
826: -- Standard check for p_commit
827: IF FND_API.to_Boolean( p_commit )
828: THEN
829: COMMIT WORK;
830: END IF;

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

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

Line 1348: -- Standard Start of API savepoint

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4149: -- standard naming in fnd_new_messages for Attachments message

4145: Close c_get_user_name;
4146:
4147: --This is a special case for attachment message details on Repair Order Split
4148: if (l_ref_REPH_rec.event_code = 'SLT') then
4149: -- standard naming in fnd_new_messages for Attachments message
4150: --ATTACHMENTS_PARAMC2 based on paramc2 value:'Y' => 'Attachments Copied
4151: --'else 'Attachments Not Copied'
4152: fnd_message.set_name('CSD','CSD_ATTACHMENTS_COPIED');
4153: l_attachments_copied := FND_MESSAGE.GET;

Line 4159: -- standard naming in fnd_new_messages for activity details

4155: l_attachments_not_copied := FND_MESSAGE.GET;
4156: end if;
4157:
4158:
4159: -- standard naming in fnd_new_messages for activity details
4160: fnd_message.set_name('CSD','CSD_ACTIVITY_DETAIL_' || l_ref_REPH_rec.EVENT_CODE);
4161:
4162: -- set the tokens for each respective event --
4163: