DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_PUB dependencies on FND_MSG_PUB

Line 289: FND_MSG_PUB.initialize;

285: END IF;
286:
287: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
288: pa_debug.debug('Performing ID validations and conversions');
289: FND_MSG_PUB.initialize;
290: END IF;
291:
292: --BEGIN VALIDATIONS
293:

Line 393: l_msg_count := FND_MSG_PUB.count_msg;

389: l_task_manager_id := p_task_manager_person_id;
390: END IF;
391:
392: --Check if there is any error
393: l_msg_count := FND_MSG_PUB.count_msg;
394: if l_msg_count > 0 then
395: x_msg_count := l_msg_count;
396: if x_msg_count = 1 then
397: pa_interface_utils_pub.get_messages

Line 544: x_msg_count := FND_MSG_PUB.count_msg;

540: --dbms_output.put_line( 'After exis creat task pvt api call in pub api' );
541:
542: --Check return status
543: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
544: x_msg_count := FND_MSG_PUB.count_msg;
545: if x_msg_count = 1 then
546: pa_interface_utils_pub.get_messages
547: (p_encoded => FND_API.G_TRUE,
548: p_msg_index => 1,

Line 609: x_msg_count := FND_MSG_PUB.count_msg;

605: WHEN FND_API.G_EXC_ERROR THEN
606: IF (p_commit = FND_API.G_TRUE) THEN
607: ROLLBACK to CREATE_TASK;
608: END IF;
609: x_msg_count := FND_MSG_PUB.count_msg;
610: x_return_status := FND_API.G_RET_STS_ERROR;
611: WHEN OTHERS THEN
612: IF (p_commit = FND_API.G_TRUE) THEN
613: ROLLBACK to CREATE_TASK;

Line 615: x_msg_count := FND_MSG_PUB.count_msg;

611: WHEN OTHERS THEN
612: IF (p_commit = FND_API.G_TRUE) THEN
613: ROLLBACK to CREATE_TASK;
614: END IF;
615: x_msg_count := FND_MSG_PUB.count_msg;
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
618: p_procedure_name => 'CREATE_TASK',
619: p_error_text => substrb(SQLERRM,1,240));

Line 617: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',

613: ROLLBACK to CREATE_TASK;
614: END IF;
615: x_msg_count := FND_MSG_PUB.count_msg;
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
618: p_procedure_name => 'CREATE_TASK',
619: p_error_text => substrb(SQLERRM,1,240));
620: RAISE;
621: END CREATE_TASK;

Line 945: FND_MSG_PUB.initialize;

941: END IF;
942:
943: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
944: pa_debug.debug('Performing ID validations and conversions');
945: FND_MSG_PUB.initialize;
946: END IF;
947:
948: --BEGIN VALIDATIONS
949: IF (p_calling_module = 'SELF_SERVICE') OR (p_calling_module = 'EXCHANGE') THEN

Line 1004: l_msg_count := FND_MSG_PUB.count_msg;

1000: l_task_manager_id := p_task_manager_person_id;
1001: END IF;
1002:
1003: --Check if there is any error
1004: l_msg_count := FND_MSG_PUB.count_msg;
1005: if l_msg_count > 0 then
1006: x_msg_count := l_msg_count;
1007: if x_msg_count = 1 then
1008: pa_interface_utils_pub.get_messages

Line 1153: x_msg_count := FND_MSG_PUB.count_msg;

1149: );
1150:
1151: --Check return status
1152: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1153: x_msg_count := FND_MSG_PUB.count_msg;
1154: if x_msg_count = 1 then
1155: pa_interface_utils_pub.get_messages
1156: (p_encoded => FND_API.G_TRUE,
1157: p_msg_index => 1,

Line 1238: x_msg_count := FND_MSG_PUB.count_msg;

1234: WHEN FND_API.G_EXC_ERROR THEN
1235: IF (p_commit = FND_API.G_TRUE) THEN
1236: ROLLBACK to UPDATE_TASK;
1237: END IF;
1238: x_msg_count := FND_MSG_PUB.count_msg;
1239: x_return_status := FND_API.G_RET_STS_ERROR;
1240: WHEN OTHERS THEN
1241: IF (p_commit = FND_API.G_TRUE) THEN
1242: ROLLBACK to UPDATE_TASK;

Line 1244: x_msg_count := FND_MSG_PUB.count_msg;

1240: WHEN OTHERS THEN
1241: IF (p_commit = FND_API.G_TRUE) THEN
1242: ROLLBACK to UPDATE_TASK;
1243: END IF;
1244: x_msg_count := FND_MSG_PUB.count_msg;
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: --put message
1247: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1248: p_procedure_name => 'UPDATE_TASK',

Line 1247: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1243: END IF;
1244: x_msg_count := FND_MSG_PUB.count_msg;
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: --put message
1247: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1248: p_procedure_name => 'UPDATE_TASK',
1249: p_error_text => substrb(SQLERRM,1,240));
1250: -- RAISE;
1251: END UPDATE_TASK;

Line 1353: FND_MSG_PUB.initialize;

1349: END IF;
1350:
1351: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
1352: pa_debug.debug('Performing ID validations and conversions');
1353: FND_MSG_PUB.initialize;
1354: END IF;
1355:
1356: --Check if there is any error
1357: l_msg_count := FND_MSG_PUB.count_msg;

Line 1357: l_msg_count := FND_MSG_PUB.count_msg;

1353: FND_MSG_PUB.initialize;
1354: END IF;
1355:
1356: --Check if there is any error
1357: l_msg_count := FND_MSG_PUB.count_msg;
1358: if l_msg_count > 0 then
1359: x_msg_count := l_msg_count;
1360: if x_msg_count = 1 then
1361: pa_interface_utils_pub.get_messages

Line 1415: x_msg_count := FND_MSG_PUB.count_msg;

1411: );
1412:
1413: --Check return status
1414: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1415: x_msg_count := FND_MSG_PUB.count_msg;
1416: if x_msg_count = 1 then
1417: pa_interface_utils_pub.get_messages
1418: (p_encoded => FND_API.G_TRUE,
1419: p_msg_index => 1,

Line 1469: x_msg_count := FND_MSG_PUB.count_msg;

1465: WHEN FND_API.G_EXC_ERROR THEN
1466: IF (p_commit = FND_API.G_TRUE) THEN
1467: ROLLBACK to DELETE_TASK;
1468: END IF;
1469: x_msg_count := FND_MSG_PUB.count_msg;
1470: x_return_status := FND_API.G_RET_STS_ERROR;
1471: WHEN OTHERS THEN
1472: IF (p_commit = FND_API.G_TRUE) THEN
1473: ROLLBACK to DELETE_TASK;

Line 1475: x_msg_count := FND_MSG_PUB.count_msg;

1471: WHEN OTHERS THEN
1472: IF (p_commit = FND_API.G_TRUE) THEN
1473: ROLLBACK to DELETE_TASK;
1474: END IF;
1475: x_msg_count := FND_MSG_PUB.count_msg;
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1477: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1478: p_procedure_name => 'DELETE_TASK',
1479: p_error_text => substrb(SQLERRM,1,240));

Line 1477: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1473: ROLLBACK to DELETE_TASK;
1474: END IF;
1475: x_msg_count := FND_MSG_PUB.count_msg;
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1477: FND_MSG_PUB.ADD_EXC_MSG(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1478: p_procedure_name => 'DELETE_TASK',
1479: p_error_text => substrb(SQLERRM,1,240));
1480: END DELETE_TASK;
1481:

Line 1576: fnd_msg_pub.initialize;

1572:
1573: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.Edit_Task_Structure');
1574:
1575: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1576: fnd_msg_pub.initialize;
1577: end if;
1578:
1579: /*IF (p_calling_module = 'SELF_SERVICE') OR (p_calling_module = 'EXCHANGE') THEN
1580:

Line 1651: l_msg_count := FND_MSG_PUB.count_msg;

1647: p_wbs_record_version_number => p_wbs_record_version_number,
1648: x_return_status => x_return_status,
1649: x_msg_data => x_msg_data ); */
1650:
1651: l_msg_count := FND_MSG_PUB.count_msg;
1652:
1653: If l_msg_count > 0 THEN
1654: x_msg_count := l_msg_count;
1655: If l_msg_count = 1 THEN

Line 1687: l_msg_count := FND_MSG_PUB.count_msg;

1683: ,x_return_status => x_return_status
1684: ,x_msg_count => x_msg_count
1685: ,x_msg_data => x_msg_data );
1686:
1687: l_msg_count := FND_MSG_PUB.count_msg;
1688:
1689: --dbms_output.put_line( 'Edit Task structure. '||'After Indent Task '||'Count '|| l_msg_count );
1690:
1691: ELSIF p_edit_mode = 'OUTDENT'

Line 1717: l_msg_count := FND_MSG_PUB.count_msg;

1713:
1714: if (p_debug_mode = 'Y') then
1715: pa_debug.debug('Edit Task Structure PUB : checking message count');
1716: end if;
1717: l_msg_count := FND_MSG_PUB.count_msg;
1718:
1719: If l_msg_count > 0 THEN
1720: x_msg_count := l_msg_count;
1721: If l_msg_count = 1 THEN

Line 1752: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1748: THEN
1749: ROLLBACK TO Edit_Structure;
1750: END IF;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1753: p_procedure_name => 'Edit_Task_Structure',
1754: p_error_text => SUBSTRB(SQLERRM,1,240));
1755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1756:

Line 1770: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

1766: THEN
1767: ROLLBACK TO Edit_Structure;
1768: END IF;
1769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1770: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
1771: p_procedure_name => 'Edit_Task_Structure',
1772: p_error_text => SUBSTRB(SQLERRM,1,240));
1773: RAISE;
1774:

Line 1874: fnd_msg_pub.initialize;

1870: pa_debug.debug('Move Task PUB : Initializing message stack.');
1871: end if;
1872: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.MOVE_TASK');
1873: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1874: fnd_msg_pub.initialize;
1875: end if;
1876:
1877: --dbms_output.put_line( 'Before name to id conv. ' );
1878: --commenting after discussing with Hubert and Sakthi.

Line 1986: l_msg_count := FND_MSG_PUB.count_msg;

1982: x_msg_data => x_msg_data ); */
1983:
1984: --dbms_output.put_line( 'After locking 1 ' );
1985:
1986: l_msg_count := FND_MSG_PUB.count_msg;
1987: IF l_msg_count > 0 THEN
1988: x_msg_count := l_msg_count;
1989: x_msg_data := x_msg_data;
1990: --dbms_output.put_line( 'x_msg_data '||x_msg_data );

Line 2001: l_msg_count := FND_MSG_PUB.count_msg;

1997: if (p_debug_mode = 'Y') then
1998: pa_debug.debug('Move Task PUB : checking message count');
1999: end if;
2000:
2001: l_msg_count := FND_MSG_PUB.count_msg;
2002:
2003: --dbms_output.put_line( 'After locking 3 ' );
2004:
2005: If l_msg_count > 0 THEN

Line 2042: l_msg_count := FND_MSG_PUB.count_msg;

2038:
2039: if (p_debug_mode = 'Y') then
2040: pa_debug.debug('Move Task PUB : checking message count');
2041: end if;
2042: l_msg_count := FND_MSG_PUB.count_msg;
2043:
2044:
2045: If l_msg_count > 0 THEN
2046: x_msg_count := l_msg_count;

Line 2081: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

2077: THEN
2078: ROLLBACK TO Move;
2079: END IF;
2080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2081: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2082: p_procedure_name => 'Move_Task',
2083: p_error_text => SUBSTRB(SQLERRM,1,240));
2084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2085:

Line 2099: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

2095: THEN
2096: ROLLBACK TO Move;
2097: END IF;
2098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2099: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2100: p_procedure_name => 'Move_Task',
2101: p_error_text => SUBSTRB(SQLERRM,1,240));
2102: RAISE;
2103:

Line 2207: fnd_msg_pub.initialize;

2203: pa_debug.debug('Copy Task PUB : Initializing message stack.');
2204: end if;
2205: pa_debug.init_err_stack('PA_TASK_MAINT_PUB.COPY_TASK');
2206: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
2207: fnd_msg_pub.initialize;
2208: end if;
2209:
2210: IF (p_calling_module = 'SELF_SERVICE') OR (p_calling_module = 'EXCHANGE') THEN
2211:

Line 2325: l_msg_count := FND_MSG_PUB.count_msg;

2321: x_return_status => x_return_status,
2322: x_msg_data => x_msg_data ); */
2323:
2324:
2325: l_msg_count := FND_MSG_PUB.count_msg;
2326: IF l_msg_count > 0 THEN
2327: x_msg_count := l_msg_count;
2328: x_return_status := 'E';
2329: RAISE FND_API.G_EXC_ERROR;

Line 2388: l_msg_count := FND_MSG_PUB.count_msg;

2384:
2385: if (p_debug_mode = 'Y') then
2386: pa_debug.debug('Edit Task Structure PUB : checking message count');
2387: end if;
2388: l_msg_count := FND_MSG_PUB.count_msg;
2389:
2390:
2391: If l_msg_count > 0 THEN
2392: x_msg_count := l_msg_count;

Line 2425: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

2421: THEN
2422: ROLLBACK TO Copy;
2423: END IF;
2424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2425: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2426: p_procedure_name => 'Copy_Task',
2427: p_error_text => SUBSTRB(SQLERRM,1,240));
2428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2429:

Line 2443: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',

2439: THEN
2440: ROLLBACK TO Copy;
2441: END IF;
2442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2443: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASKS_MAINT_PUB',
2444: p_procedure_name => 'Copy_Task',
2445: p_error_text => SUBSTRB(SQLERRM,1,240));
2446: RAISE;
2447:

Line 2696: FND_MSG_PUB.initialize;

2692: l_debug_level3);
2693: END IF;
2694:
2695: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
2696: FND_MSG_PUB.initialize;
2697: END IF;
2698:
2699: IF (p_commit = FND_API.G_TRUE) THEN
2700: savepoint SET_FIN_FLAG_WRAPPER_PUBLIC;

Line 2990: l_msg_count := Fnd_Msg_Pub.count_msg;

2986:
2987: WHEN FND_API.G_EXC_ERROR THEN
2988:
2989: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2990: l_msg_count := Fnd_Msg_Pub.count_msg;
2991:
2992: IF p_commit = FND_API.G_TRUE THEN
2993: ROLLBACK TO SET_FIN_FLAG_WRAPPER_PUBLIC;
2994: END IF;

Line 3052: Fnd_Msg_Pub.add_exc_msg

3048: END IF;
3049: IF c_get_pa_record_version_number%ISOPEN THEN
3050: CLOSE c_get_pa_record_version_number;
3051: END IF;
3052: Fnd_Msg_Pub.add_exc_msg
3053: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3054: , p_procedure_name => 'SET_FINANCIAL_FLAG_WRAPPER'
3055: , p_error_text => x_msg_data);
3056:

Line 3089: Fnd_Msg_Pub.add_exc_msg

3085: IF c_get_pa_record_version_number%ISOPEN THEN
3086: CLOSE c_get_pa_record_version_number;
3087: END IF;
3088:
3089: Fnd_Msg_Pub.add_exc_msg
3090: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3091: , p_procedure_name => 'SET_FINANCIAL_FLAG_WRAPPER'
3092: , p_error_text => x_msg_data);
3093:

Line 3296: FND_MSG_PUB.initialize;

3292: l_proj_element_id_tbl.DELETE;
3293: l_fin_task_flag_tbl.DELETE;
3294:
3295: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3296: FND_MSG_PUB.initialize;
3297: END IF;
3298:
3299: IF (p_commit = FND_API.G_TRUE) THEN
3300: savepoint POPULATE_TEMP_TBL_PUB;

Line 3425: l_msg_count := Fnd_Msg_Pub.count_msg;

3421: EXCEPTION
3422: WHEN FND_API.G_EXC_ERROR THEN
3423:
3424: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3425: l_msg_count := Fnd_Msg_Pub.count_msg;
3426:
3427: IF p_commit = FND_API.G_TRUE THEN
3428: ROLLBACK TO POPULATE_TEMP_TABLE_PUB;
3429: END IF;

Line 3474: Fnd_Msg_Pub.add_exc_msg

3470:
3471: IF c_get_parents%ISOPEN THEN
3472: CLOSE c_get_parents;
3473: END IF;
3474: Fnd_Msg_Pub.add_exc_msg
3475: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3476: , p_procedure_name => 'POPULATE_TEMP_TABLE'
3477: , p_error_text => x_msg_data);
3478:

Line 3504: Fnd_Msg_Pub.add_exc_msg

3500: IF c_get_parents%ISOPEN THEN
3501: CLOSE c_get_parents;
3502: END IF;
3503:
3504: Fnd_Msg_Pub.add_exc_msg
3505: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3506: , p_procedure_name => 'POPULATE_TEMP_TABLE'
3507: , p_error_text => x_msg_data);
3508:

Line 3617: FND_MSG_PUB.initialize;

3613: l_debug_level3);
3614: END IF;
3615:
3616: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_TRUE)) THEN
3617: FND_MSG_PUB.initialize;
3618: END IF;
3619:
3620: IF (p_commit = FND_API.G_TRUE) THEN
3621: savepoint SYNC_UP_WITH_FIN_PUBLIC;

Line 3715: l_msg_count := Fnd_Msg_Pub.count_msg;

3711:
3712: WHEN FND_API.G_EXC_ERROR THEN
3713:
3714: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3715: l_msg_count := Fnd_Msg_Pub.count_msg;
3716:
3717: IF p_commit = FND_API.G_TRUE THEN
3718: ROLLBACK TO SYNC_UP_WITH_FIN_PUBLIC;
3719: END IF;

Line 3751: Fnd_Msg_Pub.add_exc_msg

3747: ROLLBACK TO SYNC_UP_WITH_FIN_PUBLIC;
3748: END IF;
3749:
3750:
3751: Fnd_Msg_Pub.add_exc_msg
3752: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3753: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
3754: , p_error_text => x_msg_data);
3755: IF l_debug_mode = 'Y' THEN

Line 3776: Fnd_Msg_Pub.add_exc_msg

3772: END IF;
3773:
3774:
3775:
3776: Fnd_Msg_Pub.add_exc_msg
3777: ( p_pkg_name => 'PA_TASKS_MAINT_PUB'
3778: , p_procedure_name => 'SYNC_UP_WP_TASKS_WITH_FIN'
3779: , p_error_text => x_msg_data);
3780: