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.OE_AGREEMENT_UTIL dependencies on OE_MSG_PUB

Line 1156: oe_msg_pub.Add;

1152: ELSE
1153:
1154: fnd_message.set_name('QP', 'QP_NO_PRIVILEGE');
1155: fnd_message.set_token('PRICING_OBJECT', 'Agreement');
1156: oe_msg_pub.Add;
1157:
1158: END IF;
1159:
1160:

Line 1217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1213: EXCEPTION
1214:
1215: WHEN OTHERS THEN
1216:
1217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: OE_MSG_PUB.Add_Exc_Msg
1220: ( G_PKG_NAME
1221: , 'Update_Row'

Line 1219: OE_MSG_PUB.Add_Exc_Msg

1215: WHEN OTHERS THEN
1216:
1217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: OE_MSG_PUB.Add_Exc_Msg
1220: ( G_PKG_NAME
1221: , 'Update_Row'
1222: );
1223: END IF;

Line 1415: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1411: EXCEPTION
1412:
1413: WHEN OTHERS THEN
1414:
1415: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1416: THEN
1417: OE_MSG_PUB.Add_Exc_Msg
1418: ( G_PKG_NAME
1419: , 'Insert_Row'

Line 1417: OE_MSG_PUB.Add_Exc_Msg

1413: WHEN OTHERS THEN
1414:
1415: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1416: THEN
1417: OE_MSG_PUB.Add_Exc_Msg
1418: ( G_PKG_NAME
1419: , 'Insert_Row'
1420: );
1421: END IF;

Line 1532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

1528: x_return_status := FND_API.G_RET_STS_SUCCESS;
1529: else
1530: oe_debug_pub.add('Did not delete agreement');
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1533: FND_MESSAGE.SET_NAME('QP','QP_AGREEMENT_DELETE');
1534: oe_msg_pub.Add;
1535: -- x_return_status := FND_API.G_RET_STS_ERROR;
1536: -- RAISE FND_API.G_EXC_ERROR;

Line 1534: oe_msg_pub.Add;

1530: oe_debug_pub.add('Did not delete agreement');
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1533: FND_MESSAGE.SET_NAME('QP','QP_AGREEMENT_DELETE');
1534: oe_msg_pub.Add;
1535: -- x_return_status := FND_API.G_RET_STS_ERROR;
1536: -- RAISE FND_API.G_EXC_ERROR;
1537: /* Bug 2321498 */
1538: END IF;

Line 1552: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1548: WHEN no_data_found then
1549: NULL;
1550: WHEN OTHERS THEN
1551:
1552: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1553: THEN
1554: OE_MSG_PUB.Add_Exc_Msg
1555: ( G_PKG_NAME
1556: , 'Delete_Row'

Line 1554: OE_MSG_PUB.Add_Exc_Msg

1550: WHEN OTHERS THEN
1551:
1552: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1553: THEN
1554: OE_MSG_PUB.Add_Exc_Msg
1555: ( G_PKG_NAME
1556: , 'Delete_Row'
1557: );
1558: END IF;

Line 1661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1657: (p_pricing_contract_id IS NOT NULL
1658: AND
1659: p_pricing_contract_id <> FND_API.G_MISS_NUM)
1660: THEN
1661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1662: THEN
1663: OE_MSG_PUB.Add_Exc_Msg
1664: ( G_PKG_NAME
1665: , 'Query Rows'

Line 1663: OE_MSG_PUB.Add_Exc_Msg

1659: p_pricing_contract_id <> FND_API.G_MISS_NUM)
1660: THEN
1661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1662: THEN
1663: OE_MSG_PUB.Add_Exc_Msg
1664: ( G_PKG_NAME
1665: , 'Query Rows'
1666: , 'Keys are mutually exclusive: agreement_id = '|| p_agreement_id || ', pricing_contract_id = '|| p_pricing_contract_id
1667: );

Line 1762: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1759:
1760: WHEN OTHERS THEN
1761:
1762: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1763: THEN
1764: OE_MSG_PUB.Add_Exc_Msg
1765: ( G_PKG_NAME
1766: , 'Query_Rows'

Line 1764: OE_MSG_PUB.Add_Exc_Msg

1760: WHEN OTHERS THEN
1761:
1762: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1763: THEN
1764: OE_MSG_PUB.Add_Exc_Msg
1765: ( G_PKG_NAME
1766: , 'Query_Rows'
1767: );
1768: END IF;

Line 2213: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2209:
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: x_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2212:
2213: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2214: THEN
2215:
2216: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_CHANGED');
2217: OE_MSG_PUB.Add;

Line 2217: OE_MSG_PUB.Add;

2213: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2214: THEN
2215:
2216: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_CHANGED');
2217: OE_MSG_PUB.Add;
2218:
2219: END IF;
2220:
2221: END IF;

Line 2232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2228:
2229: x_return_status := FND_API.G_RET_STS_ERROR;
2230: x_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2231:
2232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2233: THEN
2234:
2235: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
2236: OE_MSG_PUB.Add;

Line 2236: OE_MSG_PUB.Add;

2232: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2233: THEN
2234:
2235: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
2236: OE_MSG_PUB.Add;
2237:
2238: END IF;
2239: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2240:

Line 2244: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2240:
2241: x_return_status := FND_API.G_RET_STS_ERROR;
2242: x_Agreement_rec.return_status := FND_API.G_RET_STS_ERROR;
2243:
2244: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2245: THEN
2246:
2247: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
2248: OE_MSG_PUB.Add;

Line 2248: OE_MSG_PUB.Add;

2244: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2245: THEN
2246:
2247: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
2248: OE_MSG_PUB.Add;
2249:
2250: END IF;
2251: WHEN OTHERS THEN
2252:

Line 2256: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2252:
2253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2254: x_Agreement_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2255:
2256: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2257: THEN
2258: OE_MSG_PUB.Add_Exc_Msg
2259: ( G_PKG_NAME
2260: , 'Lock_Row'

Line 2258: OE_MSG_PUB.Add_Exc_Msg

2254: x_Agreement_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2255:
2256: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2257: THEN
2258: OE_MSG_PUB.Add_Exc_Msg
2259: ( G_PKG_NAME
2260: , 'Lock_Row'
2261: );
2262: END IF;

Line 2487: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2483: IF p_Agreement_rec.accounting_rule_id <> FND_API.G_MISS_NUM THEN
2484:
2485: l_Agreement_rec.accounting_rule_id := p_Agreement_rec.accounting_rule_id;
2486:
2487: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2488: THEN
2489:
2490: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');

Line 2492: OE_MSG_PUB.Add;

2488: THEN
2489:
2490: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
2492: OE_MSG_PUB.Add;
2493:
2494: END IF;
2495:
2496: ELSE

Line 2517: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2513: IF p_Agreement_rec.agreement_contact_id <> FND_API.G_MISS_NUM THEN
2514:
2515: l_Agreement_rec.agreement_contact_id := p_Agreement_rec.agreement_contact_id;
2516:
2517: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2518: THEN
2519:
2520: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2521: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_contact');

Line 2522: OE_MSG_PUB.Add;

2518: THEN
2519:
2520: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2521: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_contact');
2522: OE_MSG_PUB.Add;
2523:
2524: END IF;
2525:
2526: ELSE

Line 2547: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2543: IF p_Agreement_rec.agreement_id <> FND_API.G_MISS_NUM THEN
2544:
2545: l_Agreement_rec.agreement_id := p_Agreement_rec.agreement_id;
2546:
2547: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2548: THEN
2549:
2550: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');

Line 2552: OE_MSG_PUB.Add;

2548: THEN
2549:
2550: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
2552: OE_MSG_PUB.Add;
2553:
2554: END IF;
2555:
2556: ELSE

Line 2577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2573: IF p_Agreement_rec.agreement_type_code <> FND_API.G_MISS_CHAR THEN
2574:
2575: l_Agreement_rec.agreement_type_code := p_Agreement_rec.agreement_type_code;
2576:
2577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2578: THEN
2579:
2580: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2581: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_type');

Line 2582: OE_MSG_PUB.Add;

2578: THEN
2579:
2580: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2581: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_type');
2582: OE_MSG_PUB.Add;
2583:
2584: END IF;
2585:
2586: ELSE

Line 2607: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2603: IF p_Agreement_rec.sold_to_org_id <> FND_API.G_MISS_NUM THEN
2604:
2605: l_Agreement_rec.sold_to_org_id := p_Agreement_rec.sold_to_org_id;
2606:
2607: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2608: THEN
2609:
2610: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2611: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer');

Line 2612: OE_MSG_PUB.Add;

2608: THEN
2609:
2610: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2611: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer');
2612: OE_MSG_PUB.Add;
2613:
2614: END IF;
2615:
2616: ELSE

Line 2637: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2633: IF p_Agreement_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
2634:
2635: l_Agreement_rec.freight_terms_code := p_Agreement_rec.freight_terms_code;
2636:
2637: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2638: THEN
2639:
2640: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2641: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');

Line 2642: OE_MSG_PUB.Add;

2638: THEN
2639:
2640: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2641: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
2642: OE_MSG_PUB.Add;
2643:
2644: END IF;
2645:
2646: ELSE

Line 2667: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2663: IF p_Agreement_rec.invoice_contact_id <> FND_API.G_MISS_NUM THEN
2664:
2665: l_Agreement_rec.invoice_contact_id := p_Agreement_rec.invoice_contact_id;
2666:
2667: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2668: THEN
2669:
2670: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2671: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_contact');

Line 2672: OE_MSG_PUB.Add;

2668: THEN
2669:
2670: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2671: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_contact');
2672: OE_MSG_PUB.Add;
2673:
2674: END IF;
2675:
2676: ELSE

Line 2697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2693: IF p_Agreement_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
2694:
2695: l_Agreement_rec.invoice_to_org_id := p_Agreement_rec.invoice_to_org_id;
2696:
2697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2698: THEN
2699:
2700: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_site_use');

Line 2702: OE_MSG_PUB.Add;

2698: THEN
2699:
2700: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_site_use');
2702: OE_MSG_PUB.Add;
2703:
2704: END IF;
2705:
2706: ELSE

Line 2727: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2723: IF p_Agreement_rec.invoicing_rule_id <> FND_API.G_MISS_NUM THEN
2724:
2725: l_Agreement_rec.invoicing_rule_id := p_Agreement_rec.invoicing_rule_id;
2726:
2727: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2728: THEN
2729:
2730: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');

Line 2732: OE_MSG_PUB.Add;

2728: THEN
2729:
2730: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
2732: OE_MSG_PUB.Add;
2733:
2734: END IF;
2735:
2736: ELSE

Line 2757: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2753: IF p_Agreement_rec.override_arule_flag <> FND_API.G_MISS_CHAR THEN
2754:
2755: l_Agreement_rec.override_arule_flag := p_Agreement_rec.override_arule_flag;
2756:
2757: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2758: THEN
2759:
2760: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2761: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_arule');

Line 2762: OE_MSG_PUB.Add;

2758: THEN
2759:
2760: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2761: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_arule');
2762: OE_MSG_PUB.Add;
2763:
2764: END IF;
2765:
2766: ELSE

Line 2787: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2783: IF p_Agreement_rec.override_irule_flag <> FND_API.G_MISS_CHAR THEN
2784:
2785: l_Agreement_rec.override_irule_flag := p_Agreement_rec.override_irule_flag;
2786:
2787: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2788: THEN
2789:
2790: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2791: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_irule');

Line 2792: OE_MSG_PUB.Add;

2788: THEN
2789:
2790: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2791: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override_irule');
2792: OE_MSG_PUB.Add;
2793:
2794: END IF;
2795:
2796: ELSE

Line 2817: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2813: IF p_Agreement_rec.price_list_id <> FND_API.G_MISS_NUM THEN
2814:
2815: l_Agreement_rec.price_list_id := p_Agreement_rec.price_list_id;
2816:
2817: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2818: THEN
2819:
2820: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2821: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');

Line 2822: OE_MSG_PUB.Add;

2818: THEN
2819:
2820: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2821: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
2822: OE_MSG_PUB.Add;
2823:
2824: END IF;
2825:
2826: ELSE

Line 2847: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2843: IF p_Agreement_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
2844:
2845: l_Agreement_rec.revision_reason_code := p_Agreement_rec.revision_reason_code;
2846:
2847: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2848: THEN
2849:
2850: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2851: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');

Line 2852: OE_MSG_PUB.Add;

2848: THEN
2849:
2850: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2851: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
2852: OE_MSG_PUB.Add;
2853:
2854: END IF;
2855:
2856: ELSE

Line 2877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2873: IF p_Agreement_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
2874:
2875: l_Agreement_rec.salesrep_id := p_Agreement_rec.salesrep_id;
2876:
2877: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2878: THEN
2879:
2880: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2881: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');

Line 2882: OE_MSG_PUB.Add;

2878: THEN
2879:
2880: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2881: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
2882: OE_MSG_PUB.Add;
2883:
2884: END IF;
2885:
2886: ELSE

Line 2907: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2903: IF p_Agreement_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
2904:
2905: l_Agreement_rec.ship_method_code := p_Agreement_rec.ship_method_code;
2906:
2907: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2908: THEN
2909:
2910: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2911: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');

Line 2912: OE_MSG_PUB.Add;

2908: THEN
2909:
2910: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2911: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');
2912: OE_MSG_PUB.Add;
2913:
2914: END IF;
2915:
2916: ELSE

Line 2937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2933: IF p_Agreement_rec.term_id <> FND_API.G_MISS_NUM THEN
2934:
2935: l_Agreement_rec.term_id := p_Agreement_rec.term_id;
2936:
2937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2938: THEN
2939:
2940: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2941: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','term');

Line 2942: OE_MSG_PUB.Add;

2938: THEN
2939:
2940: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2941: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','term');
2942: OE_MSG_PUB.Add;
2943:
2944: END IF;
2945:
2946: ELSE

Line 2968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2964: IF p_Agreement_rec.agreement_source_code <> FND_API.G_MISS_CHAR THEN
2965:
2966: l_Agreement_rec.agreement_source_code := p_Agreement_rec.agreement_source_code;
2967:
2968: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2969: THEN
2970:
2971: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2972: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_source');

Line 2973: OE_MSG_PUB.Add;

2969: THEN
2970:
2971: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2972: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement_source');
2973: OE_MSG_PUB.Add;
2974:
2975: END IF;
2976:
2977: ELSE