DBA Data[Home] [Help]

APPS.PVX_PARTY_MERGE_PKG dependencies on FND_FILE

Line 1146: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG.ACCESS_MERGE start : '

1142: RESOURCE_BUSY EXCEPTION;
1143: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1144:
1145: BEGIN
1146: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG.ACCESS_MERGE start : '
1147: ||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity: '||p_parent_entity_name);
1149: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_fk: '||p_from_fk_id);
1150: FND_FILE.PUT_LINE(FND_FILE.LOG,'to_fk: '||p_to_fk_id);

Line 1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity: '||p_parent_entity_name);

1144:
1145: BEGIN
1146: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG.ACCESS_MERGE start : '
1147: ||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity: '||p_parent_entity_name);
1149: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_fk: '||p_from_fk_id);
1150: FND_FILE.PUT_LINE(FND_FILE.LOG,'to_fk: '||p_to_fk_id);
1151:
1152: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1149: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_fk: '||p_from_fk_id);

1145: BEGIN
1146: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG.ACCESS_MERGE start : '
1147: ||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity: '||p_parent_entity_name);
1149: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_fk: '||p_from_fk_id);
1150: FND_FILE.PUT_LINE(FND_FILE.LOG,'to_fk: '||p_to_fk_id);
1151:
1152: x_return_status := FND_API.G_RET_STS_SUCCESS;
1153:

Line 1150: FND_FILE.PUT_LINE(FND_FILE.LOG,'to_fk: '||p_to_fk_id);

1146: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_TAP_MERGE_PKG.ACCESS_MERGE start : '
1147: ||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1148: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entity: '||p_parent_entity_name);
1149: FND_FILE.PUT_LINE(FND_FILE.LOG,'from_fk: '||p_from_fk_id);
1150: FND_FILE.PUT_LINE(FND_FILE.LOG,'to_fk: '||p_to_fk_id);
1151:
1152: x_return_status := FND_API.G_RET_STS_SUCCESS;
1153:
1154: select merge_reason_code into l_merge_reason_code

Line 1190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing PV_PARTNER_ACCESSES Table');

1186: -- Merged To Id
1187: -- ************************************************************************
1188: IF p_from_fk_id <> p_to_fk_id THEN
1189: BEGIN
1190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing PV_PARTNER_ACCESSES Table');
1191: IF p_parent_entity_name = 'HZ_PARTIES' THEN
1192: FOR I in c_get_pm_access_id (p_from_fk_id, p_to_fk_id) LOOP
1193: FND_FILE.PUT_LINE(FND_FILE.LOG,
1194: 'Deleting PARTY partner_access_id: '||I.partner_access_id);

Line 1193: FND_FILE.PUT_LINE(FND_FILE.LOG,

1189: BEGIN
1190: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Processing PV_PARTNER_ACCESSES Table');
1191: IF p_parent_entity_name = 'HZ_PARTIES' THEN
1192: FOR I in c_get_pm_access_id (p_from_fk_id, p_to_fk_id) LOOP
1193: FND_FILE.PUT_LINE(FND_FILE.LOG,
1194: 'Deleting PARTY partner_access_id: '||I.partner_access_id);
1195: DELETE FROM pv_tap_access_terrs
1196: WHERE partner_access_id = I.partner_access_id;
1197:

Line 1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PVX_PARTY_MERGE_PKG.MERGE_PARTNER_ACCESSES end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

1275: raise;
1276: END;
1277: END IF; -- p_from_fk_id <> p_to_fk_id
1278:
1279: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PVX_PARTY_MERGE_PKG.MERGE_PARTNER_ACCESSES end : '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
1280:
1281: end MERGE_PARTNER_ACCESSES;
1282:
1283:

Line 1481: FND_FILE.PUT_LINE(FND_FILE.LOG, '(' || l_cnt || ') ' || l_msg);

1477: l_count := FND_MSG_PUB.count_msg;
1478:
1479: FOR l_cnt IN 1 .. l_count LOOP
1480: l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);
1481: FND_FILE.PUT_LINE(FND_FILE.LOG, '(' || l_cnt || ') ' || l_msg);
1482: END LOOP;
1483: END Debug;
1484:
1485:

Line 1533: FND_FILE.PUT_LINE(FND_FILE.LOG, '(' || l_cnt || ') ' || l_msg);

1529: l_count := FND_MSG_PUB.count_msg;
1530:
1531: FOR l_cnt IN 1 .. l_count LOOP
1532: l_msg := FND_MSG_PUB.get(l_cnt, FND_API.g_false);
1533: FND_FILE.PUT_LINE(FND_FILE.LOG, '(' || l_cnt || ') ' || l_msg);
1534: END LOOP;
1535: END Set_Message;
1536: -- ==============================End of Set_Message==============================
1537: