DBA Data[Home] [Help]

APPS.CN_TRANSACTION_LOAD_PUB dependencies on CN_MESSAGE_PKG

Line 25: cn_message_pkg.debug(substr(msg,1,254));

21: -- Local Procedure for showing debug msg
22:
23: PROCEDURE debugmsg(msg VARCHAR2) IS
24: BEGIN
25: cn_message_pkg.debug(substr(msg,1,254));
26: END debugmsg;
27:
28:
29: -- Procedure Name

Line 1290: cn_message_pkg.begin_batch

1286: -- Call begin_batch to get process_audit_id for debug log file
1287:
1288: debugmsg('Loader : Call begin_batch');
1289:
1290: cn_message_pkg.begin_batch
1291: (x_process_type => 'LOADER',
1292: x_parent_proc_audit_id => null,
1293: x_process_audit_id => x_process_audit_id,
1294: x_request_id => null,

Line 1603: cn_message_pkg.end_batch(x_process_audit_id);

1599: END IF;
1600:
1601: -- Call end_batch to end debug log file
1602: debugmsg('Loader : Call end_batch');
1603: cn_message_pkg.end_batch(x_process_audit_id);
1604: debugmsg('Loader : End of Loader');
1605:
1606: -- End of API body.
1607:

Line 1741: cn_message_pkg.end_batch(x_process_audit_id);

1737: org_id = p_org_id;
1738: commit;
1739:
1740: debugmsg('Loader : exception : exc_error : End of Loader');
1741: cn_message_pkg.end_batch(x_process_audit_id);
1742: x_loading_status := 'EXC_ERR';
1743: x_return_status := FND_API.G_RET_STS_ERROR ;
1744:
1745: FND_MSG_PUB.Count_And_Get

Line 1754: cn_message_pkg.end_batch(x_process_audit_id);

1750: );
1751: WHEN FND_API.G_EXC_ERROR THEN
1752: ROLLBACK TO load_savepoint;
1753: debugmsg('Loader : exception : exc_error : End of Loader');
1754: cn_message_pkg.end_batch(x_process_audit_id);
1755: x_loading_status := 'EXC_ERR';
1756: x_return_status := FND_API.G_RET_STS_ERROR ;
1757: FND_MSG_PUB.Count_And_Get
1758: (

Line 1766: cn_message_pkg.end_batch(x_process_audit_id);

1762: );
1763: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1764: ROLLBACK TO load_savepoint;
1765: debugmsg('Loader : exception : unexc_error : End of Loader');
1766: cn_message_pkg.end_batch(x_process_audit_id);
1767: x_loading_status := 'UNEXPECTED_ERR';
1768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1769: FND_MSG_PUB.Count_And_Get
1770: (

Line 1778: cn_message_pkg.end_batch(x_process_audit_id);

1774: );
1775: WHEN OTHERS THEN
1776: ROLLBACK TO load_savepoint;
1777: debugmsg('Loader : exception : others : End of Loader');
1778: cn_message_pkg.end_batch(x_process_audit_id);
1779: x_loading_status := 'UNEXPECTED_ERR';
1780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1782: THEN