DBA Data[Home] [Help]

APPS.AHL_DI_ASSO_DOC_ASO_PVT dependencies on STANDARD

Line 311: -- Standard Start of API savepoint

307: l_rowid ROWID;
308: l_object_version_number NUMBER;
309: --
310: BEGIN
311: -- Standard Start of API savepoint
312: SAVEPOINT delete_association;
313: -- Check if API is called in debug mode. If yes, enable debug.
314: IF G_DEBUG='Y' THEN
315: AHL_DEBUG_PUB.enable_debug;

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

321: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Delete Association','+DOBJASS+');
322:
323: END IF;
324: END IF;
325: -- Standard call to check for call compatibility.
326: IF FND_API.to_boolean(p_init_msg_list)
327: THEN
328: FND_MSG_PUB.initialize;
329: END IF;

Line 375: --Standard check for commit;

371: DELETE FROM AHL_DOC_TITLE_ASSOS_TL
372: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
373: --
374: */
375: --Standard check for commit;
376: IF FND_API.TO_BOOLEAN(p_commit) THEN
377: COMMIT;
378: END IF;
379: -- Debug info

Line 524: -- Standard Start of API savepoint

520: l_document_no VARCHAR2(80);
521: l_doc_title_asso_id NUMBER;
522: l_association_info association_rec;
523: BEGIN
524: -- Standard Start of API savepoint
525: SAVEPOINT create_association;
526: -- Check if API is called in debug mode. If yes, enable debug.
527: IF G_DEBUG='Y' THEN
528: AHL_DEBUG_PUB.enable_debug;

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

534: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Create Association','+DOBJASS+');
535:
536: END IF;
537: END IF;
538: -- Standard call to check for call compatibility.
539: IF FND_API.to_boolean(p_init_msg_list)
540: THEN
541: FND_MSG_PUB.initialize;
542: END IF;

Line 568: --Standard call to message count

564: p_aso_object_id => p_x_association_tbl(i).aso_object_id,
565: p_delete_flag => p_x_association_tbl(i).delete_flag
566: );
567: END LOOP;
568: --Standard call to message count
569: l_msg_count := FND_MSG_PUB.count_msg;
570:
571: IF l_msg_count > 0 THEN
572: X_msg_count := l_msg_count;

Line 897: --Standard check to count messages

893: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
894: --Assign the doc title asso id,object version number
895: p_x_association_tbl(i).doc_title_asso_id := l_doc_title_asso_id;
896: p_x_association_tbl(i).object_version_number := 1;
897: --Standard check to count messages
898: l_msg_count := FND_MSG_PUB.count_msg;
899:
900: IF l_msg_count > 0 THEN
901: X_msg_count := l_msg_count;

Line 909: --Standard check for commit

905:
906: END IF;
907: END LOOP;
908: END IF;
909: --Standard check for commit
910: IF FND_API.TO_BOOLEAN(p_commit) THEN
911: COMMIT;
912: END IF;
913: -- Debug info

Line 1109: -- Standard Start of API savepoint

1105: l_association_tl_info get_doc_assos_rec_tl_info%ROWTYPE;
1106: l_doc_title_asso_id NUMBER;
1107: l_found_flag VARCHAR2(5) := 'N';
1108: BEGIN
1109: -- Standard Start of API savepoint
1110: SAVEPOINT modify_association;
1111: -- Check if API is called in debug mode. If yes, enable debug.
1112: IF G_DEBUG='Y' THEN
1113: AHL_DEBUG_PUB.enable_debug;

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

1119: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Modify Association','+DOBJASS+');
1120:
1121: END IF;
1122: END IF;
1123: -- Standard call to check for call compatibility.
1124: IF FND_API.to_boolean(p_init_msg_list)
1125: THEN
1126: FND_MSG_PUB.initialize;
1127: END IF;

Line 1153: --Standard check to count messages

1149: p_aso_object_id => p_x_association_tbl(i).aso_object_id,
1150: p_delete_flag => p_x_association_tbl(i).delete_flag
1151: );
1152: END LOOP;
1153: --Standard check to count messages
1154: l_msg_count := FND_MSG_PUB.count_msg;
1155:
1156: IF l_msg_count > 0 THEN
1157: X_msg_count := l_msg_count;

Line 1502: --Standard check to count messages

1498: x_msg_data => x_msg_data);
1499: END IF;
1500: END LOOP;
1501: END IF;
1502: --Standard check to count messages
1503: l_msg_count := FND_MSG_PUB.count_msg;
1504:
1505: IF l_msg_count > 0 THEN
1506: X_msg_count := l_msg_count;

Line 1510: --Standard check for commit

1506: X_msg_count := l_msg_count;
1507: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: RAISE FND_API.G_EXC_ERROR;
1509: END IF;
1510: --Standard check for commit
1511: IF FND_API.TO_BOOLEAN(p_commit) THEN
1512: COMMIT;
1513: END IF;
1514: -- Debug info

Line 1629: -- Standard Start of API savepoint

1625: l_document_no VARCHAR2(80);
1626: l_doc_title_asso_id NUMBER;
1627: l_association_info association_rec;
1628: BEGIN
1629: -- Standard Start of API savepoint
1630: SAVEPOINT insert_assoc_rec;
1631: -- Check if API is called in debug mode. If yes, enable debug.
1632: IF G_DEBUG='Y' THEN
1633: AHL_DEBUG_PUB.enable_debug;

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

1639: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pvt.Insert Assoc Rec','+DOBJASS+');
1640:
1641: END IF;
1642: END IF;
1643: -- Standard call to check for call compatibility.
1644: IF Fnd_Api.to_boolean(p_init_msg_list)
1645: THEN
1646: Fnd_Msg_Pub.initialize;
1647: END IF;

Line 1668: --Standard call to message count

1664: p_aso_object_type_code => p_association_rec.aso_object_type_code,
1665: p_aso_object_id => p_association_rec.aso_object_id,
1666: p_delete_flag => 'N'
1667: );
1668: --Standard call to message count
1669: l_msg_count := Fnd_Msg_Pub.count_msg;
1670:
1671: IF l_msg_count > 0 THEN
1672: X_msg_count := l_msg_count;

Line 1932: --Standard check to count messages

1928: X_CREATED_BY => fnd_global.user_id,
1929: X_LAST_UPDATE_DATE => sysdate,
1930: X_LAST_UPDATED_BY => fnd_global.user_id,
1931: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
1932: --Standard check to count messages
1933: l_msg_count := Fnd_Msg_Pub.count_msg;
1934:
1935: IF l_msg_count > 0 THEN
1936: X_msg_count := l_msg_count;

Line 1941: --Standard check for commit

1937: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1938: RAISE Fnd_Api.G_EXC_ERROR;
1939: END IF;
1940: END IF;
1941: --Standard check for commit
1942: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
1943: COMMIT;
1944: END IF;
1945: -- Debug info

Line 2056: -- Standard Start of API savepoint

2052: l_dummy VARCHAR2(2000);
2053: l_row_id VARCHAR2(30);
2054: l_association_rec get_assos_b_cur%ROWTYPE;
2055: BEGIN
2056: -- Standard Start of API savepoint
2057: SAVEPOINT copy_association;
2058: -- Check if API is called in debug mode. If yes, enable debug.
2059: IF G_DEBUG='Y' THEN
2060: AHL_DEBUG_PUB.enable_debug;

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

2066: AHL_DEBUG_PUB.debug( 'enter Ahl_Di_Asso_Doc_Aso_Pvt.Copy Association','+DOBJASS+');
2067:
2068: END IF;
2069: END IF;
2070: -- Standard call to check for call compatibility.
2071: IF Fnd_Api.to_boolean(p_init_msg_list)
2072: THEN
2073: Fnd_Msg_Pub.initialize;
2074: END IF;

Line 2148: --Standard check to count messages

2144: x_msg_data => x_msg_data);
2145:
2146: END LOOP;
2147: CLOSE get_assos_b_cur;
2148: --Standard check to count messages
2149: l_msg_count := Fnd_Msg_Pub.count_msg;
2150:
2151: IF l_msg_count > 0 THEN
2152: X_msg_count := l_msg_count;

Line 2156: --Standard check for commit

2152: X_msg_count := l_msg_count;
2153: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2154: RAISE Fnd_Api.G_EXC_ERROR;
2155: END IF;
2156: --Standard check for commit
2157: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
2158: COMMIT;
2159: END IF;
2160: -- Debug info