239: p_earn_moh := 1;
240: l_txn_type := 0;
241:
242: IF (l_debug = 'Y') THEN
243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IN Rule Package CST_MOHRULES_PUB.apply_moh');
244: END IF;
245:
246: SELECT mmt.transaction_type_id, mmt.transaction_source_type_id
247: INTO l_txn_type_id, l_source_type_id
281:
282: l_stmt_num := 70;
283:
284: IF (l_debug = 'Y') THEN
285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_txn_type:' || l_txn_type);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_txn_type_id:' || l_txn_type_id);
287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'organization_id:' || p_organization_id);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'item_type:'|| l_item_type);
289: END IF;
282: l_stmt_num := 70;
283:
284: IF (l_debug = 'Y') THEN
285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_txn_type:' || l_txn_type);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_txn_type_id:' || l_txn_type_id);
287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'organization_id:' || p_organization_id);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'item_type:'|| l_item_type);
289: END IF;
290:
283:
284: IF (l_debug = 'Y') THEN
285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_txn_type:' || l_txn_type);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_txn_type_id:' || l_txn_type_id);
287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'organization_id:' || p_organization_id);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'item_type:'|| l_item_type);
289: END IF;
290:
291: IF(l_txn_type <> 0) THEN
284: IF (l_debug = 'Y') THEN
285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_txn_type:' || l_txn_type);
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_txn_type_id:' || l_txn_type_id);
287: FND_FILE.PUT_LINE(FND_FILE.LOG, 'organization_id:' || p_organization_id);
288: FND_FILE.PUT_LINE(FND_FILE.LOG, 'item_type:'|| l_item_type);
289: END IF;
290:
291: IF(l_txn_type <> 0) THEN
292:
330:
331: IF(l_count > 1) THEN
332: FND_MESSAGE.SET_NAME('BOM', 'CST_RULE_MULTIPLE');
333: FND_MESSAGE.SET_TOKEN('RULE_ID',l_rule_id);
334: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
335: END IF;
336:
337: IF (l_debug = 'Y') THEN
338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'earn moh :' || p_earn_moh);
334: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
335: END IF;
336:
337: IF (l_debug = 'Y') THEN
338: FND_FILE.PUT_LINE(FND_FILE.LOG, 'earn moh :' || p_earn_moh);
339: END IF;
340:
341: EXCEPTION
342: WHEN fnd_api.g_exc_error then