APPS.CN_DIM_HIERARCHIES_PVT dependencies on CN_MESSAGE_PKG

Line 1498: cn_message_pkg.begin_batch

1494: WHERE h.imp_header_id = p_imp_header_id
1495: AND t.import_type_code = h.import_type_code;
1496:
1497: -- open process audit batch
1498: cn_message_pkg.begin_batch
1499: ( x_process_type => l_type,
1500: x_parent_proc_audit_id => p_imp_header_id ,
1501: x_process_audit_id => l_process_audit_id,
1502: x_request_id => null,

Line 1507: cn_message_pkg.write

1503: --R12 MOAC Changes--Start
1504: p_org_id => p_org_id);
1505: --R12 MOAC Changes--End
1506:
1507: cn_message_pkg.write
1508: (p_message_text => 'CN_EXP_HIERARCHY: Start Transfer Data. imp_header_id = ' || To_char(p_imp_header_id),
1509: p_message_type => 'MILESTONE');
1510:
1511: -- API call here

Line 1530: cn_message_pkg.write

1526: end loop;
1527:
1528: -- now populate the data
1529: for dim in get_dim_hierarchies loop
1530: cn_message_pkg.write
1531: (p_message_text => 'Downloading dim hierarchy ' ||
1532: dim.dim_hierarchy_id,
1533: p_message_type => 'DEBUG');
1534: for edge in traverse_tree(dim.dim_hierarchy_id) loop

Line 1569: cn_message_pkg.write

1565: (p_imp_header_id => p_imp_header_id,
1566: p_status_code => 'FAIL',
1567: p_failed_row => l_rowcount);
1568:
1569: cn_message_pkg.write
1570: (p_message_text => 'Export threw exception : rts sts ' ||
1571: l_return_status,
1572: p_message_type => 'ERROR');
1573:

Line 1580: cn_message_pkg.write

1576: l_message := l_message || my_message || '; ';
1577: my_message := fnd_msg_pub.get(p_encoded => FND_API.g_false);
1578: end loop;
1579:
1580: cn_message_pkg.write
1581: (p_message_text => l_message,
1582: p_message_type => 'ERROR');
1583:
1584: retcode := 2;

Line 1601: cn_message_pkg.write

1597: SET status_code = 'COMPLETE'
1598: WHERE imp_header_id = p_imp_header_id
1599: ;
1600:
1601: cn_message_pkg.write
1602: (p_message_text => 'CN_EXP_HIERARCHY: End Transfer Data. imp_header_id = ' || To_char(p_imp_header_id),
1603: p_message_type => 'MILESTONE');
1604:
1605: END IF;

Line 1608: cn_message_pkg.end_batch(l_process_audit_id);

1604:
1605: END IF;
1606:
1607: -- close process batch
1608: cn_message_pkg.end_batch(l_process_audit_id);
1609:
1610: -- Commit all imports
1611: COMMIT;
1612:

Line 1616: cn_message_pkg.end_batch(l_process_audit_id);

1612:
1613: EXCEPTION
1614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1615: retcode := 2 ;
1616: cn_message_pkg.end_batch(l_process_audit_id);
1617: FND_MSG_PUB.count_and_get
1618: (p_count => l_msg_count ,
1619: p_data => errbuf ,
1620: p_encoded => FND_API.G_FALSE

Line 1641: cn_message_pkg.set_error(l_api_name,errbuf);

1637: p_encoded => FND_API.G_FALSE
1638: );
1639: END IF;
1640:
1641: cn_message_pkg.set_error(l_api_name,errbuf);
1642: cn_message_pkg.end_batch(l_process_audit_id);
1643: END Export;
1644:
1645:

Line 1642: cn_message_pkg.end_batch(l_process_audit_id);

1638: );
1639: END IF;
1640:
1641: cn_message_pkg.set_error(l_api_name,errbuf);
1642: cn_message_pkg.end_batch(l_process_audit_id);
1643: END Export;
1644:
1645:
1646: END CN_DIM_HIERARCHIES_PVT;