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 1292: cn_message_pkg.begin_batch

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

Line 1605: cn_message_pkg.end_batch(x_process_audit_id);

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

Line 1743: cn_message_pkg.end_batch(x_process_audit_id);

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

Line 1756: cn_message_pkg.end_batch(x_process_audit_id);

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

Line 1768: cn_message_pkg.end_batch(x_process_audit_id);

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

Line 1780: cn_message_pkg.end_batch(x_process_audit_id);

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