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_RO_BULLETINS_PVT dependencies on STANDARD

Line 57: --* Standard Start of API savepoint

53: ---- local constants ----
54: c_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_RO_BULLETINS';
55: c_API_VERSION_NUMBER CONSTANT NUMBER := G_L_API_VERSION_NUMBER;
56: BEGIN
57: --* Standard Start of API savepoint
58: SAVEPOINT CREATE_RO_BULLETIN_PVT;
59:
60: --* Standard call to check for call compatibility.
61: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,

Line 60: --* Standard call to check for call compatibility.

56: BEGIN
57: --* Standard Start of API savepoint
58: SAVEPOINT CREATE_RO_BULLETIN_PVT;
59:
60: --* Standard call to check for call compatibility.
61: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
62: p_api_version_number,
63: c_API_NAME,
64: G_PKG_NAME)

Line 103: --* Standard check for p_commit

99: END IF;
100:
101: --* logic ends here *--
102:
103: --* Standard check for p_commit
104: IF FND_API.to_Boolean( p_commit ) THEN
105: COMMIT WORK;
106: END IF;
107:

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

104: IF FND_API.to_Boolean( p_commit ) THEN
105: COMMIT WORK;
106: END IF;
107:
108: --* Standard call to get message count and if count is 1, get message info.
109: FND_MSG_PUB.Count_And_Get(
110: p_count => x_msg_count,
111: p_data => x_msg_data
112: );

Line 212: --* Standard Start of API savepoint

208: ---- Local Variables ----
209: l_ref_ro_bulletin_rec RO_BULLETIN_REC_TYPE;
210: l_rowid ROWID;
211: BEGIN
212: --* Standard Start of API savepoint
213: SAVEPOINT UPDATE_RO_BULLETIN_PVT;
214:
215: --* Standard call to check for call compatibility.
216: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,

Line 215: --* Standard call to check for call compatibility.

211: BEGIN
212: --* Standard Start of API savepoint
213: SAVEPOINT UPDATE_RO_BULLETIN_PVT;
214:
215: --* Standard call to check for call compatibility.
216: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
217: p_api_version_number,
218: c_API_NAME,
219: G_PKG_NAME)

Line 283: --* Standard check for p_commit

279: ,p_last_update_login => p_ro_bulletin_rec.last_update_login);
280:
281: --* logic ends here *--
282:
283: --* Standard check for p_commit
284: IF FND_API.to_Boolean( p_commit ) THEN
285: COMMIT WORK;
286: END IF;
287:

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

285: COMMIT WORK;
286: END IF;
287:
288:
289: --* Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get(
291: p_count => x_msg_count,
292: p_data => x_msg_data
293: );

Line 370: --* Standard Start of API savepoint

366: c_API_NAME CONSTANT VARCHAR2(30) := 'DELETE_RO_BULLETIN';
367: c_API_VERSION_NUMBER CONSTANT NUMBER := G_L_API_VERSION_NUMBER;
368:
369: BEGIN
370: --* Standard Start of API savepoint
371: SAVEPOINT DELETE_RO_BULLETIN_PVT;
372:
373: --* Standard call to check for call compatibility.
374: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,

Line 373: --* Standard call to check for call compatibility.

369: BEGIN
370: --* Standard Start of API savepoint
371: SAVEPOINT DELETE_RO_BULLETIN_PVT;
372:
373: --* Standard call to check for call compatibility.
374: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
375: p_api_version_number,
376: c_API_NAME,
377: G_PKG_NAME)

Line 399: --* Standard check for p_commit

395:
396:
397: -- logic ends here *--
398:
399: --* Standard check for p_commit
400: IF FND_API.to_Boolean( p_commit ) THEN
401: COMMIT WORK;
402: END IF;
403:

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

401: COMMIT WORK;
402: END IF;
403:
404:
405: --* Standard call to get message count and if count is 1, get message info.
406: FND_MSG_PUB.Count_And_Get(
407: p_count => x_msg_count,
408: p_data => x_msg_data
409: );

Line 484: --* Standard Start of API savepoint

480: c_API_NAME CONSTANT VARCHAR2(30) := 'LOCK_RO_BULLETIN';
481: c_API_VERSION_NUMBER CONSTANT NUMBER := G_L_API_VERSION_NUMBER;
482:
483: BEGIN
484: --* Standard Start of API savepoint
485: SAVEPOINT DELETE_RO_BULLETIN_PVT;
486:
487: --* Standard call to check for call compatibility.
488: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,

Line 487: --* Standard call to check for call compatibility.

483: BEGIN
484: --* Standard Start of API savepoint
485: SAVEPOINT DELETE_RO_BULLETIN_PVT;
486:
487: --* Standard call to check for call compatibility.
488: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
489: p_api_version_number,
490: c_API_NAME,
491: G_PKG_NAME)

Line 514: --* Standard check for p_commit

510: ,p_object_version_number => p_ro_bulletin_rec.object_version_number);
511:
512: --* logic ends here *--
513:
514: --* Standard check for p_commit
515: IF FND_API.to_Boolean( p_commit ) THEN
516: COMMIT WORK;
517: END IF;
518:

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

516: COMMIT WORK;
517: END IF;
518:
519:
520: --* Standard call to get message count and if count is 1, get message info.
521: FND_MSG_PUB.Count_And_Get(
522: p_count => x_msg_count,
523: p_data => x_msg_data
524: );

Line 614: --* Standard Start of API savepoint

610: l_rec_ind INTEGER := NULL;
611: l_repln_rec CSD_REPAIRS_PUB.REPLN_Rec_Type;
612:
613: BEGIN
614: --* Standard Start of API savepoint
615: SAVEPOINT LINK_BULLETINS_TO_RO_PVT;
616:
617: --* Standard call to check for call compatibility.
618: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,

Line 617: --* Standard call to check for call compatibility.

613: BEGIN
614: --* Standard Start of API savepoint
615: SAVEPOINT LINK_BULLETINS_TO_RO_PVT;
616:
617: --* Standard call to check for call compatibility.
618: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
619: p_api_version_number,
620: c_API_NAME,
621: G_PKG_NAME)

Line 780: --* Standard check for p_commit

776: l_rec_ind := l_rule_results_tbl.NEXT(l_rec_ind);
777: END LOOP; --* END loop that loops through all recs in the tbl *--
778: --* logic ends here *--
779:
780: --* Standard check for p_commit
781: IF FND_API.to_Boolean( p_commit ) THEN
782: COMMIT WORK;
783: END IF;
784:

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

781: IF FND_API.to_Boolean( p_commit ) THEN
782: COMMIT WORK;
783: END IF;
784:
785: --* Standard call to get message count and if count is 1, get message info.
786: FND_MSG_PUB.Count_And_Get(
787: p_count => x_msg_count,
788: p_data => x_msg_data
789: );

Line 940: --* Standard Start of API savepoint

936: WHERE customer_product_id = p_instance_id)
937: AND a.bulletin_id = p_bulletin_id
938: ; --* end cur_check_by_instance *--
939: BEGIN
940: --* Standard Start of API savepoint
941: SAVEPOINT CREATE_NEW_RO_BLTN_LINK_PVT;
942:
943: --* Standard call to check for call compatibility.
944: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,

Line 943: --* Standard call to check for call compatibility.

939: BEGIN
940: --* Standard Start of API savepoint
941: SAVEPOINT CREATE_NEW_RO_BLTN_LINK_PVT;
942:
943: --* Standard call to check for call compatibility.
944: IF NOT FND_API.Compatible_API_Call ( c_API_VERSION_NUMBER,
945: p_api_version_number,
946: c_API_NAME,
947: G_PKG_NAME)

Line 1173: --* Standard check for p_commit

1169:
1170: END IF; --* end IF (l_create_new_ro_bulletin_link = FND_API.G_TRUE) *--
1171: --* logic ends here *--
1172:
1173: --* Standard check for p_commit
1174: IF FND_API.to_Boolean( p_commit ) THEN
1175: COMMIT WORK;
1176: END IF;
1177:

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

1178: --** debug starts!!
1179: --dbms_output.put_line('in CREATE_NEW_RO_BULLETIN_LINK after check for p_commit ');
1180: --** debug ends!!
1181:
1182: --* Standard call to get message count and if count is 1, get message info.
1183: FND_MSG_PUB.Count_And_Get(
1184: p_count => x_msg_count,
1185: p_data => x_msg_data
1186: );

Line 1281: /* STANDARD PARAMETERS */

1277: /*--------------------------------------------------------------------*/
1278: /* procedure name: LINK_BULLETINS_TO_REPAIRS_CP */
1279: /* description : Links all active bulletins to all matching repairs */
1280: /* */
1281: /* STANDARD PARAMETERS */
1282: /* In Parameters : */
1283: /* */
1284: /* Output Parameters: */
1285: /* errbuf VARCHAR2 Error message */

Line 1288: /* NON-STANDARD PARAMETERS */

1284: /* Output Parameters: */
1285: /* errbuf VARCHAR2 Error message */
1286: /* retcode VARCHAR2 Error Code */
1287: /* */
1288: /* NON-STANDARD PARAMETERS */
1289: /* In Parameters */
1290: /* p_params RO_BULLETIN_PARAMS_REC_TYPE Req */
1291: /* */
1292: /* */

Line 1326: -- STANDARD API and DEBUG CONSTANTS --

1322: l_success_status CONSTANT VARCHAR2(1) := '0';
1323: l_warning_status CONSTANT VARCHAR2(1) := '1';
1324: l_error_status CONSTANT VARCHAR2(1) := '2';
1325:
1326: -- STANDARD API and DEBUG CONSTANTS --
1327: l_api_name CONSTANT VARCHAR2(30) := 'LINK_BULLETINS_TO_REPAIRS_CP';
1328: l_api_version CONSTANT NUMBER := 1.0;
1329:
1330: -- VARIABLES FOR FND LOG --

Line 1466: -- STANDARD CONSTANTS

1462: from CSD_RULES_B
1463: where rule_id = p_rule_id;
1464:
1465:
1466: -- STANDARD CONSTANTS
1467: l_api_name CONSTANT VARCHAR2(30) := 'LINK_BULLETIN_FOR_RULE';
1468: l_api_version CONSTANT NUMBER := 1.0;
1469:
1470: -- VARIABLES FOR FND LOG --

Line 1483: -- Standard Start of API savepoint

1479: l_bulletin_id NUMBER;
1480:
1481: BEGIN
1482:
1483: -- Standard Start of API savepoint
1484: SAVEPOINT LINK_BULLETIN_FOR_RULE;
1485:
1486: -- Initialize API return status to success
1487: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1490: --dbms_output.put_line('At the Beginning of LINK_BULLETIN_FOR_RULE');
1491: --dbms_output.put_line('p_bulletin_id ='||p_bulletin_id);
1492: --dbms_output.put_line('p_bulletin_rule_id ='||p_bulletin_rule_id);
1493:
1494: -- Standard call to check for call compatibility.
1495: IF NOT FND_API.Compatible_API_Call (l_api_version,
1496: p_api_version_number,
1497: l_api_name ,
1498: G_PKG_NAME )

Line 1602: -- Standard check of p_commit.

1598: RAISE FND_API.G_EXC_ERROR;
1599: END IF;
1600: END LOOP;
1601:
1602: -- Standard check of p_commit.
1603: IF FND_API.To_Boolean( p_commit ) THEN
1604: COMMIT WORK;
1605: END IF;
1606:

Line 1607: -- Standard call to get message count and IF count is get message info.

1603: IF FND_API.To_Boolean( p_commit ) THEN
1604: COMMIT WORK;
1605: END IF;
1606:
1607: -- Standard call to get message count and IF count is get message info.
1608: FND_MSG_PUB.Count_And_Get
1609: (p_count => x_msg_count,
1610: p_data => x_msg_data );
1611: EXCEPTION

Line 1746: -- STANDARD CONSTANTS

1742: SELECT inventory_item_id
1743: FROM CSD_REPAIRS
1744: WHERE repair_line_id = p_repair_line_id;
1745:
1746: -- STANDARD CONSTANTS
1747: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_BULLETIN_SCS_TO_RO';
1748: l_api_version CONSTANT NUMBER := 1.0;
1749:
1750: -- VARIABLES FOR FND LOG --

Line 1762: -- Standard Start of API savepoint

1758: l_obj_ver_number NUMBER;
1759:
1760: BEGIN
1761:
1762: -- Standard Start of API savepoint
1763: SAVEPOINT APPLY_BULLETIN_SCS_TO_RO;
1764:
1765: -- Initialize API return status to success
1766: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1768: -- Log the api name in the log file
1769: --dbms_output.put_line('At the Beginning of APPLY_BULLETIN_SCS_TO_RO');
1770: --dbms_output.put_line('p_repair_line_id ='||p_repair_line_id);
1771:
1772: -- Standard call to check for call compatibility.
1773: IF NOT FND_API.Compatible_API_Call (l_api_version,
1774: p_api_version_number,
1775: l_api_name ,
1776: G_PKG_NAME )

Line 1872: -- Standard check of p_commit.

1868: END IF; -- end if (l_in_domain is not null)
1869:
1870: END LOOP;
1871:
1872: -- Standard check of p_commit.
1873: IF FND_API.To_Boolean( p_commit ) THEN
1874: COMMIT WORK;
1875: END IF;
1876:

Line 1877: -- Standard call to get message count and IF count is get message info.

1873: IF FND_API.To_Boolean( p_commit ) THEN
1874: COMMIT WORK;
1875: END IF;
1876:
1877: -- Standard call to get message count and IF count is get message info.
1878: FND_MSG_PUB.Count_And_Get
1879: (p_count => x_msg_count,
1880: p_data => x_msg_data );
1881: