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.OZF_SALES_TRANSACTIONS_PVT dependencies on OZF_UTILITY_PVT

Line 71: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

67: END IF;
68:
69: -- Debug Message
70: IF OZF_DEBUG_LOW_ON THEN
71: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
72: END IF;
73:
74: -- Initialize API return status to sucess
75: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 79: ozf_utility_PVT.debug_message('IN OM:' );

75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: If p_transaction.source_code = 'OM' THEN
78: IF OZF_DEBUG_LOW_ON THEN
79: ozf_utility_PVT.debug_message('IN OM:' );
80: ozf_utility_PVT.debug_message('sold_to_cust_account_id: '||p_transaction.sold_to_cust_account_id);
81: ozf_utility_PVT.debug_message('sold_to_party_id: '||p_transaction.sold_to_party_id);
82: ozf_utility_PVT.debug_message('bill_to_site_use_id: '||p_transaction.bill_to_site_use_id);
83: ozf_utility_PVT.debug_message('ship_to_site_use_id: '||p_transaction.ship_to_site_use_id);

Line 80: ozf_utility_PVT.debug_message('sold_to_cust_account_id: '||p_transaction.sold_to_cust_account_id);

76:
77: If p_transaction.source_code = 'OM' THEN
78: IF OZF_DEBUG_LOW_ON THEN
79: ozf_utility_PVT.debug_message('IN OM:' );
80: ozf_utility_PVT.debug_message('sold_to_cust_account_id: '||p_transaction.sold_to_cust_account_id);
81: ozf_utility_PVT.debug_message('sold_to_party_id: '||p_transaction.sold_to_party_id);
82: ozf_utility_PVT.debug_message('bill_to_site_use_id: '||p_transaction.bill_to_site_use_id);
83: ozf_utility_PVT.debug_message('ship_to_site_use_id: '||p_transaction.ship_to_site_use_id);
84: ozf_utility_PVT.debug_message('header_id: '||p_transaction.header_id);

Line 81: ozf_utility_PVT.debug_message('sold_to_party_id: '||p_transaction.sold_to_party_id);

77: If p_transaction.source_code = 'OM' THEN
78: IF OZF_DEBUG_LOW_ON THEN
79: ozf_utility_PVT.debug_message('IN OM:' );
80: ozf_utility_PVT.debug_message('sold_to_cust_account_id: '||p_transaction.sold_to_cust_account_id);
81: ozf_utility_PVT.debug_message('sold_to_party_id: '||p_transaction.sold_to_party_id);
82: ozf_utility_PVT.debug_message('bill_to_site_use_id: '||p_transaction.bill_to_site_use_id);
83: ozf_utility_PVT.debug_message('ship_to_site_use_id: '||p_transaction.ship_to_site_use_id);
84: ozf_utility_PVT.debug_message('header_id: '||p_transaction.header_id);
85: ozf_utility_PVT.debug_message('line_id: '||p_transaction.line_id);

Line 82: ozf_utility_PVT.debug_message('bill_to_site_use_id: '||p_transaction.bill_to_site_use_id);

78: IF OZF_DEBUG_LOW_ON THEN
79: ozf_utility_PVT.debug_message('IN OM:' );
80: ozf_utility_PVT.debug_message('sold_to_cust_account_id: '||p_transaction.sold_to_cust_account_id);
81: ozf_utility_PVT.debug_message('sold_to_party_id: '||p_transaction.sold_to_party_id);
82: ozf_utility_PVT.debug_message('bill_to_site_use_id: '||p_transaction.bill_to_site_use_id);
83: ozf_utility_PVT.debug_message('ship_to_site_use_id: '||p_transaction.ship_to_site_use_id);
84: ozf_utility_PVT.debug_message('header_id: '||p_transaction.header_id);
85: ozf_utility_PVT.debug_message('line_id: '||p_transaction.line_id);
86: END IF;

Line 83: ozf_utility_PVT.debug_message('ship_to_site_use_id: '||p_transaction.ship_to_site_use_id);

79: ozf_utility_PVT.debug_message('IN OM:' );
80: ozf_utility_PVT.debug_message('sold_to_cust_account_id: '||p_transaction.sold_to_cust_account_id);
81: ozf_utility_PVT.debug_message('sold_to_party_id: '||p_transaction.sold_to_party_id);
82: ozf_utility_PVT.debug_message('bill_to_site_use_id: '||p_transaction.bill_to_site_use_id);
83: ozf_utility_PVT.debug_message('ship_to_site_use_id: '||p_transaction.ship_to_site_use_id);
84: ozf_utility_PVT.debug_message('header_id: '||p_transaction.header_id);
85: ozf_utility_PVT.debug_message('line_id: '||p_transaction.line_id);
86: END IF;
87:

Line 84: ozf_utility_PVT.debug_message('header_id: '||p_transaction.header_id);

80: ozf_utility_PVT.debug_message('sold_to_cust_account_id: '||p_transaction.sold_to_cust_account_id);
81: ozf_utility_PVT.debug_message('sold_to_party_id: '||p_transaction.sold_to_party_id);
82: ozf_utility_PVT.debug_message('bill_to_site_use_id: '||p_transaction.bill_to_site_use_id);
83: ozf_utility_PVT.debug_message('ship_to_site_use_id: '||p_transaction.ship_to_site_use_id);
84: ozf_utility_PVT.debug_message('header_id: '||p_transaction.header_id);
85: ozf_utility_PVT.debug_message('line_id: '||p_transaction.line_id);
86: END IF;
87:
88: IF p_transaction.sold_to_cust_account_id is NULL OR

Line 85: ozf_utility_PVT.debug_message('line_id: '||p_transaction.line_id);

81: ozf_utility_PVT.debug_message('sold_to_party_id: '||p_transaction.sold_to_party_id);
82: ozf_utility_PVT.debug_message('bill_to_site_use_id: '||p_transaction.bill_to_site_use_id);
83: ozf_utility_PVT.debug_message('ship_to_site_use_id: '||p_transaction.ship_to_site_use_id);
84: ozf_utility_PVT.debug_message('header_id: '||p_transaction.header_id);
85: ozf_utility_PVT.debug_message('line_id: '||p_transaction.line_id);
86: END IF;
87:
88: IF p_transaction.sold_to_cust_account_id is NULL OR
89: p_transaction.sold_to_party_id is NULL OR

Line 93: ozf_utility_PVT.error_message('OZF_TRANS_BILLTO_NULL');

89: p_transaction.sold_to_party_id is NULL OR
90: p_transaction.bill_to_site_use_id is NULL OR
91: p_transaction.ship_to_site_use_id is NULL THEN
92:
93: ozf_utility_PVT.error_message('OZF_TRANS_BILLTO_NULL');
94: RAISE FND_API.g_exc_unexpected_error;
95: END IF;
96:
97: IF p_transaction.header_id is NULL OR

Line 100: ozf_utility_PVT.error_message('OZF_TRANS_ORDER_REF_NULL');

96:
97: IF p_transaction.header_id is NULL OR
98: p_transaction.line_id is NULL THEN
99:
100: ozf_utility_PVT.error_message('OZF_TRANS_ORDER_REF_NULL');
101: RAISE FND_API.g_exc_unexpected_error;
102: END IF;
103:
104: ELSIF p_transaction.source_code = 'IS' THEN

Line 106: ozf_utility_PVT.debug_message('IN IS:' );

102: END IF;
103:
104: ELSIF p_transaction.source_code = 'IS' THEN
105: IF OZF_DEBUG_LOW_ON THEN
106: ozf_utility_PVT.debug_message('IN IS:' );
107: ozf_utility_PVT.debug_message('sold_from_party_id: '||p_transaction.sold_from_party_id);
108: ozf_utility_PVT.debug_message('header_id: '||p_transaction.header_id);
109: ozf_utility_PVT.debug_message('line_id: '||p_transaction.line_id);
110: END IF;

Line 107: ozf_utility_PVT.debug_message('sold_from_party_id: '||p_transaction.sold_from_party_id);

103:
104: ELSIF p_transaction.source_code = 'IS' THEN
105: IF OZF_DEBUG_LOW_ON THEN
106: ozf_utility_PVT.debug_message('IN IS:' );
107: ozf_utility_PVT.debug_message('sold_from_party_id: '||p_transaction.sold_from_party_id);
108: ozf_utility_PVT.debug_message('header_id: '||p_transaction.header_id);
109: ozf_utility_PVT.debug_message('line_id: '||p_transaction.line_id);
110: END IF;
111:

Line 108: ozf_utility_PVT.debug_message('header_id: '||p_transaction.header_id);

104: ELSIF p_transaction.source_code = 'IS' THEN
105: IF OZF_DEBUG_LOW_ON THEN
106: ozf_utility_PVT.debug_message('IN IS:' );
107: ozf_utility_PVT.debug_message('sold_from_party_id: '||p_transaction.sold_from_party_id);
108: ozf_utility_PVT.debug_message('header_id: '||p_transaction.header_id);
109: ozf_utility_PVT.debug_message('line_id: '||p_transaction.line_id);
110: END IF;
111:
112: IF p_transaction.sold_from_party_id is null THEN

Line 109: ozf_utility_PVT.debug_message('line_id: '||p_transaction.line_id);

105: IF OZF_DEBUG_LOW_ON THEN
106: ozf_utility_PVT.debug_message('IN IS:' );
107: ozf_utility_PVT.debug_message('sold_from_party_id: '||p_transaction.sold_from_party_id);
108: ozf_utility_PVT.debug_message('header_id: '||p_transaction.header_id);
109: ozf_utility_PVT.debug_message('line_id: '||p_transaction.line_id);
110: END IF;
111:
112: IF p_transaction.sold_from_party_id is null THEN
113:

Line 114: ozf_utility_PVT.error_message('OZF_TRANS_SOLDFROM_NULL');

110: END IF;
111:
112: IF p_transaction.sold_from_party_id is null THEN
113:
114: ozf_utility_PVT.error_message('OZF_TRANS_SOLDFROM_NULL');
115: RAISE FND_API.g_exc_unexpected_error;
116: END IF;
117:
118: IF p_transaction.header_id is NULL OR

Line 121: ozf_utility_PVT.error_message('OZF_TRANS_ORDER_REF_NULL');

117:
118: IF p_transaction.header_id is NULL OR
119: p_transaction.line_id is NULL THEN
120:
121: ozf_utility_PVT.error_message('OZF_TRANS_ORDER_REF_NULL');
122: RAISE FND_API.g_exc_unexpected_error;
123: END IF;
124:
125: ELSIF p_transaction.source_code = 'MA' THEN

Line 127: ozf_utility_PVT.debug_message('IN MA:' );

123: END IF;
124:
125: ELSIF p_transaction.source_code = 'MA' THEN
126: IF OZF_DEBUG_LOW_ON THEN
127: ozf_utility_PVT.debug_message('IN MA:' );
128: ozf_utility_PVT.debug_message('sold_to_party_id: '||p_transaction.sold_to_party_id);
129: END IF;
130:
131: IF p_transaction.sold_to_party_id is null THEN

Line 128: ozf_utility_PVT.debug_message('sold_to_party_id: '||p_transaction.sold_to_party_id);

124:
125: ELSIF p_transaction.source_code = 'MA' THEN
126: IF OZF_DEBUG_LOW_ON THEN
127: ozf_utility_PVT.debug_message('IN MA:' );
128: ozf_utility_PVT.debug_message('sold_to_party_id: '||p_transaction.sold_to_party_id);
129: END IF;
130:
131: IF p_transaction.sold_to_party_id is null THEN
132: OZF_UTILITY_PVT.error_message('OZF_TRANS_SOLD_TO_PTY_NULL');

Line 132: OZF_UTILITY_PVT.error_message('OZF_TRANS_SOLD_TO_PTY_NULL');

128: ozf_utility_PVT.debug_message('sold_to_party_id: '||p_transaction.sold_to_party_id);
129: END IF;
130:
131: IF p_transaction.sold_to_party_id is null THEN
132: OZF_UTILITY_PVT.error_message('OZF_TRANS_SOLD_TO_PTY_NULL');
133: RAISE FND_API.g_exc_unexpected_error;
134: END IF;
135: ELSE
136: OZF_UTILITY_PVT.error_message('OZF_TRANS_SOURCE_CD_WRG');

Line 136: OZF_UTILITY_PVT.error_message('OZF_TRANS_SOURCE_CD_WRG');

132: OZF_UTILITY_PVT.error_message('OZF_TRANS_SOLD_TO_PTY_NULL');
133: RAISE FND_API.g_exc_unexpected_error;
134: END IF;
135: ELSE
136: OZF_UTILITY_PVT.error_message('OZF_TRANS_SOURCE_CD_WRG');
137: RAISE FND_API.g_exc_unexpected_error;
138: END IF;
139:
140: -- Debug Message

Line 142: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

138: END IF;
139:
140: -- Debug Message
141: IF OZF_DEBUG_LOW_ON THEN
142: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
143: END IF;
144: --Standard call to get message count and if count=1, get the message
145: FND_MSG_PUB.Count_And_Get (
146: p_encoded => FND_API.G_FALSE,

Line 268: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

264: END IF;
265:
266: -- Debug Message
267: IF OZF_DEBUG_LOW_ON THEN
268: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
269: END IF;
270:
271: -- Initialize API return status to sucess
272: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 275: OZF_UTILITY_PVT.debug_message('inventory_item_id:' ||l_transaction_rec.inventory_item_id);

271: -- Initialize API return status to sucess
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273:
274: IF OZF_DEBUG_LOW_ON THEN
275: OZF_UTILITY_PVT.debug_message('inventory_item_id:' ||l_transaction_rec.inventory_item_id);
276: OZF_UTILITY_PVT.debug_message('transaction_date:' ||l_transaction_rec.transaction_date);
277: OZF_UTILITY_PVT.debug_message('quantity:' ||l_transaction_rec.quantity);
278: OZF_UTILITY_PVT.debug_message('uom_code:' ||l_transaction_rec.uom_code );
279: END IF;

Line 276: OZF_UTILITY_PVT.debug_message('transaction_date:' ||l_transaction_rec.transaction_date);

272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273:
274: IF OZF_DEBUG_LOW_ON THEN
275: OZF_UTILITY_PVT.debug_message('inventory_item_id:' ||l_transaction_rec.inventory_item_id);
276: OZF_UTILITY_PVT.debug_message('transaction_date:' ||l_transaction_rec.transaction_date);
277: OZF_UTILITY_PVT.debug_message('quantity:' ||l_transaction_rec.quantity);
278: OZF_UTILITY_PVT.debug_message('uom_code:' ||l_transaction_rec.uom_code );
279: END IF;
280:

Line 277: OZF_UTILITY_PVT.debug_message('quantity:' ||l_transaction_rec.quantity);

273:
274: IF OZF_DEBUG_LOW_ON THEN
275: OZF_UTILITY_PVT.debug_message('inventory_item_id:' ||l_transaction_rec.inventory_item_id);
276: OZF_UTILITY_PVT.debug_message('transaction_date:' ||l_transaction_rec.transaction_date);
277: OZF_UTILITY_PVT.debug_message('quantity:' ||l_transaction_rec.quantity);
278: OZF_UTILITY_PVT.debug_message('uom_code:' ||l_transaction_rec.uom_code );
279: END IF;
280:
281: IF l_transaction_rec.inventory_item_id is null OR

Line 278: OZF_UTILITY_PVT.debug_message('uom_code:' ||l_transaction_rec.uom_code );

274: IF OZF_DEBUG_LOW_ON THEN
275: OZF_UTILITY_PVT.debug_message('inventory_item_id:' ||l_transaction_rec.inventory_item_id);
276: OZF_UTILITY_PVT.debug_message('transaction_date:' ||l_transaction_rec.transaction_date);
277: OZF_UTILITY_PVT.debug_message('quantity:' ||l_transaction_rec.quantity);
278: OZF_UTILITY_PVT.debug_message('uom_code:' ||l_transaction_rec.uom_code );
279: END IF;
280:
281: IF l_transaction_rec.inventory_item_id is null OR
282: l_transaction_rec.transaction_date is null OR

Line 286: OZF_UTILITY_PVT.error_message('OZF_SALES_TRANS_MISS');

282: l_transaction_rec.transaction_date is null OR
283: l_transaction_rec.quantity is null OR
284: l_transaction_rec.uom_code is null THEN
285:
286: OZF_UTILITY_PVT.error_message('OZF_SALES_TRANS_MISS');
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: END IF;
289:
290: -- Validate the record

Line 319: ozf_utility_PVT.debug_message('start conversion');

315: l_transaction_rec.quantity := abs( l_transaction_rec.quantity );
316: END IF;
317:
318: IF OZF_DEBUG_LOW_ON THEN
319: ozf_utility_PVT.debug_message('start conversion');
320: END IF;
321:
322: l_transaction_rec.error_flag := 'N';
323: -- uom_code conversion

Line 355: ozf_utility_PVT.debug_message('primary_uom_code: '||l_transaction_rec.primary_uom_code);

351: END IF;
352: END IF;
353: END IF;
354: IF OZF_DEBUG_LOW_ON THEN
355: ozf_utility_PVT.debug_message('primary_uom_code: '||l_transaction_rec.primary_uom_code);
356: ozf_utility_PVT.debug_message('primary_quantity: '||l_transaction_rec.primary_quantity);
357: ozf_utility_PVT.debug_message('error_flag: '||l_transaction_rec.error_flag);
358: END IF;
359: -- Second check whether uom_code = common uom_code

Line 356: ozf_utility_PVT.debug_message('primary_quantity: '||l_transaction_rec.primary_quantity);

352: END IF;
353: END IF;
354: IF OZF_DEBUG_LOW_ON THEN
355: ozf_utility_PVT.debug_message('primary_uom_code: '||l_transaction_rec.primary_uom_code);
356: ozf_utility_PVT.debug_message('primary_quantity: '||l_transaction_rec.primary_quantity);
357: ozf_utility_PVT.debug_message('error_flag: '||l_transaction_rec.error_flag);
358: END IF;
359: -- Second check whether uom_code = common uom_code
360: -- If not convert quantity

Line 357: ozf_utility_PVT.debug_message('error_flag: '||l_transaction_rec.error_flag);

353: END IF;
354: IF OZF_DEBUG_LOW_ON THEN
355: ozf_utility_PVT.debug_message('primary_uom_code: '||l_transaction_rec.primary_uom_code);
356: ozf_utility_PVT.debug_message('primary_quantity: '||l_transaction_rec.primary_quantity);
357: ozf_utility_PVT.debug_message('error_flag: '||l_transaction_rec.error_flag);
358: END IF;
359: -- Second check whether uom_code = common uom_code
360: -- If not convert quantity
361: IF l_transaction_rec.common_uom_code is null or l_transaction_rec.common_quantity is null THEN

Line 387: ozf_utility_PVT.debug_message('common_code: '||l_transaction_rec.common_uom_code);

383: END IF;
384: END IF;
385: END IF;
386: IF OZF_DEBUG_LOW_ON THEN
387: ozf_utility_PVT.debug_message('common_code: '||l_transaction_rec.common_uom_code);
388: ozf_utility_PVT.debug_message('common_quantity: '||l_transaction_rec.common_quantity);
389: ozf_utility_PVT.debug_message('error_flag: '||l_transaction_rec.error_flag);
390: END IF;
391:

Line 388: ozf_utility_PVT.debug_message('common_quantity: '||l_transaction_rec.common_quantity);

384: END IF;
385: END IF;
386: IF OZF_DEBUG_LOW_ON THEN
387: ozf_utility_PVT.debug_message('common_code: '||l_transaction_rec.common_uom_code);
388: ozf_utility_PVT.debug_message('common_quantity: '||l_transaction_rec.common_quantity);
389: ozf_utility_PVT.debug_message('error_flag: '||l_transaction_rec.error_flag);
390: END IF;
391:
392: -- Third check whether common currency_code =

Line 389: ozf_utility_PVT.debug_message('error_flag: '||l_transaction_rec.error_flag);

385: END IF;
386: IF OZF_DEBUG_LOW_ON THEN
387: ozf_utility_PVT.debug_message('common_code: '||l_transaction_rec.common_uom_code);
388: ozf_utility_PVT.debug_message('common_quantity: '||l_transaction_rec.common_quantity);
389: ozf_utility_PVT.debug_message('error_flag: '||l_transaction_rec.error_flag);
390: END IF;
391:
392: -- Third check whether common currency_code =
393: -- If not convert currency code

Line 409: ozf_utility_pvt.Convert_Currency (

405: OPEN c_get_conversion_type(l_transaction_rec.org_id);
406: FETCH c_get_conversion_type INTO l_exchange_rate_type;
407: CLOSE c_get_conversion_type;
408: l_transaction_rec.common_currency_code := l_common_currency_code;
409: ozf_utility_pvt.Convert_Currency (
410: x_return_status => l_return_status,
411: p_from_currency => l_transaction_rec.currency_code,
412: p_to_currency => l_common_currency_code,
413: p_conv_type => l_exchange_rate_type,

Line 424: ozf_utility_PVT.debug_message('common_currency_code: '||l_transaction_rec.common_currency_code);

420: END IF;
421: END IF;
422:
423: IF OZF_DEBUG_LOW_ON THEN
424: ozf_utility_PVT.debug_message('common_currency_code: '||l_transaction_rec.common_currency_code);
425: ozf_utility_PVT.debug_message('common_amount: '||l_transaction_rec.common_amount);
426: ozf_utility_PVT.debug_message('error_flag: '||l_transaction_rec.error_flag);
427: END IF;
428:

Line 425: ozf_utility_PVT.debug_message('common_amount: '||l_transaction_rec.common_amount);

421: END IF;
422:
423: IF OZF_DEBUG_LOW_ON THEN
424: ozf_utility_PVT.debug_message('common_currency_code: '||l_transaction_rec.common_currency_code);
425: ozf_utility_PVT.debug_message('common_amount: '||l_transaction_rec.common_amount);
426: ozf_utility_PVT.debug_message('error_flag: '||l_transaction_rec.error_flag);
427: END IF;
428:
429: --fix for bug 6808124

Line 426: ozf_utility_PVT.debug_message('error_flag: '||l_transaction_rec.error_flag);

422:
423: IF OZF_DEBUG_LOW_ON THEN
424: ozf_utility_PVT.debug_message('common_currency_code: '||l_transaction_rec.common_currency_code);
425: ozf_utility_PVT.debug_message('common_amount: '||l_transaction_rec.common_amount);
426: ozf_utility_PVT.debug_message('error_flag: '||l_transaction_rec.error_flag);
427: END IF;
428:
429: --fix for bug 6808124
430: OPEN sales_transation_csr(l_transaction_rec.LINE_ID,l_transaction_rec.source_code);

Line 559: ozf_utility_PVT.debug_message('insert done' || l_sales_transaction_id);

555: );
556:
557: x_sales_transaction_id := l_sales_transaction_id;
558: IF OZF_DEBUG_LOW_ON THEN
559: ozf_utility_PVT.debug_message('insert done' || l_sales_transaction_id);
560: END IF;
561:
562: END IF; --IF NVL(l_sales_trans,0) <> 1 THEN
563:

Line 587: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

583:
584:
585: -- Debug Message
586: IF OZF_DEBUG_LOW_ON THEN
587: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
588: END IF;
589: --Standard call to get message count and if count=1, get the message
590: FND_MSG_PUB.Count_And_Get (
591: p_encoded => FND_API.G_FALSE,

Line 688: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

684: END IF;
685:
686: -- Debug Message
687: IF OZF_DEBUG_LOW_ON THEN
688: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
689: END IF;
690:
691: -- Initialize API return status to sucess
692: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 901: OZF_UTILITY_PVT.debug_message(l_full_name||' : total_primary_quantity = '||l_total_primary_quantity);

897: IF OZF_DEBUG_LOW_ON THEN
898: SELECT SUM(primary_quantity)
899: INTO l_total_primary_quantity
900: FROM ozf_inventory_tmp_t;
901: OZF_UTILITY_PVT.debug_message(l_full_name||' : total_primary_quantity = '||l_total_primary_quantity);
902:
903: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');
904: FOR l_inventory_detl IN c_inventory_detl LOOP
905: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);

Line 903: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');

899: INTO l_total_primary_quantity
900: FROM ozf_inventory_tmp_t;
901: OZF_UTILITY_PVT.debug_message(l_full_name||' : total_primary_quantity = '||l_total_primary_quantity);
902:
903: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');
904: FOR l_inventory_detl IN c_inventory_detl LOOP
905: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);
906: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
907: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);

Line 905: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);

901: OZF_UTILITY_PVT.debug_message(l_full_name||' : total_primary_quantity = '||l_total_primary_quantity);
902:
903: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');
904: FOR l_inventory_detl IN c_inventory_detl LOOP
905: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);
906: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
907: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
908: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
909: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);

Line 906: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);

902:
903: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');
904: FOR l_inventory_detl IN c_inventory_detl LOOP
905: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);
906: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
907: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
908: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
909: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
910: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);

Line 907: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);

903: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');
904: FOR l_inventory_detl IN c_inventory_detl LOOP
905: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);
906: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
907: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
908: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
909: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
910: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);
911: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');

Line 908: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);

904: FOR l_inventory_detl IN c_inventory_detl LOOP
905: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);
906: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
907: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
908: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
909: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
910: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);
911: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');
912: END LOOP;

Line 909: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);

905: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);
906: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
907: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
908: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
909: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
910: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);
911: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');
912: END LOOP;
913: OZF_UTILITY_PVT.debug_message('------------------------------');

Line 910: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);

906: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
907: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
908: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
909: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
910: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);
911: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');
912: END LOOP;
913: OZF_UTILITY_PVT.debug_message('------------------------------');
914: END IF;

Line 911: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');

907: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
908: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
909: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
910: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);
911: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');
912: END LOOP;
913: OZF_UTILITY_PVT.debug_message('------------------------------');
914: END IF;
915: -- 6511302 (-)

Line 913: OZF_UTILITY_PVT.debug_message('------------------------------');

909: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
910: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);
911: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');
912: END LOOP;
913: OZF_UTILITY_PVT.debug_message('------------------------------');
914: END IF;
915: -- 6511302 (-)
916:
917: -- Debug Message

Line 919: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

915: -- 6511302 (-)
916:
917: -- Debug Message
918: IF OZF_DEBUG_LOW_ON THEN
919: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
920: END IF;
921: --Standard call to get message count and if count=1, get the message
922: FND_MSG_PUB.Count_And_Get (
923: p_encoded => FND_API.G_FALSE,

Line 1018: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

1014: END IF;
1015:
1016: -- Debug Message
1017: IF OZF_DEBUG_LOW_ON THEN
1018: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1019: END IF;
1020:
1021: -- Initialize API return status to sucess
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1029: ozf_utility_PVT.debug_message('primary_quantity:' || l_primary_quantity);

1025: FETCH transaction_info_csr into l_primary_quantity, l_inventory_item_id, l_party_id;
1026: CLOSE transaction_info_csr;
1027:
1028: IF OZF_DEBUG_LOW_ON THEN
1029: ozf_utility_PVT.debug_message('primary_quantity:' || l_primary_quantity);
1030: ozf_utility_PVT.debug_message('inventory_item_id:' || l_inventory_item_id);
1031: ozf_utility_PVT.debug_message('party_id:' || l_party_id);
1032: END IF;
1033:

Line 1030: ozf_utility_PVT.debug_message('inventory_item_id:' || l_inventory_item_id);

1026: CLOSE transaction_info_csr;
1027:
1028: IF OZF_DEBUG_LOW_ON THEN
1029: ozf_utility_PVT.debug_message('primary_quantity:' || l_primary_quantity);
1030: ozf_utility_PVT.debug_message('inventory_item_id:' || l_inventory_item_id);
1031: ozf_utility_PVT.debug_message('party_id:' || l_party_id);
1032: END IF;
1033:
1034: update ozf_inventory_tmp_t

Line 1031: ozf_utility_PVT.debug_message('party_id:' || l_party_id);

1027:
1028: IF OZF_DEBUG_LOW_ON THEN
1029: ozf_utility_PVT.debug_message('primary_quantity:' || l_primary_quantity);
1030: ozf_utility_PVT.debug_message('inventory_item_id:' || l_inventory_item_id);
1031: ozf_utility_PVT.debug_message('party_id:' || l_party_id);
1032: END IF;
1033:
1034: update ozf_inventory_tmp_t
1035: set primary_quantity = primary_quantity - l_primary_quantity

Line 1041: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

1037: and inventory_item_id = l_inventory_item_id;
1038:
1039: -- Debug Message
1040: IF OZF_DEBUG_LOW_ON THEN
1041: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1042: END IF;
1043: --Standard call to get message count and if count=1, get the message
1044: FND_MSG_PUB.Count_And_Get (
1045: p_encoded => FND_API.G_FALSE,

Line 1182: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

1178: END IF;
1179:
1180: -- Debug Message
1181: IF OZF_DEBUG_LOW_ON THEN
1182: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1183: END IF;
1184:
1185: -- Initialize API return status to sucess
1186: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1262: OZF_UTILITY_PVT.debug_message(l_full_name || ':order number = '||p_line_int_rec.order_number);

1258: END IF;
1259:
1260: -- 6511302 (+)
1261: IF OZF_DEBUG_LOW_ON THEN
1262: OZF_UTILITY_PVT.debug_message(l_full_name || ':order number = '||p_line_int_rec.order_number);
1263: OZF_UTILITY_PVT.debug_message(l_full_name || ':transfer type = '||l_transfer_type);
1264: OZF_UTILITY_PVT.debug_message(l_full_name || ':l_primary_quantity = '||l_primary_quantity);
1265: OZF_UTILITY_PVT.debug_message(l_full_name || ':line quantity = '||ABS(l_converted_quantity));
1266: OZF_UTILITY_PVT.debug_message(l_full_name || ':item id = ' || p_line_int_rec.inventory_item_id);

Line 1263: OZF_UTILITY_PVT.debug_message(l_full_name || ':transfer type = '||l_transfer_type);

1259:
1260: -- 6511302 (+)
1261: IF OZF_DEBUG_LOW_ON THEN
1262: OZF_UTILITY_PVT.debug_message(l_full_name || ':order number = '||p_line_int_rec.order_number);
1263: OZF_UTILITY_PVT.debug_message(l_full_name || ':transfer type = '||l_transfer_type);
1264: OZF_UTILITY_PVT.debug_message(l_full_name || ':l_primary_quantity = '||l_primary_quantity);
1265: OZF_UTILITY_PVT.debug_message(l_full_name || ':line quantity = '||ABS(l_converted_quantity));
1266: OZF_UTILITY_PVT.debug_message(l_full_name || ':item id = ' || p_line_int_rec.inventory_item_id);
1267: OZF_UTILITY_PVT.debug_message(l_full_name || ':sold_from_party_id = ' || l_sold_from_party_id);

Line 1264: OZF_UTILITY_PVT.debug_message(l_full_name || ':l_primary_quantity = '||l_primary_quantity);

1260: -- 6511302 (+)
1261: IF OZF_DEBUG_LOW_ON THEN
1262: OZF_UTILITY_PVT.debug_message(l_full_name || ':order number = '||p_line_int_rec.order_number);
1263: OZF_UTILITY_PVT.debug_message(l_full_name || ':transfer type = '||l_transfer_type);
1264: OZF_UTILITY_PVT.debug_message(l_full_name || ':l_primary_quantity = '||l_primary_quantity);
1265: OZF_UTILITY_PVT.debug_message(l_full_name || ':line quantity = '||ABS(l_converted_quantity));
1266: OZF_UTILITY_PVT.debug_message(l_full_name || ':item id = ' || p_line_int_rec.inventory_item_id);
1267: OZF_UTILITY_PVT.debug_message(l_full_name || ':sold_from_party_id = ' || l_sold_from_party_id);
1268: END IF;

Line 1265: OZF_UTILITY_PVT.debug_message(l_full_name || ':line quantity = '||ABS(l_converted_quantity));

1261: IF OZF_DEBUG_LOW_ON THEN
1262: OZF_UTILITY_PVT.debug_message(l_full_name || ':order number = '||p_line_int_rec.order_number);
1263: OZF_UTILITY_PVT.debug_message(l_full_name || ':transfer type = '||l_transfer_type);
1264: OZF_UTILITY_PVT.debug_message(l_full_name || ':l_primary_quantity = '||l_primary_quantity);
1265: OZF_UTILITY_PVT.debug_message(l_full_name || ':line quantity = '||ABS(l_converted_quantity));
1266: OZF_UTILITY_PVT.debug_message(l_full_name || ':item id = ' || p_line_int_rec.inventory_item_id);
1267: OZF_UTILITY_PVT.debug_message(l_full_name || ':sold_from_party_id = ' || l_sold_from_party_id);
1268: END IF;
1269: -- 6511302 (-)

Line 1266: OZF_UTILITY_PVT.debug_message(l_full_name || ':item id = ' || p_line_int_rec.inventory_item_id);

1262: OZF_UTILITY_PVT.debug_message(l_full_name || ':order number = '||p_line_int_rec.order_number);
1263: OZF_UTILITY_PVT.debug_message(l_full_name || ':transfer type = '||l_transfer_type);
1264: OZF_UTILITY_PVT.debug_message(l_full_name || ':l_primary_quantity = '||l_primary_quantity);
1265: OZF_UTILITY_PVT.debug_message(l_full_name || ':line quantity = '||ABS(l_converted_quantity));
1266: OZF_UTILITY_PVT.debug_message(l_full_name || ':item id = ' || p_line_int_rec.inventory_item_id);
1267: OZF_UTILITY_PVT.debug_message(l_full_name || ':sold_from_party_id = ' || l_sold_from_party_id);
1268: END IF;
1269: -- 6511302 (-)
1270:

Line 1267: OZF_UTILITY_PVT.debug_message(l_full_name || ':sold_from_party_id = ' || l_sold_from_party_id);

1263: OZF_UTILITY_PVT.debug_message(l_full_name || ':transfer type = '||l_transfer_type);
1264: OZF_UTILITY_PVT.debug_message(l_full_name || ':l_primary_quantity = '||l_primary_quantity);
1265: OZF_UTILITY_PVT.debug_message(l_full_name || ':line quantity = '||ABS(l_converted_quantity));
1266: OZF_UTILITY_PVT.debug_message(l_full_name || ':item id = ' || p_line_int_rec.inventory_item_id);
1267: OZF_UTILITY_PVT.debug_message(l_full_name || ':sold_from_party_id = ' || l_sold_from_party_id);
1268: END IF;
1269: -- 6511302 (-)
1270:
1271: INSERT INTO ozf_inventory_tmp_t(

Line 1304: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');

1300: -- Bug 4380203 (-)
1301:
1302: -- 6511302 (+)
1303: IF OZF_DEBUG_LOW_ON THEN
1304: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');
1305: FOR l_inventory_detl IN c_inventory_detl LOOP
1306: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);
1307: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
1308: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);

Line 1306: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);

1302: -- 6511302 (+)
1303: IF OZF_DEBUG_LOW_ON THEN
1304: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');
1305: FOR l_inventory_detl IN c_inventory_detl LOOP
1306: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);
1307: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
1308: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
1309: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
1310: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);

Line 1307: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);

1303: IF OZF_DEBUG_LOW_ON THEN
1304: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');
1305: FOR l_inventory_detl IN c_inventory_detl LOOP
1306: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);
1307: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
1308: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
1309: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
1310: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
1311: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);

Line 1308: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);

1304: OZF_UTILITY_PVT.debug_message('----------Inventory Detail----------');
1305: FOR l_inventory_detl IN c_inventory_detl LOOP
1306: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);
1307: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
1308: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
1309: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
1310: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
1311: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);
1312: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');

Line 1309: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);

1305: FOR l_inventory_detl IN c_inventory_detl LOOP
1306: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);
1307: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
1308: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
1309: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
1310: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
1311: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);
1312: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');
1313: END LOOP;

Line 1310: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);

1306: OZF_UTILITY_PVT.debug_message('party_id = ' || l_inventory_detl.party_id);
1307: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
1308: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
1309: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
1310: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
1311: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);
1312: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');
1313: END LOOP;
1314: OZF_UTILITY_PVT.debug_message('------------------------------');

Line 1311: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);

1307: OZF_UTILITY_PVT.debug_message('inventory_item_id = ' || l_inventory_detl.inventory_item_id);
1308: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
1309: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
1310: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
1311: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);
1312: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');
1313: END LOOP;
1314: OZF_UTILITY_PVT.debug_message('------------------------------');
1315: END IF;

Line 1312: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');

1308: OZF_UTILITY_PVT.debug_message('primary_uom_code = ' || l_inventory_detl.primary_uom_code);
1309: OZF_UTILITY_PVT.debug_message('primary_quantity = ' || l_inventory_detl.primary_quantity);
1310: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
1311: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);
1312: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');
1313: END LOOP;
1314: OZF_UTILITY_PVT.debug_message('------------------------------');
1315: END IF;
1316: -- 6511302 (-)

Line 1314: OZF_UTILITY_PVT.debug_message('------------------------------');

1310: OZF_UTILITY_PVT.debug_message('cust_account_id = ' || l_inventory_detl.cust_account_id);
1311: OZF_UTILITY_PVT.debug_message('transfer_type = ' || l_inventory_detl.transfer_type);
1312: OZF_UTILITY_PVT.debug_message('- - - - - - - - - -');
1313: END LOOP;
1314: OZF_UTILITY_PVT.debug_message('------------------------------');
1315: END IF;
1316: -- 6511302 (-)
1317:
1318: -- Debug Message

Line 1320: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

1316: -- 6511302 (-)
1317:
1318: -- Debug Message
1319: IF OZF_DEBUG_LOW_ON THEN
1320: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1321: END IF;
1322: --Standard call to get message count and if count=1, get the message
1323: FND_MSG_PUB.Count_And_Get (
1324: p_encoded => FND_API.G_FALSE,

Line 1460: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

1456: END IF;
1457:
1458: -- Debug Message
1459: IF OZF_DEBUG_LOW_ON THEN
1460: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1461: END IF;
1462:
1463: -- Initialize API return status to sucess
1464: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1479: OZF_UTILITY_PVT.debug_message('Number of OM lines: ' || l_transaction_id_tbl.LAST);

1475: CLOSE sales_order_info_csr;
1476:
1477: IF l_transaction_id_tbl.exists(1) THEN
1478: IF OZF_DEBUG_LOW_ON THEN
1479: OZF_UTILITY_PVT.debug_message('Number of OM lines: ' || l_transaction_id_tbl.LAST);
1480: END IF;
1481:
1482: -- First check whether p_uom_code is the same as the primary_uom_code.
1483: -- If not, conver the quentity

Line 1520: OZF_UTILITY_PVT.Convert_Currency(

1516: l_used_unit_price_tbl(i) := l_unit_price_tbl(i);
1517: ELSE
1518: -- ?? What exchange type to use ?
1519: -- We will convert it to the asking currency code at the date of transfer.
1520: OZF_UTILITY_PVT.Convert_Currency(
1521: p_from_currency => l_currency_code_tbl(i)
1522: ,p_to_currency => p_currency_code
1523: ,p_conv_type => l_default_exchange_type
1524: ,p_conv_rate => l_rate

Line 1563: x_purchase_price := OZF_UTILITY_PVT.CurrRound(

1559: p_x_purchase_uom_code,
1560: null,
1561: null
1562: );
1563: x_purchase_price := OZF_UTILITY_PVT.CurrRound(
1564: (x_purchase_price * l_uom_ratio)
1565: , p_currency_code
1566: );
1567: END IF;

Line 1579: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

1575: END IF;
1576:
1577: -- Debug Message
1578: IF OZF_DEBUG_LOW_ON THEN
1579: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1580: END IF;
1581: --Standard call to get message count and if count=1, get the message
1582: FND_MSG_PUB.Count_And_Get (
1583: p_encoded => FND_API.G_FALSE,