eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TRANSACTIONS_HISTORY_PKG dependencies on WSH_DEBUG_SV

Line 73: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

87: wsh_debug_sv.log (l_module_name, 'Transaction status', p_txns_history_Rec.transaction_status);
88: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_txns_history_Rec.ecx_message_id);
89: wsh_debug_sv.log (l_module_name, 'Event Name', p_txns_history_Rec.event_name);
90: wsh_debug_sv.log (l_module_name, 'Event Key', p_txns_history_Rec.event_key);
91: wsh_debug_sv.log (l_module_name, 'Item Type', p_txns_history_Rec.item_type);
92: wsh_debug_sv.log (l_module_name, 'In. control num', p_txns_history_Rec.internal_control_number);
93: END IF;
94:
95: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

88: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_txns_history_Rec.ecx_message_id);
89: wsh_debug_sv.log (l_module_name, 'Event Name', p_txns_history_Rec.event_name);
90: wsh_debug_sv.log (l_module_name, 'Event Key', p_txns_history_Rec.event_key);
91: wsh_debug_sv.log (l_module_name, 'Item Type', p_txns_history_Rec.item_type);
92: wsh_debug_sv.log (l_module_name, 'In. control num', p_txns_history_Rec.internal_control_number);
93: END IF;
94:
95: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
96:

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

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

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

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

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

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

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

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

Line 160: wsh_debug_sv.log (l_module_name,

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

Line 163: wsh_debug_sv.log (l_module_name,

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

Line 284: wsh_debug_sv.log (l_module_name,'Record already exists. So Need to Update

280: x_txns_id := x_transaction_id;
281:
282: ELSE
283: IF l_debug_on THEN
284: wsh_debug_sv.log (l_module_name,'Record already exists. So Need to Update
285: in wsh_transactions_history');
286: END IF;
287: -- Record already exists. So Need to Update
288: -- Before Update Check for validity of status

Line 348: wsh_debug_sv.pop(l_module_name);

344:
345: END IF; -- if p_txns_history_rec columns are not null
346:
347: IF l_debug_on THEN
348: wsh_debug_sv.pop(l_module_name);
349: END IF;
350: EXCEPTION
351: WHEN invalid_status THEN
352: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

350: EXCEPTION
351: WHEN invalid_status THEN
352: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_status exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
355: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_status');
356: END IF;
357: WHEN invalid_action THEN
358: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

351: WHEN invalid_status THEN
352: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_status exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
355: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_status');
356: END IF;
357: WHEN invalid_action THEN
358: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
359: IF l_debug_on THEN

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

356: END IF;
357: WHEN invalid_action THEN
358: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
359: IF l_debug_on THEN
360: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action');
362: END IF;
363: WHEN invalid_entity_type THEN
364: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

357: WHEN invalid_action THEN
358: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
359: IF l_debug_on THEN
360: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_action exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
361: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_action');
362: END IF;
363: WHEN invalid_entity_type THEN
364: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
365: IF l_debug_on THEN

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

362: END IF;
363: WHEN invalid_entity_type THEN
364: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
365: IF l_debug_on THEN
366: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
367: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');
368: END IF;
369: WHEN invalid_direction THEN
370: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

363: WHEN invalid_entity_type THEN
364: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
365: IF l_debug_on THEN
366: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
367: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_entity_type');
368: END IF;
369: WHEN invalid_direction THEN
370: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
371: IF l_debug_on THEN

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

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

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

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

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

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

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

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

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

380: END IF;
381: WHEN Others THEN
382: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
385: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
386: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
387: END IF;
388:

Line 385: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

381: WHEN Others THEN
382: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
385: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
386: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
387: END IF;
388:
389: END Create_Update_Txns_History;

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

382: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
383: IF l_debug_on THEN
384: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
385: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
386: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
387: END IF;
388:
389: END Create_Update_Txns_History;
390:

Line 453: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

449: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
450: --
451: IF l_debug_on IS NULL
452: THEN
453: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
454: END IF;
455: --
456: IF l_debug_on THEN
457: wsh_debug_sv.push(l_module_name,'Get_Txns_History');

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

453: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
454: END IF;
455: --
456: IF l_debug_on THEN
457: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
458: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
459: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
460: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);
461: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);

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

454: END IF;
455: --
456: IF l_debug_on THEN
457: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
458: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
459: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
460: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);
461: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);
462: END IF;

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

455: --
456: IF l_debug_on THEN
457: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
458: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
459: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
460: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);
461: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);
462: END IF;
463:

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

456: IF l_debug_on THEN
457: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
458: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
459: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
460: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);
461: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);
462: END IF;
463:
464: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

457: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
458: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
459: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
460: wsh_debug_sv.log (l_module_name, 'Direction' , p_direction);
461: wsh_debug_sv.log (l_module_name, 'Document Type', p_document_type);
462: END IF;
463:
464: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
465:

Line 476: wsh_debug_sv.pop(l_module_name);

472:
473: CLOSE txns_history_cur;
474:
475: IF l_debug_on THEN
476: wsh_debug_sv.pop(l_module_name);
477: END IF;
478:
479: EXCEPTION
480: WHEN no_record_found THEN

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

484: END IF;
485:
486: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
487: IF l_debug_on THEN
488: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
489: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
490: END IF;
491: WHEN Others THEN
492: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

485:
486: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
487: IF l_debug_on THEN
488: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
489: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
490: END IF;
491: WHEN Others THEN
492: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
493: IF l_debug_on THEN

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

490: END IF;
491: WHEN Others THEN
492: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
493: IF l_debug_on THEN
494: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
495: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
497: END IF;
498: END Get_Txns_History;

Line 495: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

491: WHEN Others THEN
492: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
493: IF l_debug_on THEN
494: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
495: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
497: END IF;
498: END Get_Txns_History;
499:

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

492: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
493: IF l_debug_on THEN
494: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
495: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
496: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
497: END IF;
498: END Get_Txns_History;
499:
500: /*

Line 547: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

543: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
544: --
545: IF l_debug_on IS NULL
546: THEN
547: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
548: END IF;
549: --
550: IF l_debug_on THEN
551: wsh_debug_sv.push(l_module_name,'Get_Txns_History');

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

547: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
548: END IF;
549: --
550: IF l_debug_on THEN
551: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
552: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);
553: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
554: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
555: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);

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

548: END IF;
549: --
550: IF l_debug_on THEN
551: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
552: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);
553: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
554: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
555: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
556: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);

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

549: --
550: IF l_debug_on THEN
551: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
552: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);
553: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
554: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
555: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
556: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
557: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);

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

550: IF l_debug_on THEN
551: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
552: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);
553: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
554: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
555: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
556: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
557: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
558: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);

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

551: wsh_debug_sv.push(l_module_name,'Get_Txns_History');
552: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);
553: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
554: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
555: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
556: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
557: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
558: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
559: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);

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

552: wsh_debug_sv.log (l_module_name, 'Transaction ID', p_transaction_id);
553: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
554: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
555: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
556: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
557: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
558: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
559: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
560: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);

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

553: wsh_debug_sv.log (l_module_name, 'document Type', p_document_type);
554: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
555: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
556: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
557: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
558: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
559: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
560: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
561: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);

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

554: wsh_debug_sv.log (l_module_name, 'Doc Direction', p_document_direction);
555: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
556: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
557: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
558: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
559: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
560: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
561: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
562: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);

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

555: wsh_debug_sv.log (l_module_name, 'Doc number', p_document_number);
556: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
557: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
558: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
559: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
560: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
561: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
562: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
563: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);

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

556: wsh_debug_sv.log (l_module_name, 'Orig doc num', p_orig_document_number);
557: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
558: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
559: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
560: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
561: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
562: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
563: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
564: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);

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

557: wsh_debug_sv.log (l_module_name, 'Entity Type', p_entity_type);
558: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
559: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
560: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
561: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
562: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
563: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
564: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
565: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);

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

558: wsh_debug_sv.log (l_module_name, 'Entity number', p_entity_number);
559: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
560: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
561: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
562: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
563: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
564: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
565: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
566: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);

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

559: wsh_debug_sv.log (l_module_name, 'TP id', p_trading_partner_id);
560: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
561: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
562: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
563: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
564: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
565: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
566: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);
567: END IF;

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

560: wsh_debug_sv.log (l_module_name, 'Action type', p_action_type);
561: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
562: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
563: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
564: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
565: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
566: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);
567: END IF;
568:

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

561: wsh_debug_sv.log (l_module_name, 'Transaction status', p_transaction_status);
562: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
563: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
564: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
565: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
566: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);
567: END IF;
568:
569: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

562: wsh_debug_sv.log (l_module_name, 'ECX Message ID', p_ecx_message_id);
563: wsh_debug_sv.log (l_module_name, 'Event Name', p_event_name);
564: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
565: wsh_debug_sv.log (l_module_name, 'Item Type', p_item_type);
566: wsh_debug_sv.log (l_module_name, 'In. control num', p_internal_control_number);
567: END IF;
568:
569: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
570:

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

589: x_txns_id => l_txn_id,
590: x_return_status => l_return_status);
591:
592: IF l_debug_on THEN
593: wsh_debug_sv.log (l_module_name, 'Return status from Create_Update_Txns_History', l_return_status);
594: END IF;
595:
596: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
597: raise create_update_failed;

Line 600: wsh_debug_sv.pop(l_module_name);

596: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
597: raise create_update_failed;
598: END IF;
599: IF l_debug_on THEN
600: wsh_debug_sv.pop(l_module_name);
601: END IF;
602: EXCEPTION
603: WHEN create_update_failed THEN
604: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 606: wsh_debug_sv.pop(l_module_name);

602: EXCEPTION
603: WHEN create_update_failed THEN
604: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
605: IF l_debug_on THEN
606: wsh_debug_sv.pop(l_module_name);
607: END IF;
608: WHEN Others THEN
609: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
610: IF l_debug_on THEN

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

607: END IF;
608: WHEN Others THEN
609: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
610: IF l_debug_on THEN
611: wsh_debug_sv.pop(l_module_name,'EXCEPTION: '||SUBSTR(SQLERRM,1,200));
612: END IF;
613: END Create_Txns_History;
614:
615: