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.CTO_MATCH_CONFIG dependencies on CTO_MSG_PUB

Line 575: cto_msg_pub.count_and_get

571:
572: end loop;
573:
574: -- Get message count and data
575: cto_msg_pub.count_and_get
576: ( p_msg_count => xMsgCount
577: , p_msg_data => xMsgData
578: );
579:

Line 588: cto_msg_pub.count_and_get

584: oe_debug_pub.add('match_and_create_all_items: ' || 'Exception in stmt num: ' || to_char(lStmtNum), 1);
585: END IF;
586: xReturnStatus := FND_API.G_RET_STS_ERROR;
587: -- Get message count and data
588: cto_msg_pub.count_and_get
589: ( p_msg_count => xMsgCount
590: , p_msg_data => xMsgData
591: );
592: WHEN fnd_api.g_exc_unexpected_error THEN

Line 598: cto_msg_pub.count_and_get

594: oe_debug_pub.add('match_and_create_all_items: ' || ' Unexpected Exception in stmt num: ' || to_char(lStmtNum), 1);
595: END IF;
596: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR ;
597: -- Get message count and data
598: cto_msg_pub.count_and_get
599: ( p_msg_count => xMsgCount
600: , p_msg_data => xMsgData
601: );
602:

Line 610: cto_msg_pub.count_and_get

606: oe_debug_pub.add('match_and_create_all_items: ' || 'Others Exception in stmt num: ' || to_char(lStmtNum), 1);
607: END IF;
608: xReturnStatus := FND_API.G_RET_STS_UNEXP_ERROR;
609: -- Get message count and data
610: cto_msg_pub.count_and_get
611: ( p_msg_count => xMsgCount
612: , p_msg_data => xMsgData
613: );
614:

Line 929: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');

925:
926: x_error_message := 'CTO_MATCH_CONFIG.check_config_match' ||
927: 'Verify Parameters';
928: x_message_name := 'CTO_MATCH_ERROR';
929: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');
930: return 0;
931:
932:
933: when NO_DATA_FOUND then

Line 950: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');

946: x_error_message := 'CTO_MATCH_CONFIG.check_config_match' ||
947: to_char(l_stmt_num) || ':' ||
948: substrb(sqlerrm,1,150);
949: x_message_name := 'CTO_MATCH_ERROR';
950: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');
951: return 0;
952: END;
953:
954:

Line 1151: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');

1147: msg_name := 'CTO_MATCH_ERROR';
1148: -- IF PG_DEBUG <> 0 THEN
1149: oe_debug_pub.add('can_configurations: ' || error_msg, 1);
1150: -- END IF;
1151: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');
1152: return 0;
1153:
1154: when INSERT_ERROR then
1155: -- IF PG_DEBUG <> 0 THEN

Line 1164: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');

1160: msg_name := 'CTO_MATCH_ERROR';
1161: -- IF PG_DEBUG <> 0 THEN
1162: oe_debug_pub.add('can_configurations: ' || error_msg, 1);
1163: -- END IF;
1164: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');
1165: return 0;
1166:
1167: when OTHERS then
1168: oe_debug_pub.add('errmsg'||sqlerrm);

Line 1179: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');

1175: IF PG_DEBUG <> 0 THEN
1176: oe_debug_pub.add('can_configurations: ' || error_msg, 1);
1177: END IF;
1178: msg_name := 'CTO_MATCH_ERROR';
1179: cto_msg_pub.cto_message('BOM','CTO_MATCH_ERROR');
1180: return 0;
1181:
1182:
1183: END; /* end can_configurations */

Line 1293: cto_msg_pub.count_and_get

1289: || to_char(lStmtNum), 1);
1290: END IF;
1291: x_return_status := FND_API.G_RET_STS_ERROR;
1292: -- Get message count and data
1293: cto_msg_pub.count_and_get
1294: ( p_msg_count => x_msg_count
1295: , p_msg_data => x_msg_data
1296: );
1297: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1306: cto_msg_pub.count_and_get

1302: END IF;
1303:
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1305: -- Get message count and data
1306: cto_msg_pub.count_and_get
1307: ( p_msg_count => x_msg_count
1308: , p_msg_data => x_msg_data
1309: );
1310: WHEN OTHERS then

Line 1319: cto_msg_pub.count_and_get

1315: END IF;
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317: oe_debug_pub.add('error mse'||sqlerrm);
1318: -- Get message count and data
1319: cto_msg_pub.count_and_get
1320: ( p_msg_count => x_msg_count
1321: , p_msg_data => x_msg_data
1322: );
1323:

Line 1419: cto_msg_pub.count_and_get

1415: || to_char(lStmtNum), 1);
1416: END IF;
1417: x_return_status := FND_API.G_RET_STS_ERROR;
1418: -- Get message count and data
1419: cto_msg_pub.count_and_get
1420: ( p_msg_count => x_msg_count
1421: , p_msg_data => x_msg_data
1422: );
1423: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1430: cto_msg_pub.count_and_get

1426: to_char(lStmtNum), 1);
1427: END IF;
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1429: -- Get message count and data
1430: cto_msg_pub.count_and_get
1431: ( p_msg_count => x_msg_count
1432: , p_msg_data => x_msg_data
1433: );
1434: WHEN OTHERS then

Line 1443: cto_msg_pub.count_and_get

1439: END IF;
1440:
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: -- Get message count and data
1443: cto_msg_pub.count_and_get
1444: ( p_msg_count => x_msg_count
1445: , p_msg_data => x_msg_data
1446: );
1447:

Line 1742: cto_msg_pub.count_and_get

1738: oe_debug_pub.add('errmsg'||sqlerrm,5);
1739: END IF;
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: -- Get message count and data
1742: cto_msg_pub.count_and_get
1743: ( p_msg_count => x_msg_count
1744: , p_msg_data => x_msg_data
1745: );
1746:

Line 1871: cto_msg_pub.count_and_get

1867: oe_debug_pub.add('errmsg'||sqlerrm,5);
1868: END IF;
1869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1870: -- Get message count and data
1871: cto_msg_pub.count_and_get
1872: ( p_msg_count => x_msg_count
1873: , p_msg_data => x_msg_data
1874: );
1875:

Line 2004: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');

2000: --check for error cases
2001: if ( l_lock_status <> 0 ) THEN
2002: if (l_lock_status = 1) then -- timeout
2003: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');
2004: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
2005: raise fnd_api.g_exc_unexpected_error;
2006:
2007: elsif (l_lock_status = 2) then -- deadlock
2008: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');

Line 2009: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');

2005: raise fnd_api.g_exc_unexpected_error;
2006:
2007: elsif (l_lock_status = 2) then -- deadlock
2008: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
2009: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
2010: raise fnd_api.g_exc_unexpected_error;
2011:
2012: elsif (l_lock_status = 3) then -- parameter error
2013: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');

Line 2014: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');

2010: raise fnd_api.g_exc_unexpected_error;
2011:
2012: elsif (l_lock_status = 3) then -- parameter error
2013: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
2014: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
2015: raise fnd_api.g_exc_unexpected_error;
2016:
2017: elsif (l_lock_status = 4) then -- already locked.
2018: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');

Line 2019: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');

2015: raise fnd_api.g_exc_unexpected_error;
2016:
2017: elsif (l_lock_status = 4) then -- already locked.
2018: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');
2019: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');
2020: -- we shall not raise an error if we are already holding the lock.
2021:
2022: else -- internal error - not fault of user
2023: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');

Line 2024: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');

2020: -- we shall not raise an error if we are already holding the lock.
2021:
2022: else -- internal error - not fault of user
2023: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');
2024: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');
2025: raise fnd_api.g_exc_unexpected_error;
2026: end if;
2027: else
2028: IF PG_DEBUG <> 0 THEN

Line 2185: cto_msg_pub.count_and_get

2181: || to_char(lStmtNum), 1);
2182: END IF;
2183: x_return_status := FND_API.G_RET_STS_ERROR;
2184: -- Get message count and data
2185: cto_msg_pub.count_and_get
2186: ( p_msg_count => x_msg_count
2187: , p_msg_data => x_msg_data
2188: );
2189: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2196: cto_msg_pub.count_and_get

2192: || to_char(lStmtNum), 1);
2193: END IF;
2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2195: -- Get message count and data
2196: cto_msg_pub.count_and_get
2197: ( p_msg_count => x_msg_count
2198: , p_msg_data => x_msg_data
2199: );
2200: WHEN OTHERS then

Line 2209: cto_msg_pub.count_and_get

2205: oe_debug_pub.add('errmsg'||sqlerrm,1);
2206: END IF;
2207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2208: -- Get message count and data
2209: cto_msg_pub.count_and_get
2210: ( p_msg_count => x_msg_count
2211: , p_msg_data => x_msg_data
2212: );
2213:

Line 2263: cto_msg_pub.count_and_get

2259: || to_char(lStmtNum), 1);
2260: END IF;
2261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2262: /*-- Get message count and data
2263: cto_msg_pub.count_and_get
2264: ( p_msg_count => x_msg_count
2265: , p_msg_data => x_msg_data
2266: );*/
2267:

Line 2767: cto_msg_pub.count_and_get

2763: || to_char(lStmtNum), 1);
2764: END IF;
2765: x_return_status := FND_API.G_RET_STS_ERROR;
2766: -- Get message count and data
2767: cto_msg_pub.count_and_get
2768: ( p_msg_count => x_msg_count
2769: , p_msg_data => x_msg_data
2770: );
2771: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2778: cto_msg_pub.count_and_get

2774: || to_char(lStmtNum), 1);
2775: END IF;
2776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2777: -- Get message count and data
2778: cto_msg_pub.count_and_get
2779: ( p_msg_count => x_msg_count
2780: , p_msg_data => x_msg_data
2781: );
2782: WHEN OTHERS then

Line 2792: cto_msg_pub.count_and_get

2788: oe_debug_pub.add('errmsg =>'||sqlerrm,1);
2789: END IF;
2790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2791: -- Get message count and data
2792: cto_msg_pub.count_and_get
2793: ( p_msg_count => x_msg_count
2794: , p_msg_data => x_msg_data
2795: );
2796:

Line 2972: cto_msg_pub.count_and_get

2968: || to_char(lStmtNum), 1);
2969: END IF;
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: -- Get message count and data
2972: cto_msg_pub.count_and_get
2973: ( p_msg_count => x_msg_count
2974: , p_msg_data => x_msg_data
2975: );
2976: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2983: cto_msg_pub.count_and_get

2979: || to_char(lStmtNum), 1);
2980: END IF;
2981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2982: -- Get message count and data
2983: cto_msg_pub.count_and_get
2984: ( p_msg_count => x_msg_count
2985: , p_msg_data => x_msg_data
2986: );
2987: WHEN OTHERS then

Line 2995: cto_msg_pub.count_and_get

2991: to_char(lStmtNum), 1);
2992: END IF;
2993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2994: -- Get message count and data
2995: cto_msg_pub.count_and_get
2996: ( p_msg_count => x_msg_count
2997: , p_msg_data => x_msg_data
2998: );
2999:

Line 3110: cto_msg_pub.count_and_get

3106: || to_char(lStmtNum), 1);
3107: END IF;
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: -- Get message count and data
3110: cto_msg_pub.count_and_get
3111: ( p_msg_count => x_msg_count
3112: , p_msg_data => x_msg_data
3113: );
3114: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3121: cto_msg_pub.count_and_get

3117: || to_char(lStmtNum), 1);
3118: END IF;
3119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3120: -- Get message count and data
3121: cto_msg_pub.count_and_get
3122: ( p_msg_count => x_msg_count
3123: , p_msg_data => x_msg_data
3124: );
3125: WHEN OTHERS then

Line 3134: cto_msg_pub.count_and_get

3130: || to_char(lStmtNum), 1);
3131: END IF;
3132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3133: -- Get message count and data
3134: cto_msg_pub.count_and_get
3135: ( p_msg_count => x_msg_count
3136: , p_msg_data => x_msg_data
3137: );
3138:

Line 3327: cto_msg_pub.count_and_get

3323: || to_char(lStmtNum), 1);
3324: END IF;
3325: x_return_status := FND_API.G_RET_STS_ERROR;
3326: -- Get message count and data
3327: cto_msg_pub.count_and_get
3328: ( p_msg_count => x_msg_count
3329: , p_msg_data => x_msg_data
3330: );
3331: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3338: cto_msg_pub.count_and_get

3334: || to_char(lStmtNum), 1);
3335: END IF;
3336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3337: -- Get message count and data
3338: cto_msg_pub.count_and_get
3339: ( p_msg_count => x_msg_count
3340: , p_msg_data => x_msg_data
3341: );
3342: WHEN OTHERS then

Line 3351: cto_msg_pub.count_and_get

3347: || to_char(lStmtNum), 1);
3348: END IF;
3349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3350: -- Get message count and data
3351: cto_msg_pub.count_and_get
3352: ( p_msg_count => x_msg_count
3353: , p_msg_data => x_msg_data
3354: );
3355: END Evaluate_N_Pop_Match_Flag;

Line 3404: cto_msg_pub.count_and_get

3400: || to_char(lStmtNum), 1);
3401: END IF;
3402: x_return_status := FND_API.G_RET_STS_ERROR;
3403: -- Get message count and data
3404: cto_msg_pub.count_and_get
3405: ( p_msg_count => x_msg_count
3406: , p_msg_data => x_msg_data
3407: );
3408: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3415: cto_msg_pub.count_and_get

3411: || to_char(lStmtNum), 1);
3412: END IF;
3413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3414: -- Get message count and data
3415: cto_msg_pub.count_and_get
3416: ( p_msg_count => x_msg_count
3417: , p_msg_data => x_msg_data
3418: );
3419: WHEN OTHERS then

Line 3428: cto_msg_pub.count_and_get

3424: || to_char(lStmtNum), 1);
3425: END IF;
3426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3427: -- Get message count and data
3428: cto_msg_pub.count_and_get
3429: ( p_msg_count => x_msg_count
3430: , p_msg_data => x_msg_data
3431: );
3432:

Line 3585: cto_msg_pub.count_and_get

3581: || to_char(lStmtNum), 1);
3582: END IF;
3583: x_return_status := FND_API.G_RET_STS_ERROR;
3584: -- Get message count and data
3585: cto_msg_pub.count_and_get
3586: ( p_msg_count => x_msg_count
3587: , p_msg_data => x_msg_data
3588: );
3589: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3596: cto_msg_pub.count_and_get

3592: || to_char(lStmtNum), 1);
3593: END IF;
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3595: -- Get message count and data
3596: cto_msg_pub.count_and_get
3597: ( p_msg_count => x_msg_count
3598: , p_msg_data => x_msg_data
3599: );
3600: WHEN OTHERS then

Line 3610: cto_msg_pub.count_and_get

3606: oe_debug_pub.add('error '||sqlerrm,1);
3607: END IF;
3608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3609: -- Get message count and data
3610: cto_msg_pub.count_and_get
3611: ( p_msg_count => x_msg_count
3612: , p_msg_data => x_msg_data
3613: );
3614: