DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_HISTORY_PKG dependencies on WSH_DEBUG_SV

Line 74: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

70: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
71: --
72: IF l_debug_on IS NULL
73: THEN
74: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
75: END IF;
76: --
77: IF l_debug_on THEN
78: wsh_debug_sv.push(l_module_name,'Create_Update_Txns_History');

Line 78: wsh_debug_sv.push(l_module_name,'Create_Update_Txns_History');

74: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
75: END IF;
76: --
77: IF l_debug_on THEN
78: wsh_debug_sv.push(l_module_name,'Create_Update_Txns_History');
79: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_txns_history_Rec.transaction_id);
80: wsh_debug_sv.log (l_module_name, 'document Type', p_txns_history_rec.document_type);
81: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_txns_history_Rec.document_direction);
82: wsh_debug_sv.log (l_module_name, 'Doc number', p_txns_history_Rec.document_number);

Line 79: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_txns_history_Rec.transaction_id);

75: END IF;
76: --
77: IF l_debug_on THEN
78: wsh_debug_sv.push(l_module_name,'Create_Update_Txns_History');
79: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_txns_history_Rec.transaction_id);
80: wsh_debug_sv.log (l_module_name, 'document Type', p_txns_history_rec.document_type);
81: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_txns_history_Rec.document_direction);
82: wsh_debug_sv.log (l_module_name, 'Doc number', p_txns_history_Rec.document_number);
83: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_txns_history_Rec.orig_document_number);

Line 80: wsh_debug_sv.log (l_module_name, 'document Type', p_txns_history_rec.document_type);

76: --
77: IF l_debug_on THEN
78: wsh_debug_sv.push(l_module_name,'Create_Update_Txns_History');
79: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_txns_history_Rec.transaction_id);
80: wsh_debug_sv.log (l_module_name, 'document Type', p_txns_history_rec.document_type);
81: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_txns_history_Rec.document_direction);
82: wsh_debug_sv.log (l_module_name, 'Doc number', p_txns_history_Rec.document_number);
83: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_txns_history_Rec.orig_document_number);
84: wsh_debug_sv.log (l_module_name, 'Entity Type', p_txns_history_Rec.entity_type);

Line 81: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_txns_history_Rec.document_direction);

77: IF l_debug_on THEN
78: wsh_debug_sv.push(l_module_name,'Create_Update_Txns_History');
79: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_txns_history_Rec.transaction_id);
80: wsh_debug_sv.log (l_module_name, 'document Type', p_txns_history_rec.document_type);
81: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_txns_history_Rec.document_direction);
82: wsh_debug_sv.log (l_module_name, 'Doc number', p_txns_history_Rec.document_number);
83: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_txns_history_Rec.orig_document_number);
84: wsh_debug_sv.log (l_module_name, 'Entity Type', p_txns_history_Rec.entity_type);
85: wsh_debug_sv.log (l_module_name, 'Entity number', p_txns_history_Rec.entity_number);

Line 82: wsh_debug_sv.log (l_module_name, 'Doc number', p_txns_history_Rec.document_number);

78: wsh_debug_sv.push(l_module_name,'Create_Update_Txns_History');
79: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_txns_history_Rec.transaction_id);
80: wsh_debug_sv.log (l_module_name, 'document Type', p_txns_history_rec.document_type);
81: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_txns_history_Rec.document_direction);
82: wsh_debug_sv.log (l_module_name, 'Doc number', p_txns_history_Rec.document_number);
83: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_txns_history_Rec.orig_document_number);
84: wsh_debug_sv.log (l_module_name, 'Entity Type', p_txns_history_Rec.entity_type);
85: wsh_debug_sv.log (l_module_name, 'Entity number', p_txns_history_Rec.entity_number);
86: wsh_debug_sv.log (l_module_name, 'TP id', p_txns_history_Rec.trading_partner_id);

Line 83: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_txns_history_Rec.orig_document_number);

79: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_txns_history_Rec.transaction_id);
80: wsh_debug_sv.log (l_module_name, 'document Type', p_txns_history_rec.document_type);
81: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_txns_history_Rec.document_direction);
82: wsh_debug_sv.log (l_module_name, 'Doc number', p_txns_history_Rec.document_number);
83: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_txns_history_Rec.orig_document_number);
84: wsh_debug_sv.log (l_module_name, 'Entity Type', p_txns_history_Rec.entity_type);
85: wsh_debug_sv.log (l_module_name, 'Entity number', p_txns_history_Rec.entity_number);
86: wsh_debug_sv.log (l_module_name, 'TP id', p_txns_history_Rec.trading_partner_id);
87: wsh_debug_sv.log (l_module_name, 'Action type', p_txns_history_Rec.action_type);

Line 84: wsh_debug_sv.log (l_module_name, 'Entity Type', p_txns_history_Rec.entity_type);

80: wsh_debug_sv.log (l_module_name, 'document Type', p_txns_history_rec.document_type);
81: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_txns_history_Rec.document_direction);
82: wsh_debug_sv.log (l_module_name, 'Doc number', p_txns_history_Rec.document_number);
83: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_txns_history_Rec.orig_document_number);
84: wsh_debug_sv.log (l_module_name, 'Entity Type', p_txns_history_Rec.entity_type);
85: wsh_debug_sv.log (l_module_name, 'Entity number', p_txns_history_Rec.entity_number);
86: wsh_debug_sv.log (l_module_name, 'TP id', p_txns_history_Rec.trading_partner_id);
87: wsh_debug_sv.log (l_module_name, 'Action type', p_txns_history_Rec.action_type);
88: wsh_debug_sv.log (l_module_name, 'Transaction status', p_txns_history_Rec.transaction_status);

Line 85: wsh_debug_sv.log (l_module_name, 'Entity number', p_txns_history_Rec.entity_number);

81: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_txns_history_Rec.document_direction);
82: wsh_debug_sv.log (l_module_name, 'Doc number', p_txns_history_Rec.document_number);
83: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_txns_history_Rec.orig_document_number);
84: wsh_debug_sv.log (l_module_name, 'Entity Type', p_txns_history_Rec.entity_type);
85: wsh_debug_sv.log (l_module_name, 'Entity number', p_txns_history_Rec.entity_number);
86: wsh_debug_sv.log (l_module_name, 'TP id', p_txns_history_Rec.trading_partner_id);
87: wsh_debug_sv.log (l_module_name, 'Action type', p_txns_history_Rec.action_type);
88: wsh_debug_sv.log (l_module_name, 'Transaction status', p_txns_history_Rec.transaction_status);
89: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_txns_history_Rec.ecx_message_id);

Line 86: wsh_debug_sv.log (l_module_name, 'TP id', p_txns_history_Rec.trading_partner_id);

82: wsh_debug_sv.log (l_module_name, 'Doc number', p_txns_history_Rec.document_number);
83: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_txns_history_Rec.orig_document_number);
84: wsh_debug_sv.log (l_module_name, 'Entity Type', p_txns_history_Rec.entity_type);
85: wsh_debug_sv.log (l_module_name, 'Entity number', p_txns_history_Rec.entity_number);
86: wsh_debug_sv.log (l_module_name, 'TP id', p_txns_history_Rec.trading_partner_id);
87: wsh_debug_sv.log (l_module_name, 'Action type', p_txns_history_Rec.action_type);
88: wsh_debug_sv.log (l_module_name, 'Transaction status', p_txns_history_Rec.transaction_status);
89: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_txns_history_Rec.ecx_message_id);
90: wsh_debug_sv.log (l_module_name, 'Event Name', p_txns_history_Rec.event_name);

Line 87: wsh_debug_sv.log (l_module_name, 'Action type', p_txns_history_Rec.action_type);

83: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_txns_history_Rec.orig_document_number);
84: wsh_debug_sv.log (l_module_name, 'Entity Type', p_txns_history_Rec.entity_type);
85: wsh_debug_sv.log (l_module_name, 'Entity number', p_txns_history_Rec.entity_number);
86: wsh_debug_sv.log (l_module_name, 'TP id', p_txns_history_Rec.trading_partner_id);
87: wsh_debug_sv.log (l_module_name, 'Action type', p_txns_history_Rec.action_type);
88: wsh_debug_sv.log (l_module_name, 'Transaction status', p_txns_history_Rec.transaction_status);
89: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_txns_history_Rec.ecx_message_id);
90: wsh_debug_sv.log (l_module_name, 'Event Name', p_txns_history_Rec.event_name);
91: wsh_debug_sv.log (l_module_name, 'Event Key', p_txns_history_Rec.event_key);

Line 88: wsh_debug_sv.log (l_module_name, 'Transaction status', p_txns_history_Rec.transaction_status);

84: wsh_debug_sv.log (l_module_name, 'Entity Type', p_txns_history_Rec.entity_type);
85: wsh_debug_sv.log (l_module_name, 'Entity number', p_txns_history_Rec.entity_number);
86: wsh_debug_sv.log (l_module_name, 'TP id', p_txns_history_Rec.trading_partner_id);
87: wsh_debug_sv.log (l_module_name, 'Action type', p_txns_history_Rec.action_type);
88: wsh_debug_sv.log (l_module_name, 'Transaction status', p_txns_history_Rec.transaction_status);
89: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_txns_history_Rec.ecx_message_id);
90: wsh_debug_sv.log (l_module_name, 'Event Name', p_txns_history_Rec.event_name);
91: wsh_debug_sv.log (l_module_name, 'Event Key', p_txns_history_Rec.event_key);
92: wsh_debug_sv.log (l_module_name, 'Item Type', p_txns_history_Rec.item_type);

Line 89: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_txns_history_Rec.ecx_message_id);

85: wsh_debug_sv.log (l_module_name, 'Entity number', p_txns_history_Rec.entity_number);
86: wsh_debug_sv.log (l_module_name, 'TP id', p_txns_history_Rec.trading_partner_id);
87: wsh_debug_sv.log (l_module_name, 'Action type', p_txns_history_Rec.action_type);
88: wsh_debug_sv.log (l_module_name, 'Transaction status', p_txns_history_Rec.transaction_status);
89: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_txns_history_Rec.ecx_message_id);
90: wsh_debug_sv.log (l_module_name, 'Event Name', p_txns_history_Rec.event_name);
91: wsh_debug_sv.log (l_module_name, 'Event Key', p_txns_history_Rec.event_key);
92: wsh_debug_sv.log (l_module_name, 'Item Type', p_txns_history_Rec.item_type);
93: wsh_debug_sv.log (l_module_name, 'In. control num', p_txns_history_Rec.internal_control_number);

Line 90: wsh_debug_sv.log (l_module_name, 'Event Name', p_txns_history_Rec.event_name);

86: wsh_debug_sv.log (l_module_name, 'TP id', p_txns_history_Rec.trading_partner_id);
87: wsh_debug_sv.log (l_module_name, 'Action type', p_txns_history_Rec.action_type);
88: wsh_debug_sv.log (l_module_name, 'Transaction status', p_txns_history_Rec.transaction_status);
89: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_txns_history_Rec.ecx_message_id);
90: wsh_debug_sv.log (l_module_name, 'Event Name', p_txns_history_Rec.event_name);
91: wsh_debug_sv.log (l_module_name, 'Event Key', p_txns_history_Rec.event_key);
92: wsh_debug_sv.log (l_module_name, 'Item Type', p_txns_history_Rec.item_type);
93: wsh_debug_sv.log (l_module_name, 'In. control num', p_txns_history_Rec.internal_control_number);
94: --R12.1.1 STANDALONE PROJECT

Line 91: wsh_debug_sv.log (l_module_name, 'Event Key', p_txns_history_Rec.event_key);

87: wsh_debug_sv.log (l_module_name, 'Action type', p_txns_history_Rec.action_type);
88: wsh_debug_sv.log (l_module_name, 'Transaction status', p_txns_history_Rec.transaction_status);
89: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_txns_history_Rec.ecx_message_id);
90: wsh_debug_sv.log (l_module_name, 'Event Name', p_txns_history_Rec.event_name);
91: wsh_debug_sv.log (l_module_name, 'Event Key', p_txns_history_Rec.event_key);
92: wsh_debug_sv.log (l_module_name, 'Item Type', p_txns_history_Rec.item_type);
93: wsh_debug_sv.log (l_module_name, 'In. control num', p_txns_history_Rec.internal_control_number);
94: --R12.1.1 STANDALONE PROJECT
95: wsh_debug_sv.log (l_module_name, 'Doc Revision', p_txns_history_Rec.document_revision);

Line 92: wsh_debug_sv.log (l_module_name, 'Item Type', p_txns_history_Rec.item_type);

88: wsh_debug_sv.log (l_module_name, 'Transaction status', p_txns_history_Rec.transaction_status);
89: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_txns_history_Rec.ecx_message_id);
90: wsh_debug_sv.log (l_module_name, 'Event Name', p_txns_history_Rec.event_name);
91: wsh_debug_sv.log (l_module_name, 'Event Key', p_txns_history_Rec.event_key);
92: wsh_debug_sv.log (l_module_name, 'Item Type', p_txns_history_Rec.item_type);
93: wsh_debug_sv.log (l_module_name, 'In. control num', p_txns_history_Rec.internal_control_number);
94: --R12.1.1 STANDALONE PROJECT
95: wsh_debug_sv.log (l_module_name, 'Doc Revision', p_txns_history_Rec.document_revision);
96: END IF;

Line 93: wsh_debug_sv.log (l_module_name, 'In. control num', p_txns_history_Rec.internal_control_number);

89: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_txns_history_Rec.ecx_message_id);
90: wsh_debug_sv.log (l_module_name, 'Event Name', p_txns_history_Rec.event_name);
91: wsh_debug_sv.log (l_module_name, 'Event Key', p_txns_history_Rec.event_key);
92: wsh_debug_sv.log (l_module_name, 'Item Type', p_txns_history_Rec.item_type);
93: wsh_debug_sv.log (l_module_name, 'In. control num', p_txns_history_Rec.internal_control_number);
94: --R12.1.1 STANDALONE PROJECT
95: wsh_debug_sv.log (l_module_name, 'Doc Revision', p_txns_history_Rec.document_revision);
96: END IF;
97:

Line 95: wsh_debug_sv.log (l_module_name, 'Doc Revision', p_txns_history_Rec.document_revision);

91: wsh_debug_sv.log (l_module_name, 'Event Key', p_txns_history_Rec.event_key);
92: wsh_debug_sv.log (l_module_name, 'Item Type', p_txns_history_Rec.item_type);
93: wsh_debug_sv.log (l_module_name, 'In. control num', p_txns_history_Rec.internal_control_number);
94: --R12.1.1 STANDALONE PROJECT
95: wsh_debug_sv.log (l_module_name, 'Doc Revision', p_txns_history_Rec.document_revision);
96: END IF;
97:
98: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
99:

Line 142: wsh_debug_sv.log (l_module_name,'Record does not exist.

138: FETCH txn_cur INTO l_transaction_id,l_transaction_status;
139:
140: IF (txn_cur%NOTFOUND) THEN
141: IF l_debug_on THEN
142: wsh_debug_sv.log (l_module_name,'Record does not exist.
143: So create a new record in wsh_transactions_history');
144: wsh_debug_sv.log (l_module_name,'document_direction ',
145: p_txns_history_rec.document_direction);
146: wsh_debug_sv.log (l_module_name,'document_type ',

Line 144: wsh_debug_sv.log (l_module_name,'document_direction ',

140: IF (txn_cur%NOTFOUND) THEN
141: IF l_debug_on THEN
142: wsh_debug_sv.log (l_module_name,'Record does not exist.
143: So create a new record in wsh_transactions_history');
144: wsh_debug_sv.log (l_module_name,'document_direction ',
145: p_txns_history_rec.document_direction);
146: wsh_debug_sv.log (l_module_name,'document_type ',
147: p_txns_history_rec.document_type);
148: wsh_debug_sv.log (l_module_name,'entity_number ',

Line 146: wsh_debug_sv.log (l_module_name,'document_type ',

142: wsh_debug_sv.log (l_module_name,'Record does not exist.
143: So create a new record in wsh_transactions_history');
144: wsh_debug_sv.log (l_module_name,'document_direction ',
145: p_txns_history_rec.document_direction);
146: wsh_debug_sv.log (l_module_name,'document_type ',
147: p_txns_history_rec.document_type);
148: wsh_debug_sv.log (l_module_name,'entity_number ',
149: p_txns_history_rec.entity_number);
150: END IF;

Line 148: wsh_debug_sv.log (l_module_name,'entity_number ',

144: wsh_debug_sv.log (l_module_name,'document_direction ',
145: p_txns_history_rec.document_direction);
146: wsh_debug_sv.log (l_module_name,'document_type ',
147: p_txns_history_rec.document_type);
148: wsh_debug_sv.log (l_module_name,'entity_number ',
149: p_txns_history_rec.entity_number);
150: END IF;
151: --bmso k proj
152: l_trans_status :=

Line 163: wsh_debug_sv.log (l_module_name,

159: FETCH c_get_del_status INTO l_status_code;
160: CLOSE c_get_del_status;
161: --
162: IF l_debug_on THEN
163: wsh_debug_sv.log (l_module_name,
164: 'entity_number ',
165: p_txns_history_rec.entity_number);
166: wsh_debug_sv.log (l_module_name,
167: 'l_status_code ', l_status_code);

Line 166: wsh_debug_sv.log (l_module_name,

162: IF l_debug_on THEN
163: wsh_debug_sv.log (l_module_name,
164: 'entity_number ',
165: p_txns_history_rec.entity_number);
166: wsh_debug_sv.log (l_module_name,
167: 'l_status_code ', l_status_code);
168: END IF;
169: --
170: IF l_status_code NOT IN ('SC','SR') THEN --{

Line 299: wsh_debug_sv.log (l_module_name,'Record already exists. So Need to Update in wsh_transactions_history');

295: x_txns_id := x_transaction_id;
296:
297: ELSE
298: IF l_debug_on THEN
299: wsh_debug_sv.log (l_module_name,'Record already exists. So Need to Update in wsh_transactions_history');
300: END IF;
301: -- Record already exists. So Need to Update
302: -- Before Update Check for validity of status
303:

Line 367: wsh_debug_sv.pop(l_module_name);

363:
364: END IF; -- if p_txns_history_rec columns are not null
365:
366: IF l_debug_on THEN
367: wsh_debug_sv.pop(l_module_name);
368: END IF;
369: EXCEPTION
370: WHEN invalid_status THEN
371: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 373: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_status exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

369: EXCEPTION
370: WHEN invalid_status THEN
371: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
372: IF l_debug_on THEN
373: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_status exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_status');
375: END IF;
376: WHEN invalid_action THEN
377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_status');

370: WHEN invalid_status THEN
371: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
372: IF l_debug_on THEN
373: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_status exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_status');
375: END IF;
376: WHEN invalid_action THEN
377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
378: IF l_debug_on THEN

Line 379: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

375: END IF;
376: WHEN invalid_action THEN
377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
378: IF l_debug_on THEN
379: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
380: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action');
381: END IF;
382: WHEN invalid_entity_type THEN
383: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 380: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action');

376: WHEN invalid_action THEN
377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
378: IF l_debug_on THEN
379: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
380: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action');
381: END IF;
382: WHEN invalid_entity_type THEN
383: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
384: IF l_debug_on THEN

Line 385: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

381: END IF;
382: WHEN invalid_entity_type THEN
383: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
386: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');
387: END IF;
388: WHEN invalid_direction THEN
389: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 386: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');

382: WHEN invalid_entity_type THEN
383: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
386: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');
387: END IF;
388: WHEN invalid_direction THEN
389: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
390: IF l_debug_on THEN

Line 391: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

387: END IF;
388: WHEN invalid_direction THEN
389: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
390: IF l_debug_on THEN
391: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_direction');
393: END IF;
394: WHEN invalid_document_type THEN
395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_direction');

388: WHEN invalid_direction THEN
389: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
390: IF l_debug_on THEN
391: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_direction exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_direction');
393: END IF;
394: WHEN invalid_document_type THEN
395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
396: IF l_debug_on THEN

Line 397: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_document_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

393: END IF;
394: WHEN invalid_document_type THEN
395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_document_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
398: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_document_type');
399: END IF;
400: WHEN Others THEN
401: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 398: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_document_type');

394: WHEN invalid_document_type THEN
395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_document_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
398: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_document_type');
399: END IF;
400: WHEN Others THEN
401: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
402: IF l_debug_on THEN

Line 403: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

399: END IF;
400: WHEN Others THEN
401: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
402: IF l_debug_on THEN
403: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
404: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
406: END IF;
407:

Line 404: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

400: WHEN Others THEN
401: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
402: IF l_debug_on THEN
403: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
404: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
406: END IF;
407:
408: END Create_Update_Txns_History;

Line 405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

401: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
402: IF l_debug_on THEN
403: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
404: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
405: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
406: END IF;
407:
408: END Create_Update_Txns_History;
409:

Line 477: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

473: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
474: --
475: IF l_debug_on IS NULL
476: THEN
477: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
478: END IF;
479: --
480: IF l_debug_on THEN
481: wsh_debug_sv.push(l_module_name,'Get_Txns_History');

Line 481: wsh_debug_sv.push(l_module_name,'Get_Txns_History');

477: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
478: END IF;
479: --
480: IF l_debug_on THEN
481: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
482: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
483: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
484: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);
485: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);

Line 482: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);

478: END IF;
479: --
480: IF l_debug_on THEN
481: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
482: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
483: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
484: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);
485: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);
486: END IF;

Line 483: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);

479: --
480: IF l_debug_on THEN
481: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
482: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
483: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
484: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);
485: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);
486: END IF;
487:

Line 484: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);

480: IF l_debug_on THEN
481: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
482: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
483: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
484: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);
485: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);
486: END IF;
487:
488: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 485: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);

481: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
482: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
483: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
484: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);
485: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);
486: END IF;
487:
488: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
489:

Line 500: wsh_debug_sv.pop(l_module_name);

496:
497: CLOSE txns_history_cur;
498:
499: IF l_debug_on THEN
500: wsh_debug_sv.pop(l_module_name);
501: END IF;
502:
503: EXCEPTION
504: WHEN no_record_found THEN

Line 512: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

508: END IF;
509:
510: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
513: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
514: END IF;
515: WHEN Others THEN
516: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 513: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');

509:
510: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
511: IF l_debug_on THEN
512: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
513: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
514: END IF;
515: WHEN Others THEN
516: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
517: IF l_debug_on THEN

Line 518: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

514: END IF;
515: WHEN Others THEN
516: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
517: IF l_debug_on THEN
518: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
519: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
520: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
521: END IF;
522: END Get_Txns_History;

Line 519: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

515: WHEN Others THEN
516: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
517: IF l_debug_on THEN
518: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
519: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
520: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
521: END IF;
522: END Get_Txns_History;
523:

Line 520: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

516: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
517: IF l_debug_on THEN
518: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
519: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
520: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
521: END IF;
522: END Get_Txns_History;
523:
524: /*

Line 572: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

568: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
569: --
570: IF l_debug_on IS NULL
571: THEN
572: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
573: END IF;
574: --
575: IF l_debug_on THEN
576: wsh_debug_sv.push(l_module_name,'Get_Txns_History');

Line 576: wsh_debug_sv.push(l_module_name,'Get_Txns_History');

572: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
573: END IF;
574: --
575: IF l_debug_on THEN
576: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
577: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);
578: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
579: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
580: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);

Line 577: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);

573: END IF;
574: --
575: IF l_debug_on THEN
576: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
577: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);
578: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
579: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
580: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
581: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);

Line 578: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);

574: --
575: IF l_debug_on THEN
576: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
577: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);
578: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
579: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
580: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
581: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
582: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);

Line 579: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);

575: IF l_debug_on THEN
576: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
577: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);
578: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
579: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
580: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
581: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
582: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
583: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);

Line 580: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);

576: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
577: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);
578: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
579: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
580: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
581: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
582: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
583: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
584: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);

Line 581: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);

577: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);
578: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
579: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
580: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
581: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
582: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
583: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
584: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
585: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);

Line 582: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);

578: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
579: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
580: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
581: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
582: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
583: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
584: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
585: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
586: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);

Line 583: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);

579: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
580: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
581: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
582: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
583: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
584: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
585: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
586: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
587: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);

Line 584: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);

580: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
581: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
582: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
583: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
584: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
585: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
586: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
587: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
588: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);

Line 585: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);

581: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
582: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
583: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
584: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
585: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
586: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
587: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
588: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
589: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);

Line 586: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);

582: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
583: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
584: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
585: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
586: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
587: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
588: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
589: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
590: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);

Line 587: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);

583: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
584: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
585: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
586: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
587: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
588: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
589: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
590: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
591: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);

Line 588: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);

584: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
585: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
586: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
587: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
588: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
589: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
590: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
591: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);
592: --R12.1.1 STANDALONE PROJECT

Line 589: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);

585: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
586: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
587: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
588: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
589: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
590: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
591: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);
592: --R12.1.1 STANDALONE PROJECT
593: wsh_debug_sv.log (l_module_name, 'Document Revision', p_document_revision);

Line 590: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);

586: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
587: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
588: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
589: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
590: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
591: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);
592: --R12.1.1 STANDALONE PROJECT
593: wsh_debug_sv.log (l_module_name, 'Document Revision', p_document_revision);
594: END IF;

Line 591: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);

587: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
588: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
589: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
590: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
591: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);
592: --R12.1.1 STANDALONE PROJECT
593: wsh_debug_sv.log (l_module_name, 'Document Revision', p_document_revision);
594: END IF;
595:

Line 593: wsh_debug_sv.log (l_module_name, 'Document Revision', p_document_revision);

589: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
590: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
591: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);
592: --R12.1.1 STANDALONE PROJECT
593: wsh_debug_sv.log (l_module_name, 'Document Revision', p_document_revision);
594: END IF;
595:
596: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
597:

Line 623: wsh_debug_sv.log (l_module_name, 'Return status from Create_Update_Txns_History', l_return_status);

619: x_txns_id => l_txn_id,
620: x_return_status => l_return_status);
621:
622: IF l_debug_on THEN
623: wsh_debug_sv.log (l_module_name, 'Return status from Create_Update_Txns_History', l_return_status);
624: END IF;
625:
626: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
627: raise create_update_failed;

Line 630: wsh_debug_sv.pop(l_module_name);

626: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
627: raise create_update_failed;
628: END IF;
629: IF l_debug_on THEN
630: wsh_debug_sv.pop(l_module_name);
631: END IF;
632: EXCEPTION
633: WHEN create_update_failed THEN
634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 636: wsh_debug_sv.pop(l_module_name);

632: EXCEPTION
633: WHEN create_update_failed THEN
634: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
635: IF l_debug_on THEN
636: wsh_debug_sv.pop(l_module_name);
637: END IF;
638: WHEN Others THEN
639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
640: IF l_debug_on THEN

Line 641: wsh_debug_sv.pop(l_module_name,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));

637: END IF;
638: WHEN Others THEN
639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
640: IF l_debug_on THEN
641: wsh_debug_sv.pop(l_module_name,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
642: END IF;
643: END Create_Txns_History;
644:
645: END WSH_TRANSACTIONS_HISTORY_PKG;