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 2039: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');

2035: --check for error cases
2036: if ( l_lock_status <> 0 ) THEN
2037: if (l_lock_status = 1) then -- timeout
2038: oe_debug_pub.add('l_lock_status = 1: TIMEOUT ');
2039: cto_msg_pub.cto_message('BOM','CTO_LOCK_TIMEOUT');
2040: raise fnd_api.g_exc_unexpected_error;
2041:
2042: elsif (l_lock_status = 2) then -- deadlock
2043: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');

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

2040: raise fnd_api.g_exc_unexpected_error;
2041:
2042: elsif (l_lock_status = 2) then -- deadlock
2043: oe_debug_pub.add('l_lock_status = 2: DEADLOCK ');
2044: cto_msg_pub.cto_message('BOM','CTO_LOCK_DEADLOCK');
2045: raise fnd_api.g_exc_unexpected_error;
2046:
2047: elsif (l_lock_status = 3) then -- parameter error
2048: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');

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

2045: raise fnd_api.g_exc_unexpected_error;
2046:
2047: elsif (l_lock_status = 3) then -- parameter error
2048: oe_debug_pub.add('l_lock_status = 3: PARAMETER ERROR ');
2049: cto_msg_pub.cto_message('BOM','CTO_LOCK_PARAM_ERROR');
2050: raise fnd_api.g_exc_unexpected_error;
2051:
2052: elsif (l_lock_status = 4) then -- already locked.
2053: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');

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

2050: raise fnd_api.g_exc_unexpected_error;
2051:
2052: elsif (l_lock_status = 4) then -- already locked.
2053: oe_debug_pub.add('l_lock_status = 4: ALREADY LOCKED ERROR ');
2054: cto_msg_pub.cto_message('BOM','CTO_LOCK_ALREADY_LOCKED');
2055: -- we shall not raise an error if we are already holding the lock.
2056:
2057: else -- internal error - not fault of user
2058: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');

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

2055: -- we shall not raise an error if we are already holding the lock.
2056:
2057: else -- internal error - not fault of user
2058: oe_debug_pub.add('l_lock_status = '||l_lock_status||': INTERNAL ERROR ');
2059: cto_msg_pub.cto_message('BOM','CTO_LOCK_ERROR');
2060: raise fnd_api.g_exc_unexpected_error;
2061: end if;
2062: else
2063: IF PG_DEBUG <> 0 THEN

Line 2220: cto_msg_pub.count_and_get

2216: || to_char(lStmtNum), 1);
2217: END IF;
2218: x_return_status := FND_API.G_RET_STS_ERROR;
2219: -- Get message count and data
2220: cto_msg_pub.count_and_get
2221: ( p_msg_count => x_msg_count
2222: , p_msg_data => x_msg_data
2223: );
2224: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2231: cto_msg_pub.count_and_get

2227: || to_char(lStmtNum), 1);
2228: END IF;
2229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2230: -- Get message count and data
2231: cto_msg_pub.count_and_get
2232: ( p_msg_count => x_msg_count
2233: , p_msg_data => x_msg_data
2234: );
2235: WHEN OTHERS then

Line 2244: cto_msg_pub.count_and_get

2240: oe_debug_pub.add('errmsg'||sqlerrm,1);
2241: END IF;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: -- Get message count and data
2244: cto_msg_pub.count_and_get
2245: ( p_msg_count => x_msg_count
2246: , p_msg_data => x_msg_data
2247: );
2248:

Line 2298: cto_msg_pub.count_and_get

2294: || to_char(lStmtNum), 1);
2295: END IF;
2296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2297: /*-- Get message count and data
2298: cto_msg_pub.count_and_get
2299: ( p_msg_count => x_msg_count
2300: , p_msg_data => x_msg_data
2301: );*/
2302:

Line 2802: cto_msg_pub.count_and_get

2798: || to_char(lStmtNum), 1);
2799: END IF;
2800: x_return_status := FND_API.G_RET_STS_ERROR;
2801: -- Get message count and data
2802: cto_msg_pub.count_and_get
2803: ( p_msg_count => x_msg_count
2804: , p_msg_data => x_msg_data
2805: );
2806: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2813: cto_msg_pub.count_and_get

2809: || to_char(lStmtNum), 1);
2810: END IF;
2811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2812: -- Get message count and data
2813: cto_msg_pub.count_and_get
2814: ( p_msg_count => x_msg_count
2815: , p_msg_data => x_msg_data
2816: );
2817: WHEN OTHERS then

Line 2827: cto_msg_pub.count_and_get

2823: oe_debug_pub.add('errmsg =>'||sqlerrm,1);
2824: END IF;
2825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2826: -- Get message count and data
2827: cto_msg_pub.count_and_get
2828: ( p_msg_count => x_msg_count
2829: , p_msg_data => x_msg_data
2830: );
2831:

Line 3007: cto_msg_pub.count_and_get

3003: || to_char(lStmtNum), 1);
3004: END IF;
3005: x_return_status := FND_API.G_RET_STS_ERROR;
3006: -- Get message count and data
3007: cto_msg_pub.count_and_get
3008: ( p_msg_count => x_msg_count
3009: , p_msg_data => x_msg_data
3010: );
3011: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3018: cto_msg_pub.count_and_get

3014: || to_char(lStmtNum), 1);
3015: END IF;
3016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3017: -- Get message count and data
3018: cto_msg_pub.count_and_get
3019: ( p_msg_count => x_msg_count
3020: , p_msg_data => x_msg_data
3021: );
3022: WHEN OTHERS then

Line 3030: cto_msg_pub.count_and_get

3026: to_char(lStmtNum), 1);
3027: END IF;
3028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3029: -- Get message count and data
3030: cto_msg_pub.count_and_get
3031: ( p_msg_count => x_msg_count
3032: , p_msg_data => x_msg_data
3033: );
3034:

Line 3145: cto_msg_pub.count_and_get

3141: || to_char(lStmtNum), 1);
3142: END IF;
3143: x_return_status := FND_API.G_RET_STS_ERROR;
3144: -- Get message count and data
3145: cto_msg_pub.count_and_get
3146: ( p_msg_count => x_msg_count
3147: , p_msg_data => x_msg_data
3148: );
3149: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3156: cto_msg_pub.count_and_get

3152: || to_char(lStmtNum), 1);
3153: END IF;
3154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3155: -- Get message count and data
3156: cto_msg_pub.count_and_get
3157: ( p_msg_count => x_msg_count
3158: , p_msg_data => x_msg_data
3159: );
3160: WHEN OTHERS then

Line 3169: cto_msg_pub.count_and_get

3165: || to_char(lStmtNum), 1);
3166: END IF;
3167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3168: -- Get message count and data
3169: cto_msg_pub.count_and_get
3170: ( p_msg_count => x_msg_count
3171: , p_msg_data => x_msg_data
3172: );
3173:

Line 3362: cto_msg_pub.count_and_get

3358: || to_char(lStmtNum), 1);
3359: END IF;
3360: x_return_status := FND_API.G_RET_STS_ERROR;
3361: -- Get message count and data
3362: cto_msg_pub.count_and_get
3363: ( p_msg_count => x_msg_count
3364: , p_msg_data => x_msg_data
3365: );
3366: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3373: cto_msg_pub.count_and_get

3369: || to_char(lStmtNum), 1);
3370: END IF;
3371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3372: -- Get message count and data
3373: cto_msg_pub.count_and_get
3374: ( p_msg_count => x_msg_count
3375: , p_msg_data => x_msg_data
3376: );
3377: WHEN OTHERS then

Line 3386: cto_msg_pub.count_and_get

3382: || to_char(lStmtNum), 1);
3383: END IF;
3384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3385: -- Get message count and data
3386: cto_msg_pub.count_and_get
3387: ( p_msg_count => x_msg_count
3388: , p_msg_data => x_msg_data
3389: );
3390: END Evaluate_N_Pop_Match_Flag;

Line 3439: cto_msg_pub.count_and_get

3435: || to_char(lStmtNum), 1);
3436: END IF;
3437: x_return_status := FND_API.G_RET_STS_ERROR;
3438: -- Get message count and data
3439: cto_msg_pub.count_and_get
3440: ( p_msg_count => x_msg_count
3441: , p_msg_data => x_msg_data
3442: );
3443: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3450: cto_msg_pub.count_and_get

3446: || to_char(lStmtNum), 1);
3447: END IF;
3448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3449: -- Get message count and data
3450: cto_msg_pub.count_and_get
3451: ( p_msg_count => x_msg_count
3452: , p_msg_data => x_msg_data
3453: );
3454: WHEN OTHERS then

Line 3463: cto_msg_pub.count_and_get

3459: || to_char(lStmtNum), 1);
3460: END IF;
3461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3462: -- Get message count and data
3463: cto_msg_pub.count_and_get
3464: ( p_msg_count => x_msg_count
3465: , p_msg_data => x_msg_data
3466: );
3467:

Line 3620: cto_msg_pub.count_and_get

3616: || to_char(lStmtNum), 1);
3617: END IF;
3618: x_return_status := FND_API.G_RET_STS_ERROR;
3619: -- Get message count and data
3620: cto_msg_pub.count_and_get
3621: ( p_msg_count => x_msg_count
3622: , p_msg_data => x_msg_data
3623: );
3624: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3631: cto_msg_pub.count_and_get

3627: || to_char(lStmtNum), 1);
3628: END IF;
3629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3630: -- Get message count and data
3631: cto_msg_pub.count_and_get
3632: ( p_msg_count => x_msg_count
3633: , p_msg_data => x_msg_data
3634: );
3635: WHEN OTHERS then

Line 3645: cto_msg_pub.count_and_get

3641: oe_debug_pub.add('error '||sqlerrm,1);
3642: END IF;
3643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3644: -- Get message count and data
3645: cto_msg_pub.count_and_get
3646: ( p_msg_count => x_msg_count
3647: , p_msg_data => x_msg_data
3648: );
3649: