DBA Data[Home] [Help]

APPS.AHL_DI_DOC_INDEX_PVT dependencies on STANDARD

Line 474: -- Standard Start of API savepoint

470: l_document_id NUMBER;
471: l_document_info doc_rec;
472: l_rowid1 varchar2(30);
473: BEGIN
474: -- Standard Start of API savepoint
475: SAVEPOINT create_document;
476: -- Check if API is called in debug mode. If yes, enable debug.
477: IF G_DEBUG='Y' THEN
478: AHL_DEBUG_PUB.enable_debug;

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

484: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.create_document','+DI+');
485:
486: END IF;
487: END IF;
488: -- Standard call to check for call compatibility.
489: IF FND_API.to_boolean(p_init_msg_list)
490: THEN
491: FND_MSG_PUB.initialize;
492: END IF;

Line 522: --Standard Call to count messages

518: p_object_version_number => p_x_document_tbl(i).object_version_number,
519: p_delete_flag => p_x_document_tbl(i).delete_flag);
520:
521: END LOOP;
522: --Standard Call to count messages
523: l_msg_count := FND_MSG_PUB.count_msg;
524:
525: IF l_msg_count > 0 THEN
526: X_msg_count := l_msg_count;

Line 668: --Standard check for message count

664: x_msg_count => x_msg_count ,
665: x_msg_data => x_msg_data
666: );
667: END IF;
668: --Standard check for message count
669: l_msg_count := FND_MSG_PUB.count_msg;
670:
671: IF l_msg_count > 0 THEN
672: X_msg_count := l_msg_count;

Line 676: --Standard check for commit;

672: X_msg_count := l_msg_count;
673: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
674: RAISE FND_API.G_EXC_ERROR;
675: END IF;
676: --Standard check for commit;
677: IF FND_API.TO_BOOLEAN(p_commit) THEN
678: COMMIT;
679: --DBMS_OUTPUT.PUT_LINE('THE RECORD IS NOT COMMITTED .THE TEST RUN HAS BEEN SUCESSFUL');
680: --ROLLBACK;

Line 812: -- Standard Start of API savepoint

808: l_document_info get_doc_rec_b_info%ROWTYPE;
809: --
810: l_num VARCHAR2(10);
811: BEGIN
812: -- Standard Start of API savepoint
813: SAVEPOINT modify_document;
814:
815: -- Check if API is called in debug mode. If yes, enable debug.
816: IF G_DEBUG='Y' THEN

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

823: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.modify_document','+DI+');
824:
825: END IF;
826: END IF;
827: -- Standard call to check for call compatibility.
828: IF FND_API.to_boolean(p_init_msg_list)
829: THEN
830: FND_MSG_PUB.initialize;
831: END IF;

Line 860: --Standard check to count messages

856: p_subscribe_to_flag => p_x_document_tbl(i).subscribe_to_flag,
857: p_object_version_number => p_x_document_tbl(i).object_version_number,
858: p_delete_flag => p_x_document_tbl(i).delete_flag);
859: END LOOP;
860: --Standard check to count messages
861: l_msg_count := FND_MSG_PUB.count_msg;
862:
863: IF l_msg_count > 0 THEN
864: X_msg_count := l_msg_count;

Line 976: --Standard check for message count

972: x_msg_count => x_msg_count ,
973: x_msg_data => x_msg_data
974: );
975: END IF;
976: --Standard check for message count
977: l_msg_count := FND_MSG_PUB.count_msg;
978:
979: IF l_msg_count > 0 THEN
980: X_msg_count := l_msg_count;

Line 984: --Standard check for commit

980: X_msg_count := l_msg_count;
981: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984: --Standard check for commit
985: IF FND_API.TO_BOOLEAN(p_commit) THEN
986: COMMIT;
987: END IF;
988: -- Debug info

Line 1315: -- Standard Start of API savepoint

1311: l_supplier_name VARCHAR2(360);
1312: l_supplier_info supplier_rec;
1313: l_prod_install_status VARCHAR2(30);
1314: BEGIN
1315: -- Standard Start of API savepoint
1316: SAVEPOINT create_supplier;
1317: -- Check if API is called in debug mode. If yes, enable debug.
1318: IF G_DEBUG='Y' THEN
1319: AHL_DEBUG_PUB.enable_debug;

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

1322: IF G_DEBUG='Y' THEN
1323: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Create Supplier','+SUP+');
1324: END IF;
1325:
1326: -- Standard call to check for call compatibility.
1327: IF FND_API.to_boolean(p_init_msg_list)
1328: THEN
1329: FND_MSG_PUB.initialize;
1330: END IF;

Line 1365: -- Standard call to get message count and if count is get message info.

1361: p_preference_code => p_x_supplier_tbl(i).preference_code,
1362: p_delete_flag => p_x_supplier_tbl(i).delete_flag
1363: );
1364: END LOOP;
1365: -- Standard call to get message count and if count is get message info.
1366: l_msg_count := FND_MSG_PUB.count_msg;
1367:
1368: IF l_msg_count > 0 THEN
1369: X_msg_count := l_msg_count;

Line 1514: -- Standard check of p_commit.

1510: RAISE FND_API.G_EXC_ERROR;
1511: END IF;
1512: --{{adharia
1513:
1514: -- Standard check of p_commit.
1515: IF FND_API.TO_BOOLEAN(p_commit) THEN
1516: COMMIT;
1517: END IF;
1518: -- Debug info

Line 1671: -- Standard Start of API savepoint

1667: l_supplier_name VARCHAR2(390);
1668: l_supplier_info get_supplier_rec_info%ROWTYPE;
1669: l_prod_install_status VARCHAR2(30);
1670: BEGIN
1671: -- Standard Start of API savepoint
1672: SAVEPOINT modify_supplier;
1673: -- Check if API is called in debug mode. If yes, enable debug.
1674: IF G_DEBUG='Y' THEN
1675: AHL_DEBUG_PUB.enable_debug;

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

1679: IF G_DEBUG='Y' THEN
1680: AHL_DEBUG_PUB.debug( 'anand enter ahl_di_doc_index_pvt.Modify Supplier','+SUP+');
1681: END IF;
1682:
1683: -- Standard call to check for call compatibility.
1684: IF FND_API.to_boolean(p_init_msg_list)
1685: THEN
1686: FND_MSG_PUB.initialize;
1687: END IF;

Line 1732: -- Standard call to get message count

1728: p_delete_flag => p_supplier_tbl(i).delete_flag
1729: );
1730: END LOOP;
1731: --End of Validations
1732: -- Standard call to get message count
1733: l_msg_count := FND_MSG_PUB.count_msg;
1734: --ad
1735: IF G_DEBUG='Y' THEN
1736: IF G_DEBUG='Y' THEN

Line 1874: -- Standard check of p_commit.

1870: RAISE FND_API.G_EXC_ERROR;
1871: END IF;
1872: --{{ADHARIA
1873:
1874: -- Standard check of p_commit.
1875: IF FND_API.TO_BOOLEAN(p_commit) THEN
1876: COMMIT;
1877: END IF;
1878:

Line 2040: -- Standard Start of API savepoint

2036: l_supplier_name VARCHAR2(30);
2037: l_dummy VARCHAR2(2000);
2038: l_prod_install_status VARCHAR2(30);
2039: BEGIN
2040: -- Standard Start of API savepoint
2041: SAVEPOINT delete_supplier;
2042: -- Check if API is called in debug mode. If yes, enable debug.
2043: IF G_DEBUG='Y' THEN
2044: AHL_DEBUG_PUB.enable_debug;

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

2047: -- Debug info.
2048: IF G_DEBUG='Y' THEN
2049: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Delete Supplier','+SUP+');
2050: END IF;
2051: -- Standard call to check for call compatibility.
2052: IF FND_API.to_boolean(p_init_msg_list)
2053: THEN
2054: FND_MSG_PUB.initialize;
2055: END IF;

Line 2131: -- Standard call to get message count

2127: -- Delete the record from suppliers table
2128: DELETE FROM AHL_SUPPLIER_DOCUMENTS
2129: WHERE ROWID = l_rowid;
2130: --END IF;
2131: -- Standard call to get message count
2132: l_msg_count := FND_MSG_PUB.count_msg;
2133:
2134: IF l_msg_count > 0 THEN
2135: X_msg_count := l_msg_count;

Line 2140: -- Standard check of p_commit.

2136: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2137: --AD RAISE FND_API.G_EXC_ERROR;
2138: END IF;
2139:
2140: -- Standard check of p_commit.
2141: IF FND_API.TO_BOOLEAN(p_commit) THEN
2142: COMMIT;
2143: END IF;
2144: -- Debug info

Line 2385: -- Standard Start of API savepoint

2381: l_dummy VARCHAR2(2000);
2382: l_recipient_document_id NUMBER;
2383: l_recipient_info Recipient_rec;
2384: BEGIN
2385: -- Standard Start of API savepoint
2386: SAVEPOINT create_recipient;
2387: -- Check if API is called in debug mode. If yes, enable debug.
2388: IF G_DEBUG='Y' THEN
2389: AHL_DEBUG_PUB.enable_debug;

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

2395: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Create Recipient','+REP+');
2396:
2397: END IF;
2398: END IF;
2399: -- Standard call to check for call compatibility.
2400: IF FND_API.to_boolean(p_init_msg_list)
2401: THEN
2402: FND_MSG_PUB.initialize;
2403: END IF;

Line 2426: -- Standard call to get message count and if count is get message info.

2422: p_document_id => p_x_recipient_tbl(i).document_id,
2423: p_object_version_number => p_x_recipient_tbl(i).object_version_number,
2424: p_delete_flag => p_x_recipient_tbl(i).delete_flag);
2425: END LOOP;
2426: -- Standard call to get message count and if count is get message info.
2427: l_msg_count := FND_MSG_PUB.count_msg;
2428:
2429: IF l_msg_count > 0 THEN
2430: X_msg_count := l_msg_count;

Line 2533: -- Standard check to count messages

2529: fnd_global.user_id,
2530: fnd_global.login_id
2531: );
2532: p_x_recipient_tbl(i).recipient_document_id := l_recipient_document_id;
2533: -- Standard check to count messages
2534: /*adharia
2535: l_msg_count := FND_MSG_PUB.count_msg;
2536:
2537: IF l_msg_count > 0 THEN

Line 2558: -- Standard check of p_commit.

2554: RAISE FND_API.G_EXC_ERROR;
2555: end if;
2556: --adharia
2557:
2558: -- Standard check of p_commit.
2559: IF FND_API.TO_BOOLEAN(p_commit) THEN
2560: COMMIT;
2561: END IF;
2562: -- Debug info

Line 2688: -- Standard Start of API savepoint

2684: l_document_id NUMBER;
2685: l_recipient_document_id NUMBER;
2686: l_recipient_info get_recipient_rec_info%ROWTYPE;
2687: BEGIN
2688: -- Standard Start of API savepoint
2689: SAVEPOINT modify_recipient;
2690: -- Check if API is called in debug mode. If yes, enable debug.
2691:
2692: IF G_DEBUG='Y' THEN

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

2699: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Modify Recipient','+REP+');
2700:
2701: END IF;
2702: END IF;
2703: -- Standard call to check for call compatibility.
2704: IF FND_API.to_boolean(p_init_msg_list)
2705: THEN
2706: FND_MSG_PUB.initialize;
2707: END IF;

Line 2731: --Standard call to count messages

2727: p_object_version_number => p_recipient_tbl(i).object_version_number,
2728: p_delete_flag => p_recipient_tbl(i).delete_flag
2729: );
2730: END LOOP;
2731: --Standard call to count messages
2732: l_msg_count := FND_MSG_PUB.count_msg;
2733:
2734: IF l_msg_count > 0 THEN
2735: X_msg_count := l_msg_count;

Line 2827: -- Standard check of p_commit.

2823: END IF;
2824: end if;--ad
2825: END LOOP;
2826: END IF;
2827: -- Standard check of p_commit.
2828: IF FND_API.TO_BOOLEAN(p_commit) THEN
2829: COMMIT;
2830: END IF;
2831: -- Debug info

Line 2946: -- Standard Start of API savepoint

2942: l_rowid ROWID;
2943: l_object_version_number NUMBER;
2944:
2945: BEGIN
2946: -- Standard Start of API savepoint
2947: SAVEPOINT delete_recipient;
2948: -- Check if API is called in debug mode. If yes, enable debug.
2949:
2950: IF G_DEBUG='Y' THEN

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

2957: AHL_DEBUG_PUB.debug( 'enter ahl_di_doc_index_pvt.Delete Recipient','+REP+');
2958:
2959: END IF;
2960: END IF;
2961: -- Standard call to check for call compatibility.
2962: IF FND_API.to_boolean(p_init_msg_list)
2963: THEN
2964: FND_MSG_PUB.initialize;
2965: END IF;