APPS.PSB_HR_POPULATE_DATA_PVT dependencies on HR_UTILITY

Line 373: --hr_utility.trace_on;

369: l_creation_date := SYSDATE;
370: l_created_by := FND_GLOBAL.USER_ID;
371: /* Bug 4222417 End */
372:
373: --hr_utility.trace_on;
374: hr_utility.set_location(' Inside Salary Assignment',333);
375:
376: For C_flex_rec in C_flex_num
377: Loop

Line 374: hr_utility.set_location(' Inside Salary Assignment',333);

370: l_created_by := FND_GLOBAL.USER_ID;
371: /* Bug 4222417 End */
372:
373: --hr_utility.trace_on;
374: hr_utility.set_location(' Inside Salary Assignment',333);
375:
376: For C_flex_rec in C_flex_num
377: Loop
378: l_grade_id_flex_num := C_flex_rec.grade_structure;

Line 381: hr_utility.set_location(' date_effective XX '||p_date_effective,333);

377: Loop
378: l_grade_id_flex_num := C_flex_rec.grade_structure;
379: End Loop;
380:
381: hr_utility.set_location(' date_effective XX '||p_date_effective,333);
382: hr_utility.set_location(' date_end XX '||p_date_end,333);
383: hr_utility.set_location(' dtxid XX '||p_data_extract_id,333);
384: hr_utility.set_location(' bSid XX '||p_business_group_id,333);
385: hr_utility.set_location(' sob XX '||p_set_of_books_id,333);

Line 382: hr_utility.set_location(' date_end XX '||p_date_end,333);

378: l_grade_id_flex_num := C_flex_rec.grade_structure;
379: End Loop;
380:
381: hr_utility.set_location(' date_effective XX '||p_date_effective,333);
382: hr_utility.set_location(' date_end XX '||p_date_end,333);
383: hr_utility.set_location(' dtxid XX '||p_data_extract_id,333);
384: hr_utility.set_location(' bSid XX '||p_business_group_id,333);
385: hr_utility.set_location(' sob XX '||p_set_of_books_id,333);
386: hr_utility.set_location(' entry grade rule XX '||p_entry_grade_rule_id,333);

Line 383: hr_utility.set_location(' dtxid XX '||p_data_extract_id,333);

379: End Loop;
380:
381: hr_utility.set_location(' date_effective XX '||p_date_effective,333);
382: hr_utility.set_location(' date_end XX '||p_date_end,333);
383: hr_utility.set_location(' dtxid XX '||p_data_extract_id,333);
384: hr_utility.set_location(' bSid XX '||p_business_group_id,333);
385: hr_utility.set_location(' sob XX '||p_set_of_books_id,333);
386: hr_utility.set_location(' entry grade rule XX '||p_entry_grade_rule_id,333);
387: hr_utility.set_location(' step XX '||p_entry_step_id,333);

Line 384: hr_utility.set_location(' bSid XX '||p_business_group_id,333);

380:
381: hr_utility.set_location(' date_effective XX '||p_date_effective,333);
382: hr_utility.set_location(' date_end XX '||p_date_end,333);
383: hr_utility.set_location(' dtxid XX '||p_data_extract_id,333);
384: hr_utility.set_location(' bSid XX '||p_business_group_id,333);
385: hr_utility.set_location(' sob XX '||p_set_of_books_id,333);
386: hr_utility.set_location(' entry grade rule XX '||p_entry_grade_rule_id,333);
387: hr_utility.set_location(' step XX '||p_entry_step_id,333);
388: hr_utility.set_location(' grade id XX '||p_entry_grade_id,333);

Line 385: hr_utility.set_location(' sob XX '||p_set_of_books_id,333);

381: hr_utility.set_location(' date_effective XX '||p_date_effective,333);
382: hr_utility.set_location(' date_end XX '||p_date_end,333);
383: hr_utility.set_location(' dtxid XX '||p_data_extract_id,333);
384: hr_utility.set_location(' bSid XX '||p_business_group_id,333);
385: hr_utility.set_location(' sob XX '||p_set_of_books_id,333);
386: hr_utility.set_location(' entry grade rule XX '||p_entry_grade_rule_id,333);
387: hr_utility.set_location(' step XX '||p_entry_step_id,333);
388: hr_utility.set_location(' grade id XX '||p_entry_grade_id,333);
389: hr_utility.set_location(' pay basis XX '||p_pay_basis_id,333);

Line 386: hr_utility.set_location(' entry grade rule XX '||p_entry_grade_rule_id,333);

382: hr_utility.set_location(' date_end XX '||p_date_end,333);
383: hr_utility.set_location(' dtxid XX '||p_data_extract_id,333);
384: hr_utility.set_location(' bSid XX '||p_business_group_id,333);
385: hr_utility.set_location(' sob XX '||p_set_of_books_id,333);
386: hr_utility.set_location(' entry grade rule XX '||p_entry_grade_rule_id,333);
387: hr_utility.set_location(' step XX '||p_entry_step_id,333);
388: hr_utility.set_location(' grade id XX '||p_entry_grade_id,333);
389: hr_utility.set_location(' pay basis XX '||p_pay_basis_id,333);
390: hr_utility.set_location(' -----------------------------',333);

Line 387: hr_utility.set_location(' step XX '||p_entry_step_id,333);

383: hr_utility.set_location(' dtxid XX '||p_data_extract_id,333);
384: hr_utility.set_location(' bSid XX '||p_business_group_id,333);
385: hr_utility.set_location(' sob XX '||p_set_of_books_id,333);
386: hr_utility.set_location(' entry grade rule XX '||p_entry_grade_rule_id,333);
387: hr_utility.set_location(' step XX '||p_entry_step_id,333);
388: hr_utility.set_location(' grade id XX '||p_entry_grade_id,333);
389: hr_utility.set_location(' pay basis XX '||p_pay_basis_id,333);
390: hr_utility.set_location(' -----------------------------',333);
391:

Line 388: hr_utility.set_location(' grade id XX '||p_entry_grade_id,333);

384: hr_utility.set_location(' bSid XX '||p_business_group_id,333);
385: hr_utility.set_location(' sob XX '||p_set_of_books_id,333);
386: hr_utility.set_location(' entry grade rule XX '||p_entry_grade_rule_id,333);
387: hr_utility.set_location(' step XX '||p_entry_step_id,333);
388: hr_utility.set_location(' grade id XX '||p_entry_grade_id,333);
389: hr_utility.set_location(' pay basis XX '||p_pay_basis_id,333);
390: hr_utility.set_location(' -----------------------------',333);
391:
392: For C_Pay_Grade_Rec in C_Pay_Grade

Line 389: hr_utility.set_location(' pay basis XX '||p_pay_basis_id,333);

385: hr_utility.set_location(' sob XX '||p_set_of_books_id,333);
386: hr_utility.set_location(' entry grade rule XX '||p_entry_grade_rule_id,333);
387: hr_utility.set_location(' step XX '||p_entry_step_id,333);
388: hr_utility.set_location(' grade id XX '||p_entry_grade_id,333);
389: hr_utility.set_location(' pay basis XX '||p_pay_basis_id,333);
390: hr_utility.set_location(' -----------------------------',333);
391:
392: For C_Pay_Grade_Rec in C_Pay_Grade
393: Loop

Line 390: hr_utility.set_location(' -----------------------------',333);

386: hr_utility.set_location(' entry grade rule XX '||p_entry_grade_rule_id,333);
387: hr_utility.set_location(' step XX '||p_entry_step_id,333);
388: hr_utility.set_location(' grade id XX '||p_entry_grade_id,333);
389: hr_utility.set_location(' pay basis XX '||p_pay_basis_id,333);
390: hr_utility.set_location(' -----------------------------',333);
391:
392: For C_Pay_Grade_Rec in C_Pay_Grade
393: Loop
394:

Line 417: hr_utility.set_location(' cursor grade name '||l_grade_name,335);

413: EXIT WHEN c_grade_cv%NOTFOUND;
414: END LOOP;
415: CLOSE c_grade_cv; */
416:
417: hr_utility.set_location(' cursor grade name '||l_grade_name,335);
418:
419: For C_pay_basis_rec in C_pay_basis
420: Loop
421: l_pay_basis := C_pay_basis_rec.pay_basis;

Line 424: hr_utility.set_location(' pay basis '||l_pay_basis ||

420: Loop
421: l_pay_basis := C_pay_basis_rec.pay_basis;
422: End Loop;
423:
424: hr_utility.set_location(' pay basis '||l_pay_basis ||
425: ' ratetype ' || l_rate_type,336);
426:
427: if (l_rate_type = 'G') then
428: l_rate_or_payscale_id := C_Pay_Grade_Rec.rate_id;

Line 432: hr_utility.set_location(' payscale '||l_rate_or_payscale_id,335);

428: l_rate_or_payscale_id := C_Pay_Grade_Rec.rate_id;
429: l_value := fnd_number.canonical_to_number(C_Pay_Grade_Rec.value);
430: l_salary_type := 'RATE';
431:
432: hr_utility.set_location(' payscale '||l_rate_or_payscale_id,335);
433: For C_Rate_Rec in C_Rate
434: Loop
435: l_rate_or_payscale_name := C_Rate_Rec.name;
436: hr_utility.set_location(' Inside ZZ2 '||l_rate_or_payscale_id,335);

Line 436: hr_utility.set_location(' Inside ZZ2 '||l_rate_or_payscale_id,335);

432: hr_utility.set_location(' payscale '||l_rate_or_payscale_id,335);
433: For C_Rate_Rec in C_Rate
434: Loop
435: l_rate_or_payscale_name := C_Rate_Rec.name;
436: hr_utility.set_location(' Inside ZZ2 '||l_rate_or_payscale_id,335);
437: End Loop;
438:
439: FOR C_pay_elements_rate_rec in C_pay_elements_rate
440: LOOP

Line 462: hr_utility.set_location(' ZZ9 session date '||l_session_date ,336);

458: Loop
459: l_session_date := C_session_rec.effective_date;
460: end Loop;
461:
462: hr_utility.set_location(' ZZ9 session date '||l_session_date ,336);
463: per_spinal_point_steps_pkg.pop_flds(l_grade_step,
464: l_session_date,
465: l_grade_or_spinal_point_id,
466: l_grade_spine_id);

Line 468: hr_utility.set_location(' after pop_flds ' ,336);

464: l_session_date,
465: l_grade_or_spinal_point_id,
466: l_grade_spine_id);
467:
468: hr_utility.set_location(' after pop_flds ' ,336);
469: For C_Payscale_rec in C_Payscale
470: Loop
471: l_rate_or_payscale_id := C_Payscale_rec.parent_spine_id;
472: End Loop;

Line 645: hr_utility.set_location(' """ :: ele and option id is NULLLLL ' ,336);

641: l_pay_element_option_id is null and
642: l_value is null then
643:
644: null;
645: hr_utility.set_location(' """ :: ele and option id is NULLLLL ' ,336);
646: -- do not insert if there is nothing to insert
647: ELSE
648:
649: hr_utility.set_location(' ::: > before ASSinsert ' ,336);

Line 649: hr_utility.set_location(' ::: > before ASSinsert ' ,336);

645: hr_utility.set_location(' """ :: ele and option id is NULLLLL ' ,336);
646: -- do not insert if there is nothing to insert
647: ELSE
648:
649: hr_utility.set_location(' ::: > before ASSinsert ' ,336);
650:
651: PSB_POSITION_ASSIGNMENTS_PVT.INSERT_ROW
652: (
653: p_api_version => 1,

Line 686: hr_utility.set_location('fail insert assignments - stat is ' ||

682: p_mode => 'R'
683: );
684:
685: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
686: hr_utility.set_location('fail insert assignments - stat is ' ||
687: l_return_status,983);
688: RAISE FND_API.G_EXC_ERROR;
689: END IF;
690:

Line 697: hr_utility.set_location(' -------E N D S U CESS-------',333);

693: end if;
694:
695: END IF;
696:
697: hr_utility.set_location(' -------E N D S U CESS-------',333);
698: -- Initialize API return status to success
699: p_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: --hr_utility.trace_off;

Line 701: --hr_utility.trace_off;

697: hr_utility.set_location(' -------E N D S U CESS-------',333);
698: -- Initialize API return status to success
699: p_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: --hr_utility.trace_off;
702: EXCEPTION
703:
704: WHEN FND_API.G_EXC_ERROR THEN
705: hr_utility.set_location(' salary G_EXC_ERROR ----------',333);

Line 705: hr_utility.set_location(' salary G_EXC_ERROR ----------',333);

701: --hr_utility.trace_off;
702: EXCEPTION
703:
704: WHEN FND_API.G_EXC_ERROR THEN
705: hr_utility.set_location(' salary G_EXC_ERROR ----------',333);
706: --hr_utility.trace_off;
707: p_return_status := FND_API.G_RET_STS_ERROR;
708:
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 706: --hr_utility.trace_off;

702: EXCEPTION
703:
704: WHEN FND_API.G_EXC_ERROR THEN
705: hr_utility.set_location(' salary G_EXC_ERROR ----------',333);
706: --hr_utility.trace_off;
707: p_return_status := FND_API.G_RET_STS_ERROR;
708:
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: hr_utility.set_location(' G_EXC_UNEXPECTED_ERROR ------',333);

Line 710: hr_utility.set_location(' G_EXC_UNEXPECTED_ERROR ------',333);

706: --hr_utility.trace_off;
707: p_return_status := FND_API.G_RET_STS_ERROR;
708:
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: hr_utility.set_location(' G_EXC_UNEXPECTED_ERROR ------',333);
711: --hr_utility.trace_off;
712: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713:
714: WHEN OTHERS THEN

Line 711: --hr_utility.trace_off;

707: p_return_status := FND_API.G_RET_STS_ERROR;
708:
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: hr_utility.set_location(' G_EXC_UNEXPECTED_ERROR ------',333);
711: --hr_utility.trace_off;
712: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713:
714: WHEN OTHERS THEN
715: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 716: --hr_utility.trace_off;

712: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713:
714: WHEN OTHERS THEN
715: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: --hr_utility.trace_off;
717: hr_utility.set_location(' G_RET_STS_UNEXP_ERRORR ------',333);
718:
719: End Populate_Salary_Assignments;
720: /*---------------------------------------------------------------------------*/

Line 717: hr_utility.set_location(' G_RET_STS_UNEXP_ERRORR ------',333);

713:
714: WHEN OTHERS THEN
715: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: --hr_utility.trace_off;
717: hr_utility.set_location(' G_RET_STS_UNEXP_ERRORR ------',333);
718:
719: End Populate_Salary_Assignments;
720: /*---------------------------------------------------------------------------*/
721:

Line 905: --hr_utility.trace_on;

901: -- KFF, structure should either be 'Job Flexfield','Position Flexfield' or ,
902: -- 'Grade Flexfield. In both cases, attribute will be written to position
903: -- assgn only if either attribute_value_id or attribute_value is not null.
904:
905: --hr_utility.trace_on;
906:
907: For C_Attribute_Rec in C_Attributes
908: Loop -- L1
909:

Line 920: hr_utility.set_location(' Attribute tuype '||

916: l_definition_structure := C_Attribute_Rec.definition_structure;
917: l_definition_table := C_Attribute_Rec.definition_table;
918: l_definition_column := C_Attribute_Rec.definition_column;
919:
920: hr_utility.set_location(' Attribute tuype '||
921: C_Attribute_Rec.system_attribute_type ,888);
922:
923: l_valid_attribute := 'N' ; -- initial setting for each record
924:

Line 946: hr_utility.set_location(' JOB value '||l_attribute_value,888);

942: For C_Org_Rec in C_Pos_Org
943: Loop
944: lp_attribute_value := C_Org_Rec.name;
945: End Loop;
946: hr_utility.set_location(' JOB value '||l_attribute_value,888);
947:
948: elsif (C_Attribute_Rec.system_attribute_type = 'FTE') then
949: hr_utility.set_location(' FTE value ',888);
950: lp_attribute_value := p_fte;

Line 949: hr_utility.set_location(' FTE value ',888);

945: End Loop;
946: hr_utility.set_location(' JOB value '||l_attribute_value,888);
947:
948: elsif (C_Attribute_Rec.system_attribute_type = 'FTE') then
949: hr_utility.set_location(' FTE value ',888);
950: lp_attribute_value := p_fte;
951: l_valid_attribute := 'Y' ;
952:
953: elsif C_Attribute_Rec.system_attribute_type = 'DEFAULT_WEEKLY_HOURS' then

Line 990: --hr_utility.set_location(' Attribute Struct '||

986: C_key_str_rec.application_column_name;
987: End Loop;
988: End Loop;
989:
990: --hr_utility.set_location(' Attribute Struct '||
991: -- l_definition_structure,666);
992:
993: v_cursorid := dbms_sql.open_cursor;
994: if (l_definition_structure = 'Job Flexfield') then

Line 1048: --hr_utility.set_location('Attribute Success'||lp_attribute_value,666);

1044: dbms_sql.column_value(v_cursorid,1,v_segment);
1045: lp_attribute_value := v_segment;
1046: end loop;
1047:
1048: --hr_utility.set_location('Attribute Success'||lp_attribute_value,666);
1049: end if;
1050: elsif (l_definition_type = 'DFF') then
1051: For Attr_Type_Rec in C_Attribute_Type
1052: Loop

Line 1301: hr_utility.set_location(' %% VALID AttrValue '||l_valid_attribute,888);

1297:
1298: -- Process only if it's one of the tested attributes i.e., people kff,
1299: -- other info dff are not to be processed; only position related
1300:
1301: hr_utility.set_location(' %% VALID AttrValue '||l_valid_attribute,888);
1302:
1303: --++ proceed only if a valid attribute;
1304:
1305: IF l_valid_attribute = 'Y' THEN

Line 1307: hr_utility.set_location(' Attribute Value '||lp_attribute_value,888);

1303: --++ proceed only if a valid attribute;
1304:
1305: IF l_valid_attribute = 'Y' THEN
1306:
1307: hr_utility.set_location(' Attribute Value '||lp_attribute_value,888);
1308: hr_utility.set_location(' Attribute ID '||C_Attribute_Rec.attribute_id,888);
1309: hr_utility.set_location(' name '||C_Attribute_Rec.name,888);
1310:
1311: l_attribute_id := C_Attribute_Rec.attribute_id;

Line 1308: hr_utility.set_location(' Attribute ID '||C_Attribute_Rec.attribute_id,888);

1304:
1305: IF l_valid_attribute = 'Y' THEN
1306:
1307: hr_utility.set_location(' Attribute Value '||lp_attribute_value,888);
1308: hr_utility.set_location(' Attribute ID '||C_Attribute_Rec.attribute_id,888);
1309: hr_utility.set_location(' name '||C_Attribute_Rec.name,888);
1310:
1311: l_attribute_id := C_Attribute_Rec.attribute_id;
1312: l_value_table_flag := C_Attribute_Rec.value_table_flag;

Line 1309: hr_utility.set_location(' name '||C_Attribute_Rec.name,888);

1305: IF l_valid_attribute = 'Y' THEN
1306:
1307: hr_utility.set_location(' Attribute Value '||lp_attribute_value,888);
1308: hr_utility.set_location(' Attribute ID '||C_Attribute_Rec.attribute_id,888);
1309: hr_utility.set_location(' name '||C_Attribute_Rec.name,888);
1310:
1311: l_attribute_id := C_Attribute_Rec.attribute_id;
1312: l_value_table_flag := C_Attribute_Rec.value_table_flag;
1313: l_definition_type := C_Attribute_Rec.definition_type;

Line 1452: hr_utility.set_location(' Attribute Assign Success YYY',999);

1448:
1449: END IF; -- end of l_valid_attribute
1450: END IF; -- test of attribute val/id
1451:
1452: hr_utility.set_location(' Attribute Assign Success YYY',999);
1453: End Loop; --L1
1454: --hr_utility.trace_off;
1455:
1456: END Populate_Attribute_Assignments;

Line 1454: --hr_utility.trace_off;

1450: END IF; -- test of attribute val/id
1451:
1452: hr_utility.set_location(' Attribute Assign Success YYY',999);
1453: End Loop; --L1
1454: --hr_utility.trace_off;
1455:
1456: END Populate_Attribute_Assignments;
1457: /*---------------------------------------------------------------------------*/
1458:

Line 1673: --hr_utility.trace_on;

1669: order by segment_num;
1670: /*For Bug No : 2602027 End*/
1671: --
1672: BEGIN
1673: --hr_utility.trace_on;
1674: hr_utility.set_location('>> insert position trans',777);
1675:
1676: if (get_global('G_PSB_APPLICATION_ID') = 8401) then
1677: hr_utility.set_location('>> appl id is 8401',777);

Line 1674: hr_utility.set_location('>> insert position trans',777);

1670: /*For Bug No : 2602027 End*/
1671: --
1672: BEGIN
1673: --hr_utility.trace_on;
1674: hr_utility.set_location('>> insert position trans',777);
1675:
1676: if (get_global('G_PSB_APPLICATION_ID') = 8401) then
1677: hr_utility.set_location('>> appl id is 8401',777);
1678:

Line 1677: hr_utility.set_location('>> appl id is 8401',777);

1673: --hr_utility.trace_on;
1674: hr_utility.set_location('>> insert position trans',777);
1675:
1676: if (get_global('G_PSB_APPLICATION_ID') = 8401) then
1677: hr_utility.set_location('>> appl id is 8401',777);
1678:
1679: if (get_global('G_PSB_CURRENT_FORM') in ('PSBMNPOS', 'PSBBGRVS','PSBWMPMD'))
1680: then
1681: if (p_date_end = to_date('31124712','DDMMYYYY')) then

Line 1709: hr_utility.set_location('error in get segments',9867);

1705: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
1706: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );
1707: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
1708: FND_MSG_PUB.Add;
1709: hr_utility.set_location('error in get segments',9867);
1710: RAISE FND_API.G_EXC_ERROR;
1711: end if;
1712:
1713: l_per_index := 1;

Line 1976: hr_utility.set_location('error in get combination id',9867);

1972: l_msg := FND_MESSAGE.get;
1973: FND_MSG_PUB.Add;
1974: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_CCID_FAILURE');
1975: FND_MESSAGE.SET_TOKEN('ERRMESG',l_msg);
1976: hr_utility.set_location('error in get combination id',9867);
1977: RAISE FND_API.G_EXC_ERROR;
1978: end if;
1979:
1980: l_concat_pos_name := null;

Line 2066: hr_utility.set_location('>> added to pos set id ' || l_position_id,876);

2062: p_msg_data => l_msg_data,
2063: p_position_id => l_position_id
2064: ) ;
2065:
2066: hr_utility.set_location('>> added to pos set id ' || l_position_id,876);
2067: hr_utility.set_location('>> stat is ' || l_return_status,877);
2068:
2069: -- Populate Salary Assignments
2070:

Line 2067: hr_utility.set_location('>> stat is ' || l_return_status,877);

2063: p_position_id => l_position_id
2064: ) ;
2065:
2066: hr_utility.set_location('>> added to pos set id ' || l_position_id,876);
2067: hr_utility.set_location('>> stat is ' || l_return_status,877);
2068:
2069: -- Populate Salary Assignments
2070:
2071: Populate_Salary_Assignments

Line 2116: hr_utility.set_location(' fail to update ws value ',888);

2112: p_position_id => l_position_id,
2113: p_org_id => p_organization_id
2114: ) ;
2115: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2116: hr_utility.set_location(' fail to update ws value ',888);
2117: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_WS_FAILURE' );
2118: RAISE FND_API.G_EXC_ERROR;
2119: END IF;
2120:

Line 2121: hr_utility.set_location('>> END insert position trans',777);

2117: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_WS_FAILURE' );
2118: RAISE FND_API.G_EXC_ERROR;
2119: END IF;
2120:
2121: hr_utility.set_location('>> END insert position trans',777);
2122: --hr_utility.trace_off;
2123:
2124: end if;
2125: -- End checking G_PSB_CURRENT_FORM.

Line 2122: --hr_utility.trace_off;

2118: RAISE FND_API.G_EXC_ERROR;
2119: END IF;
2120:
2121: hr_utility.set_location('>> END insert position trans',777);
2122: --hr_utility.trace_off;
2123:
2124: end if;
2125: -- End checking G_PSB_CURRENT_FORM.
2126:

Line 2268: --hr_utility.trace_on;

2264: /*For Bug No : 2602027 End*/
2265:
2266: Begin
2267:
2268: --hr_utility.trace_on;
2269: hr_utility.set_location('>> update position trans',777);
2270: hr_utility.set_location('>> p_position_transaction_id' || p_position_transaction_id,777);
2271:
2272: for c_trn_exist_rec in c_trn_exist loop

Line 2269: hr_utility.set_location('>> update position trans',777);

2265:
2266: Begin
2267:
2268: --hr_utility.trace_on;
2269: hr_utility.set_location('>> update position trans',777);
2270: hr_utility.set_location('>> p_position_transaction_id' || p_position_transaction_id,777);
2271:
2272: for c_trn_exist_rec in c_trn_exist loop
2273: l_trn_exist := FND_API.G_TRUE;

Line 2270: hr_utility.set_location('>> p_position_transaction_id' || p_position_transaction_id,777);

2266: Begin
2267:
2268: --hr_utility.trace_on;
2269: hr_utility.set_location('>> update position trans',777);
2270: hr_utility.set_location('>> p_position_transaction_id' || p_position_transaction_id,777);
2271:
2272: for c_trn_exist_rec in c_trn_exist loop
2273: l_trn_exist := FND_API.G_TRUE;
2274: end loop;

Line 2289: hr_utility.set_location('>> applid 8401 ' ,1777);

2285: ) OR
2286: (p_transaction_status = 'APPLIED' ) then
2287: /*For Bug No : 2738939 End*/
2288:
2289: hr_utility.set_location('>> applid 8401 ' ,1777);
2290:
2291: For C_pos_trx_rec in C_pos_trx -- psb_positions
2292: Loop
2293: l_psb_position_id := C_pos_trx_rec.position_id;

Line 2305: hr_utility.set_location('>> l_position_id_flex_num '||

2301: l_set_of_books_id := C_data_extract_rec.set_of_books_id;
2302: l_position_id_flex_num := C_data_extract_rec.position_id_flex_num;
2303: End Loop;
2304:
2305: hr_utility.set_location('>> l_position_id_flex_num '||
2306: l_position_id_flex_num,777);
2307:
2308: For C_Avail_Status_Rec in C_Availability_Status
2309: Loop

Line 2333: hr_utility.set_location('error in get segments',9850);

2329: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
2330: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );
2331: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
2332: FND_MSG_PUB.Add;
2333: hr_utility.set_location('error in get segments',9850);
2334: RAISE FND_API.G_EXC_ERROR;
2335: end if;
2336:
2337: l_per_index := 1;

Line 2601: hr_utility.set_location('error in get combination id',9867);

2597: l_msg := FND_MESSAGE.get;
2598: FND_MSG_PUB.Add;
2599: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_CCID_FAILURE');
2600: FND_MESSAGE.SET_TOKEN('ERRMESG',l_msg);
2601: hr_utility.set_location('error in get combination id',9867);
2602: RAISE FND_API.G_EXC_ERROR;
2603: end if;
2604:
2605: l_concat_pos_name := null;

Line 2612: hr_utility.set_location('>> l_ccid '|| l_ccid,777);

2608: key_flex_code => 'BPS',
2609: structure_number => l_position_id_flex_num,
2610: combination_id => l_ccid);
2611:
2612: hr_utility.set_location('>> l_ccid '|| l_ccid,777);
2613:
2614: --++ end restructure
2615:
2616: PSB_POSITIONS_PVT.UPDATE_ROW

Line 2677: hr_utility.set_location('>> DELETING records to recreate .... ' ,1777);

2673: END IF;
2674:
2675: IF (p_transaction_status <> 'APPLIED') then
2676:
2677: hr_utility.set_location('>> DELETING records to recreate .... ' ,1777);
2678: Delete psb_position_assignments
2679: where position_id = l_psb_position_id;
2680:
2681: Populate_Salary_Assignments

Line 2730: hr_utility.set_location('>> ....1 continue .... ' ,1777);

2726: --++ end process of modification
2727:
2728: --++ R e j e c t process
2729:
2730: hr_utility.set_location('>> ....1 continue .... ' ,1777);
2731:
2732: /*For Bug No : 2738939 Start*/
2733: --included the TERMINATE also in the following check
2734: if (p_transaction_status in ('REJECT','TERMINATE'))

Line 2737: hr_utility.set_location('>> '||p_transaction_status ,1777);

2733: --included the TERMINATE also in the following check
2734: if (p_transaction_status in ('REJECT','TERMINATE'))
2735: then
2736: /*For Bug No : 2738939 End*/
2737: hr_utility.set_location('>> '||p_transaction_status ,1777);
2738: hr_utility.set_location('>> p_position_transaction_id' || p_position_transaction_id,777);
2739: For C_pos_trx_rec in C_pos_trx
2740: Loop
2741: l_psb_position_id := C_pos_trx_rec.position_id;

Line 2738: hr_utility.set_location('>> p_position_transaction_id' || p_position_transaction_id,777);

2734: if (p_transaction_status in ('REJECT','TERMINATE'))
2735: then
2736: /*For Bug No : 2738939 End*/
2737: hr_utility.set_location('>> '||p_transaction_status ,1777);
2738: hr_utility.set_location('>> p_position_transaction_id' || p_position_transaction_id,777);
2739: For C_pos_trx_rec in C_pos_trx
2740: Loop
2741: l_psb_position_id := C_pos_trx_rec.position_id;
2742: hr_utility.set_location('>> l_psb_position_id '|| l_psb_position_id,1777);

Line 2742: hr_utility.set_location('>> l_psb_position_id '|| l_psb_position_id,1777);

2738: hr_utility.set_location('>> p_position_transaction_id' || p_position_transaction_id,777);
2739: For C_pos_trx_rec in C_pos_trx
2740: Loop
2741: l_psb_position_id := C_pos_trx_rec.position_id;
2742: hr_utility.set_location('>> l_psb_position_id '|| l_psb_position_id,1777);
2743: End Loop;
2744:
2745: if l_psb_position_id is not null then
2746: For c_ws_positions_rec in c_ws_positions loop

Line 2787: hr_utility.set_location('>> pos delete row Error ' ,1777);

2783: p_msg_data => l_msg_data,
2784: p_position_id => l_psb_position_id);
2785:
2786: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2787: hr_utility.set_location('>> pos delete row Error ' ,1777);
2788: RAISE FND_API.G_EXC_ERROR;
2789: END IF;
2790: end if; -- end of rejecct
2791:

Line 2794: --hr_utility.trace_off;

2790: end if; -- end of rejecct
2791:
2792: end if; -- end of application_id test
2793: end if; -- end of test l_trn_exist (a)
2794: --hr_utility.trace_off;
2795:
2796: EXCEPTION
2797: --
2798: WHEN OTHERS THEN

Line 2906: --hr_utility.trace_on;

2902:
2903: /* For Bug No : 2739450 Start*/
2904: IF (p_position_transaction_id IS NULL) THEN
2905: /*For Bug No. 2739450 End*/
2906: --hr_utility.trace_on;
2907: hr_utility.set_location(' Start Insert Position',777);
2908:
2909: hr_utility.set_location(' position_id '||p_position_id,881);
2910: hr_utility.set_location(' effective_start_date'||p_effective_start_date,881);

Line 2907: hr_utility.set_location(' Start Insert Position',777);

2903: /* For Bug No : 2739450 Start*/
2904: IF (p_position_transaction_id IS NULL) THEN
2905: /*For Bug No. 2739450 End*/
2906: --hr_utility.trace_on;
2907: hr_utility.set_location(' Start Insert Position',777);
2908:
2909: hr_utility.set_location(' position_id '||p_position_id,881);
2910: hr_utility.set_location(' effective_start_date'||p_effective_start_date,881);
2911: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);

Line 2909: hr_utility.set_location(' position_id '||p_position_id,881);

2905: /*For Bug No. 2739450 End*/
2906: --hr_utility.trace_on;
2907: hr_utility.set_location(' Start Insert Position',777);
2908:
2909: hr_utility.set_location(' position_id '||p_position_id,881);
2910: hr_utility.set_location(' effective_start_date'||p_effective_start_date,881);
2911: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
2912: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
2913: hr_utility.set_location(' business group stat '||p_business_group_id,881);

Line 2910: hr_utility.set_location(' effective_start_date'||p_effective_start_date,881);

2906: --hr_utility.trace_on;
2907: hr_utility.set_location(' Start Insert Position',777);
2908:
2909: hr_utility.set_location(' position_id '||p_position_id,881);
2910: hr_utility.set_location(' effective_start_date'||p_effective_start_date,881);
2911: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
2912: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
2913: hr_utility.set_location(' business group stat '||p_business_group_id,881);
2914: hr_utility.set_location(' entry step id '||p_entry_step_id,881);

Line 2911: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);

2907: hr_utility.set_location(' Start Insert Position',777);
2908:
2909: hr_utility.set_location(' position_id '||p_position_id,881);
2910: hr_utility.set_location(' effective_start_date'||p_effective_start_date,881);
2911: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
2912: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
2913: hr_utility.set_location(' business group stat '||p_business_group_id,881);
2914: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
2915: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);

Line 2912: hr_utility.set_location(' availability stat '||p_availability_status_id,881);

2908:
2909: hr_utility.set_location(' position_id '||p_position_id,881);
2910: hr_utility.set_location(' effective_start_date'||p_effective_start_date,881);
2911: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
2912: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
2913: hr_utility.set_location(' business group stat '||p_business_group_id,881);
2914: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
2915: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
2916: hr_utility.set_location(' entry job id '||p_job_id,881);

Line 2913: hr_utility.set_location(' business group stat '||p_business_group_id,881);

2909: hr_utility.set_location(' position_id '||p_position_id,881);
2910: hr_utility.set_location(' effective_start_date'||p_effective_start_date,881);
2911: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
2912: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
2913: hr_utility.set_location(' business group stat '||p_business_group_id,881);
2914: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
2915: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
2916: hr_utility.set_location(' entry job id '||p_job_id,881);
2917: hr_utility.set_location(' entry location id '||p_location_id,881);

Line 2914: hr_utility.set_location(' entry step id '||p_entry_step_id,881);

2910: hr_utility.set_location(' effective_start_date'||p_effective_start_date,881);
2911: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
2912: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
2913: hr_utility.set_location(' business group stat '||p_business_group_id,881);
2914: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
2915: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
2916: hr_utility.set_location(' entry job id '||p_job_id,881);
2917: hr_utility.set_location(' entry location id '||p_location_id,881);
2918: hr_utility.set_location(' entry org id '||p_organization_id,881);

Line 2915: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);

2911: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
2912: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
2913: hr_utility.set_location(' business group stat '||p_business_group_id,881);
2914: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
2915: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
2916: hr_utility.set_location(' entry job id '||p_job_id,881);
2917: hr_utility.set_location(' entry location id '||p_location_id,881);
2918: hr_utility.set_location(' entry org id '||p_organization_id,881);
2919: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);

Line 2916: hr_utility.set_location(' entry job id '||p_job_id,881);

2912: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
2913: hr_utility.set_location(' business group stat '||p_business_group_id,881);
2914: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
2915: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
2916: hr_utility.set_location(' entry job id '||p_job_id,881);
2917: hr_utility.set_location(' entry location id '||p_location_id,881);
2918: hr_utility.set_location(' entry org id '||p_organization_id,881);
2919: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
2920: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);

Line 2917: hr_utility.set_location(' entry location id '||p_location_id,881);

2913: hr_utility.set_location(' business group stat '||p_business_group_id,881);
2914: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
2915: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
2916: hr_utility.set_location(' entry job id '||p_job_id,881);
2917: hr_utility.set_location(' entry location id '||p_location_id,881);
2918: hr_utility.set_location(' entry org id '||p_organization_id,881);
2919: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
2920: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
2921: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);

Line 2918: hr_utility.set_location(' entry org id '||p_organization_id,881);

2914: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
2915: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
2916: hr_utility.set_location(' entry job id '||p_job_id,881);
2917: hr_utility.set_location(' entry location id '||p_location_id,881);
2918: hr_utility.set_location(' entry org id '||p_organization_id,881);
2919: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
2920: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
2921: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
2922: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);

Line 2919: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);

2915: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
2916: hr_utility.set_location(' entry job id '||p_job_id,881);
2917: hr_utility.set_location(' entry location id '||p_location_id,881);
2918: hr_utility.set_location(' entry org id '||p_organization_id,881);
2919: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
2920: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
2921: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
2922: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
2923: hr_utility.set_location(' date eff '||p_date_effective,881);

Line 2920: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);

2916: hr_utility.set_location(' entry job id '||p_job_id,881);
2917: hr_utility.set_location(' entry location id '||p_location_id,881);
2918: hr_utility.set_location(' entry org id '||p_organization_id,881);
2919: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
2920: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
2921: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
2922: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
2923: hr_utility.set_location(' date eff '||p_date_effective,881);
2924: hr_utility.set_location(' date end '||p_date_end,881);

Line 2921: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);

2917: hr_utility.set_location(' entry location id '||p_location_id,881);
2918: hr_utility.set_location(' entry org id '||p_organization_id,881);
2919: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
2920: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
2921: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
2922: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
2923: hr_utility.set_location(' date eff '||p_date_effective,881);
2924: hr_utility.set_location(' date end '||p_date_end,881);
2925: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);

Line 2922: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);

2918: hr_utility.set_location(' entry org id '||p_organization_id,881);
2919: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
2920: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
2921: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
2922: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
2923: hr_utility.set_location(' date eff '||p_date_effective,881);
2924: hr_utility.set_location(' date end '||p_date_end,881);
2925: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
2926: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);

Line 2923: hr_utility.set_location(' date eff '||p_date_effective,881);

2919: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
2920: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
2921: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
2922: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
2923: hr_utility.set_location(' date eff '||p_date_effective,881);
2924: hr_utility.set_location(' date end '||p_date_end,881);
2925: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
2926: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
2927: hr_utility.set_location(' frequency '||p_frequency,881);

Line 2924: hr_utility.set_location(' date end '||p_date_end,881);

2920: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
2921: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
2922: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
2923: hr_utility.set_location(' date eff '||p_date_effective,881);
2924: hr_utility.set_location(' date end '||p_date_end,881);
2925: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
2926: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
2927: hr_utility.set_location(' frequency '||p_frequency,881);
2928: hr_utility.set_location(' working hours '||p_working_hours,881);

Line 2925: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);

2921: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
2922: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
2923: hr_utility.set_location(' date eff '||p_date_effective,881);
2924: hr_utility.set_location(' date end '||p_date_end,881);
2925: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
2926: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
2927: hr_utility.set_location(' frequency '||p_frequency,881);
2928: hr_utility.set_location(' working hours '||p_working_hours,881);
2929: hr_utility.set_location(' fte '||p_fte,881);

Line 2926: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);

2922: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
2923: hr_utility.set_location(' date eff '||p_date_effective,881);
2924: hr_utility.set_location(' date end '||p_date_end,881);
2925: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
2926: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
2927: hr_utility.set_location(' frequency '||p_frequency,881);
2928: hr_utility.set_location(' working hours '||p_working_hours,881);
2929: hr_utility.set_location(' fte '||p_fte,881);
2930: hr_utility.set_location(' name '||p_name,881);

Line 2927: hr_utility.set_location(' frequency '||p_frequency,881);

2923: hr_utility.set_location(' date eff '||p_date_effective,881);
2924: hr_utility.set_location(' date end '||p_date_end,881);
2925: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
2926: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
2927: hr_utility.set_location(' frequency '||p_frequency,881);
2928: hr_utility.set_location(' working hours '||p_working_hours,881);
2929: hr_utility.set_location(' fte '||p_fte,881);
2930: hr_utility.set_location(' name '||p_name,881);
2931: hr_utility.set_location(' position type '||p_position_type,881);

Line 2928: hr_utility.set_location(' working hours '||p_working_hours,881);

2924: hr_utility.set_location(' date end '||p_date_end,881);
2925: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
2926: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
2927: hr_utility.set_location(' frequency '||p_frequency,881);
2928: hr_utility.set_location(' working hours '||p_working_hours,881);
2929: hr_utility.set_location(' fte '||p_fte,881);
2930: hr_utility.set_location(' name '||p_name,881);
2931: hr_utility.set_location(' position type '||p_position_type,881);
2932: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);

Line 2929: hr_utility.set_location(' fte '||p_fte,881);

2925: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
2926: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
2927: hr_utility.set_location(' frequency '||p_frequency,881);
2928: hr_utility.set_location(' working hours '||p_working_hours,881);
2929: hr_utility.set_location(' fte '||p_fte,881);
2930: hr_utility.set_location(' name '||p_name,881);
2931: hr_utility.set_location(' position type '||p_position_type,881);
2932: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
2933: hr_utility.set_location(' object version # '||p_object_version_number,881);

Line 2930: hr_utility.set_location(' name '||p_name,881);

2926: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
2927: hr_utility.set_location(' frequency '||p_frequency,881);
2928: hr_utility.set_location(' working hours '||p_working_hours,881);
2929: hr_utility.set_location(' fte '||p_fte,881);
2930: hr_utility.set_location(' name '||p_name,881);
2931: hr_utility.set_location(' position type '||p_position_type,881);
2932: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
2933: hr_utility.set_location(' object version # '||p_object_version_number,881);
2934: hr_utility.set_location(' applid >> '||get_global('G_PSB_APPLICATION_ID'),881);

Line 2931: hr_utility.set_location(' position type '||p_position_type,881);

2927: hr_utility.set_location(' frequency '||p_frequency,881);
2928: hr_utility.set_location(' working hours '||p_working_hours,881);
2929: hr_utility.set_location(' fte '||p_fte,881);
2930: hr_utility.set_location(' name '||p_name,881);
2931: hr_utility.set_location(' position type '||p_position_type,881);
2932: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
2933: hr_utility.set_location(' object version # '||p_object_version_number,881);
2934: hr_utility.set_location(' applid >> '||get_global('G_PSB_APPLICATION_ID'),881);
2935: hr_utility.set_location(' revS >> '||get_global('G_PSB_REVISION_START_DATE'),881);

Line 2932: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);

2928: hr_utility.set_location(' working hours '||p_working_hours,881);
2929: hr_utility.set_location(' fte '||p_fte,881);
2930: hr_utility.set_location(' name '||p_name,881);
2931: hr_utility.set_location(' position type '||p_position_type,881);
2932: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
2933: hr_utility.set_location(' object version # '||p_object_version_number,881);
2934: hr_utility.set_location(' applid >> '||get_global('G_PSB_APPLICATION_ID'),881);
2935: hr_utility.set_location(' revS >> '||get_global('G_PSB_REVISION_START_DATE'),881);
2936: hr_utility.set_location(' revE >> '||get_global('G_PSB_REVISION_END_DATE'),881);

Line 2933: hr_utility.set_location(' object version # '||p_object_version_number,881);

2929: hr_utility.set_location(' fte '||p_fte,881);
2930: hr_utility.set_location(' name '||p_name,881);
2931: hr_utility.set_location(' position type '||p_position_type,881);
2932: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
2933: hr_utility.set_location(' object version # '||p_object_version_number,881);
2934: hr_utility.set_location(' applid >> '||get_global('G_PSB_APPLICATION_ID'),881);
2935: hr_utility.set_location(' revS >> '||get_global('G_PSB_REVISION_START_DATE'),881);
2936: hr_utility.set_location(' revE >> '||get_global('G_PSB_REVISION_END_DATE'),881);
2937:

Line 2934: hr_utility.set_location(' applid >> '||get_global('G_PSB_APPLICATION_ID'),881);

2930: hr_utility.set_location(' name '||p_name,881);
2931: hr_utility.set_location(' position type '||p_position_type,881);
2932: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
2933: hr_utility.set_location(' object version # '||p_object_version_number,881);
2934: hr_utility.set_location(' applid >> '||get_global('G_PSB_APPLICATION_ID'),881);
2935: hr_utility.set_location(' revS >> '||get_global('G_PSB_REVISION_START_DATE'),881);
2936: hr_utility.set_location(' revE >> '||get_global('G_PSB_REVISION_END_DATE'),881);
2937:
2938: ---++++ start of code

Line 2935: hr_utility.set_location(' revS >> '||get_global('G_PSB_REVISION_START_DATE'),881);

2931: hr_utility.set_location(' position type '||p_position_type,881);
2932: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
2933: hr_utility.set_location(' object version # '||p_object_version_number,881);
2934: hr_utility.set_location(' applid >> '||get_global('G_PSB_APPLICATION_ID'),881);
2935: hr_utility.set_location(' revS >> '||get_global('G_PSB_REVISION_START_DATE'),881);
2936: hr_utility.set_location(' revE >> '||get_global('G_PSB_REVISION_END_DATE'),881);
2937:
2938: ---++++ start of code
2939:

Line 2936: hr_utility.set_location(' revE >> '||get_global('G_PSB_REVISION_END_DATE'),881);

2932: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
2933: hr_utility.set_location(' object version # '||p_object_version_number,881);
2934: hr_utility.set_location(' applid >> '||get_global('G_PSB_APPLICATION_ID'),881);
2935: hr_utility.set_location(' revS >> '||get_global('G_PSB_REVISION_START_DATE'),881);
2936: hr_utility.set_location(' revE >> '||get_global('G_PSB_REVISION_END_DATE'),881);
2937:
2938: ---++++ start of code
2939:
2940: if (get_global('G_PSB_APPLICATION_ID') = 8401) then

Line 2949: hr_utility.set_location(' Extract Id'||l_data_extract_id,881);

2945: l_date_end := p_date_end;
2946: end if;
2947:
2948: l_data_extract_id := get_global('G_PSB_DATA_EXTRACT_ID');
2949: hr_utility.set_location(' Extract Id'||l_data_extract_id,881);
2950:
2951: For C_data_extract_rec in C_data_extract
2952: Loop
2953: l_set_of_books_id := C_data_extract_rec.set_of_books_id;

Line 2958: hr_utility.set_location(' Validity Date '||l_validity_date,881);

2954: l_position_id_flex_num := C_data_extract_rec.position_id_flex_num;
2955: --l_validity_date := C_data_extract_rec.req_data_as_of_date;
2956: End Loop;
2957:
2958: hr_utility.set_location(' Validity Date '||l_validity_date,881);
2959: hr_utility.set_location(' After Validity Date '||l_validity_date,881);
2960:
2961: /*For Bug No : 2602027 Start*/
2962: For C_flex_rec in C_flex_num

Line 2959: hr_utility.set_location(' After Validity Date '||l_validity_date,881);

2955: --l_validity_date := C_data_extract_rec.req_data_as_of_date;
2956: End Loop;
2957:
2958: hr_utility.set_location(' Validity Date '||l_validity_date,881);
2959: hr_utility.set_location(' After Validity Date '||l_validity_date,881);
2960:
2961: /*For Bug No : 2602027 Start*/
2962: For C_flex_rec in C_flex_num
2963: Loop

Line 2974: hr_utility.set_location('error in get segments',9850);

2970: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
2971: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );
2972: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
2973: FND_MSG_PUB.Add;
2974: hr_utility.set_location('error in get segments',9850);
2975: RAISE FND_API.G_EXC_ERROR;
2976: end if;
2977:
2978: l_per_index := 1;

Line 3239: hr_utility.set_location('error in get combination id',9867);

3235: l_msg := FND_MESSAGE.get;
3236: FND_MSG_PUB.ADD;
3237: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_CCID_FAILURE');
3238: FND_MESSAGE.SET_TOKEN('ERRMESG',l_msg);
3239: hr_utility.set_location('error in get combination id',9867);
3240: RAISE FND_API.G_EXC_ERROR;
3241: end if;
3242:
3243: hr_utility.set_location('pos id flex num in '||

Line 3243: hr_utility.set_location('pos id flex num in '||

3239: hr_utility.set_location('error in get combination id',9867);
3240: RAISE FND_API.G_EXC_ERROR;
3241: end if;
3242:
3243: hr_utility.set_location('pos id flex num in '||
3244: l_position_id_flex_num || ' ccid ' || l_ccid ,9867);
3245:
3246: l_concat_pos_name := null;
3247: l_concat_pos_name := FND_FLEX_EXT.Get_Segs

Line 3253: hr_utility.set_location('concat pos name is '|| l_concat_pos_name,9877);

3249: key_flex_code => 'BPS',
3250: structure_number => l_position_id_flex_num,
3251: combination_id => l_ccid);
3252:
3253: hr_utility.set_location('concat pos name is '|| l_concat_pos_name,9877);
3254:
3255: For C_avail_status_rec in C_avail_status
3256: Loop
3257: /*For Bug No 1527423 Start */

Line 3267: hr_utility.set_location('l_position_id '||l_position_id ,9833);

3263: -- Create new position in PSB
3264: select psb_positions_s.nextval INTO l_position_id
3265: from dual;
3266:
3267: hr_utility.set_location('l_position_id '||l_position_id ,9833);
3268: hr_utility.set_location('l_data_extract_id '||l_data_extract_id, 9833);
3269: hr_utility.set_location('l_ccid '||l_ccid ,9833);
3270: hr_utility.set_location('p_position_id '||p_position_id ,9833);
3271: hr_utility.set_location('p_business_group_id '||p_business_group_id,9833);

Line 3268: hr_utility.set_location('l_data_extract_id '||l_data_extract_id, 9833);

3264: select psb_positions_s.nextval INTO l_position_id
3265: from dual;
3266:
3267: hr_utility.set_location('l_position_id '||l_position_id ,9833);
3268: hr_utility.set_location('l_data_extract_id '||l_data_extract_id, 9833);
3269: hr_utility.set_location('l_ccid '||l_ccid ,9833);
3270: hr_utility.set_location('p_position_id '||p_position_id ,9833);
3271: hr_utility.set_location('p_business_group_id '||p_business_group_id,9833);
3272: hr_utility.set_location('p_date_effective, '||p_date_effective, 9833);

Line 3269: hr_utility.set_location('l_ccid '||l_ccid ,9833);

3265: from dual;
3266:
3267: hr_utility.set_location('l_position_id '||l_position_id ,9833);
3268: hr_utility.set_location('l_data_extract_id '||l_data_extract_id, 9833);
3269: hr_utility.set_location('l_ccid '||l_ccid ,9833);
3270: hr_utility.set_location('p_position_id '||p_position_id ,9833);
3271: hr_utility.set_location('p_business_group_id '||p_business_group_id,9833);
3272: hr_utility.set_location('p_date_effective, '||p_date_effective, 9833);
3273: hr_utility.set_location('l_date_end '||l_date_end ,9833);

Line 3270: hr_utility.set_location('p_position_id '||p_position_id ,9833);

3266:
3267: hr_utility.set_location('l_position_id '||l_position_id ,9833);
3268: hr_utility.set_location('l_data_extract_id '||l_data_extract_id, 9833);
3269: hr_utility.set_location('l_ccid '||l_ccid ,9833);
3270: hr_utility.set_location('p_position_id '||p_position_id ,9833);
3271: hr_utility.set_location('p_business_group_id '||p_business_group_id,9833);
3272: hr_utility.set_location('p_date_effective, '||p_date_effective, 9833);
3273: hr_utility.set_location('l_date_end '||l_date_end ,9833);
3274: hr_utility.set_location('l_set_of_books_id '||l_set_of_books_id ,9833);

Line 3271: hr_utility.set_location('p_business_group_id '||p_business_group_id,9833);

3267: hr_utility.set_location('l_position_id '||l_position_id ,9833);
3268: hr_utility.set_location('l_data_extract_id '||l_data_extract_id, 9833);
3269: hr_utility.set_location('l_ccid '||l_ccid ,9833);
3270: hr_utility.set_location('p_position_id '||p_position_id ,9833);
3271: hr_utility.set_location('p_business_group_id '||p_business_group_id,9833);
3272: hr_utility.set_location('p_date_effective, '||p_date_effective, 9833);
3273: hr_utility.set_location('l_date_end '||l_date_end ,9833);
3274: hr_utility.set_location('l_set_of_books_id '||l_set_of_books_id ,9833);
3275: hr_utility.set_location('l_vacant_position_flag '||

Line 3272: hr_utility.set_location('p_date_effective, '||p_date_effective, 9833);

3268: hr_utility.set_location('l_data_extract_id '||l_data_extract_id, 9833);
3269: hr_utility.set_location('l_ccid '||l_ccid ,9833);
3270: hr_utility.set_location('p_position_id '||p_position_id ,9833);
3271: hr_utility.set_location('p_business_group_id '||p_business_group_id,9833);
3272: hr_utility.set_location('p_date_effective, '||p_date_effective, 9833);
3273: hr_utility.set_location('l_date_end '||l_date_end ,9833);
3274: hr_utility.set_location('l_set_of_books_id '||l_set_of_books_id ,9833);
3275: hr_utility.set_location('l_vacant_position_flag '||
3276: l_vacant_position_flag ,9833);

Line 3273: hr_utility.set_location('l_date_end '||l_date_end ,9833);

3269: hr_utility.set_location('l_ccid '||l_ccid ,9833);
3270: hr_utility.set_location('p_position_id '||p_position_id ,9833);
3271: hr_utility.set_location('p_business_group_id '||p_business_group_id,9833);
3272: hr_utility.set_location('p_date_effective, '||p_date_effective, 9833);
3273: hr_utility.set_location('l_date_end '||l_date_end ,9833);
3274: hr_utility.set_location('l_set_of_books_id '||l_set_of_books_id ,9833);
3275: hr_utility.set_location('l_vacant_position_flag '||
3276: l_vacant_position_flag ,9833);
3277: hr_utility.set_location('_availability_status '||

Line 3274: hr_utility.set_location('l_set_of_books_id '||l_set_of_books_id ,9833);

3270: hr_utility.set_location('p_position_id '||p_position_id ,9833);
3271: hr_utility.set_location('p_business_group_id '||p_business_group_id,9833);
3272: hr_utility.set_location('p_date_effective, '||p_date_effective, 9833);
3273: hr_utility.set_location('l_date_end '||l_date_end ,9833);
3274: hr_utility.set_location('l_set_of_books_id '||l_set_of_books_id ,9833);
3275: hr_utility.set_location('l_vacant_position_flag '||
3276: l_vacant_position_flag ,9833);
3277: hr_utility.set_location('_availability_status '||
3278: l_availability_status ,9833);

Line 3275: hr_utility.set_location('l_vacant_position_flag '||

3271: hr_utility.set_location('p_business_group_id '||p_business_group_id,9833);
3272: hr_utility.set_location('p_date_effective, '||p_date_effective, 9833);
3273: hr_utility.set_location('l_date_end '||l_date_end ,9833);
3274: hr_utility.set_location('l_set_of_books_id '||l_set_of_books_id ,9833);
3275: hr_utility.set_location('l_vacant_position_flag '||
3276: l_vacant_position_flag ,9833);
3277: hr_utility.set_location('_availability_status '||
3278: l_availability_status ,9833);
3279: hr_utility.set_location('l_concat_pos_name '||l_concat_pos_name ,9833);

Line 3277: hr_utility.set_location('_availability_status '||

3273: hr_utility.set_location('l_date_end '||l_date_end ,9833);
3274: hr_utility.set_location('l_set_of_books_id '||l_set_of_books_id ,9833);
3275: hr_utility.set_location('l_vacant_position_flag '||
3276: l_vacant_position_flag ,9833);
3277: hr_utility.set_location('_availability_status '||
3278: l_availability_status ,9833);
3279: hr_utility.set_location('l_concat_pos_name '||l_concat_pos_name ,9833);
3280:
3281: PSB_POSITIONS_PVT.INSERT_ROW

Line 3279: hr_utility.set_location('l_concat_pos_name '||l_concat_pos_name ,9833);

3275: hr_utility.set_location('l_vacant_position_flag '||
3276: l_vacant_position_flag ,9833);
3277: hr_utility.set_location('_availability_status '||
3278: l_availability_status ,9833);
3279: hr_utility.set_location('l_concat_pos_name '||l_concat_pos_name ,9833);
3280:
3281: PSB_POSITIONS_PVT.INSERT_ROW
3282: (
3283: p_api_version => 1.0,

Line 3333: hr_utility.set_location('error in insert position',9877);

3329: p_mode => 'R'
3330: );
3331:
3332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3333: hr_utility.set_location('error in insert position',9877);
3334: FND_MESSAGE.SET_NAME('PSB', 'PSB_POS_INSERT_FAILURE' );
3335:
3336: RAISE FND_API.G_EXC_ERROR;
3337: END IF;

Line 3352: hr_utility.set_location(' end add psb positions'||l_position_id,1333);

3348: p_msg_data => l_msg_data,
3349: p_position_id => l_position_id
3350: ) ;
3351:
3352: hr_utility.set_location(' end add psb positions'||l_position_id,1333);
3353:
3354: -- Populate Salary Assignments
3355: hr_utility.set_location(' Before Salary Assignment'||l_position_id,333);
3356:

Line 3355: hr_utility.set_location(' Before Salary Assignment'||l_position_id,333);

3351:
3352: hr_utility.set_location(' end add psb positions'||l_position_id,1333);
3353:
3354: -- Populate Salary Assignments
3355: hr_utility.set_location(' Before Salary Assignment'||l_position_id,333);
3356:
3357: Populate_Salary_Assignments
3358: ( p_return_status => l_return_status,
3359: p_position_id => l_position_id,

Line 3398: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);

3394: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_ATTRIBUTE_FAIL' );
3395: RAISE FND_API.G_EXC_ERROR;
3396: END IF;
3397:
3398: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);
3399: hr_utility.set_location(' bg id is ' || get_global('G_PSB_BUDGET_GROUP_ID') ,888);
3400: hr_utility.set_location(' ws id is ' || get_global('G_PSB_WORKSHEET_ID') ,888);
3401:
3402: Update_Worksheet_Values ( p_return_status => l_return_status,

Line 3399: hr_utility.set_location(' bg id is ' || get_global('G_PSB_BUDGET_GROUP_ID') ,888);

3395: RAISE FND_API.G_EXC_ERROR;
3396: END IF;
3397:
3398: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);
3399: hr_utility.set_location(' bg id is ' || get_global('G_PSB_BUDGET_GROUP_ID') ,888);
3400: hr_utility.set_location(' ws id is ' || get_global('G_PSB_WORKSHEET_ID') ,888);
3401:
3402: Update_Worksheet_Values ( p_return_status => l_return_status,
3403: p_position_id => l_position_id,

Line 3400: hr_utility.set_location(' ws id is ' || get_global('G_PSB_WORKSHEET_ID') ,888);

3396: END IF;
3397:
3398: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);
3399: hr_utility.set_location(' bg id is ' || get_global('G_PSB_BUDGET_GROUP_ID') ,888);
3400: hr_utility.set_location(' ws id is ' || get_global('G_PSB_WORKSHEET_ID') ,888);
3401:
3402: Update_Worksheet_Values ( p_return_status => l_return_status,
3403: p_position_id => l_position_id,
3404: p_org_id => p_organization_id);

Line 3407: hr_utility.set_location(' fail to update ws value ',888);

3403: p_position_id => l_position_id,
3404: p_org_id => p_organization_id);
3405:
3406: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3407: hr_utility.set_location(' fail to update ws value ',888);
3408: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_WS_FAILURE' );
3409: RAISE FND_API.G_EXC_ERROR;
3410:
3411: RAISE FND_API.G_EXC_ERROR;

Line 3413: hr_utility.set_location(' Insert Position Info Success',555);

3409: RAISE FND_API.G_EXC_ERROR;
3410:
3411: RAISE FND_API.G_EXC_ERROR;
3412: END IF;
3413: hr_utility.set_location(' Insert Position Info Success',555);
3414:
3415: end if;
3416:
3417: --hr_utility.trace_off;

Line 3417: --hr_utility.trace_off;

3413: hr_utility.set_location(' Insert Position Info Success',555);
3414:
3415: end if;
3416:
3417: --hr_utility.trace_off;
3418: /* For Bug No : 2739450 Start*/
3419: END IF;
3420: /* For Bug No : 2739450 End*/
3421:

Line 3538: --hr_utility.trace_on;

3534:
3535: /* For Bug No : 2739450 Start*/
3536: IF (p_position_transaction_id IS NULL) THEN
3537: /*For Bug No. 2739450 End*/
3538: --hr_utility.trace_on;
3539: hr_utility.set_location(' position_id '||p_position_id,881);
3540: hr_utility.set_location(' effective_start_date '||p_effective_start_date,881);
3541: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
3542: hr_utility.set_location(' availability stat '||p_availability_status_id,881);

Line 3539: hr_utility.set_location(' position_id '||p_position_id,881);

3535: /* For Bug No : 2739450 Start*/
3536: IF (p_position_transaction_id IS NULL) THEN
3537: /*For Bug No. 2739450 End*/
3538: --hr_utility.trace_on;
3539: hr_utility.set_location(' position_id '||p_position_id,881);
3540: hr_utility.set_location(' effective_start_date '||p_effective_start_date,881);
3541: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
3542: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
3543: hr_utility.set_location(' business group stat '||p_business_group_id_o,881);

Line 3540: hr_utility.set_location(' effective_start_date '||p_effective_start_date,881);

3536: IF (p_position_transaction_id IS NULL) THEN
3537: /*For Bug No. 2739450 End*/
3538: --hr_utility.trace_on;
3539: hr_utility.set_location(' position_id '||p_position_id,881);
3540: hr_utility.set_location(' effective_start_date '||p_effective_start_date,881);
3541: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
3542: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
3543: hr_utility.set_location(' business group stat '||p_business_group_id_o,881);
3544: hr_utility.set_location(' entry step id '||p_entry_step_id,881);

Line 3541: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);

3537: /*For Bug No. 2739450 End*/
3538: --hr_utility.trace_on;
3539: hr_utility.set_location(' position_id '||p_position_id,881);
3540: hr_utility.set_location(' effective_start_date '||p_effective_start_date,881);
3541: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
3542: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
3543: hr_utility.set_location(' business group stat '||p_business_group_id_o,881);
3544: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
3545: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);

Line 3542: hr_utility.set_location(' availability stat '||p_availability_status_id,881);

3538: --hr_utility.trace_on;
3539: hr_utility.set_location(' position_id '||p_position_id,881);
3540: hr_utility.set_location(' effective_start_date '||p_effective_start_date,881);
3541: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
3542: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
3543: hr_utility.set_location(' business group stat '||p_business_group_id_o,881);
3544: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
3545: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
3546: hr_utility.set_location(' entry job id '||p_job_id_o,881);

Line 3543: hr_utility.set_location(' business group stat '||p_business_group_id_o,881);

3539: hr_utility.set_location(' position_id '||p_position_id,881);
3540: hr_utility.set_location(' effective_start_date '||p_effective_start_date,881);
3541: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
3542: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
3543: hr_utility.set_location(' business group stat '||p_business_group_id_o,881);
3544: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
3545: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
3546: hr_utility.set_location(' entry job id '||p_job_id_o,881);
3547: hr_utility.set_location(' entry location id '||p_location_id,881);

Line 3544: hr_utility.set_location(' entry step id '||p_entry_step_id,881);

3540: hr_utility.set_location(' effective_start_date '||p_effective_start_date,881);
3541: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
3542: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
3543: hr_utility.set_location(' business group stat '||p_business_group_id_o,881);
3544: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
3545: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
3546: hr_utility.set_location(' entry job id '||p_job_id_o,881);
3547: hr_utility.set_location(' entry location id '||p_location_id,881);
3548: hr_utility.set_location(' entry org id '||p_organization_id_o,881);

Line 3545: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);

3541: hr_utility.set_location(' effective_end _date '||p_effective_end_date,881);
3542: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
3543: hr_utility.set_location(' business group stat '||p_business_group_id_o,881);
3544: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
3545: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
3546: hr_utility.set_location(' entry job id '||p_job_id_o,881);
3547: hr_utility.set_location(' entry location id '||p_location_id,881);
3548: hr_utility.set_location(' entry org id '||p_organization_id_o,881);
3549: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);

Line 3546: hr_utility.set_location(' entry job id '||p_job_id_o,881);

3542: hr_utility.set_location(' availability stat '||p_availability_status_id,881);
3543: hr_utility.set_location(' business group stat '||p_business_group_id_o,881);
3544: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
3545: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
3546: hr_utility.set_location(' entry job id '||p_job_id_o,881);
3547: hr_utility.set_location(' entry location id '||p_location_id,881);
3548: hr_utility.set_location(' entry org id '||p_organization_id_o,881);
3549: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
3550: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);

Line 3547: hr_utility.set_location(' entry location id '||p_location_id,881);

3543: hr_utility.set_location(' business group stat '||p_business_group_id_o,881);
3544: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
3545: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
3546: hr_utility.set_location(' entry job id '||p_job_id_o,881);
3547: hr_utility.set_location(' entry location id '||p_location_id,881);
3548: hr_utility.set_location(' entry org id '||p_organization_id_o,881);
3549: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
3550: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
3551: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);

Line 3548: hr_utility.set_location(' entry org id '||p_organization_id_o,881);

3544: hr_utility.set_location(' entry step id '||p_entry_step_id,881);
3545: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
3546: hr_utility.set_location(' entry job id '||p_job_id_o,881);
3547: hr_utility.set_location(' entry location id '||p_location_id,881);
3548: hr_utility.set_location(' entry org id '||p_organization_id_o,881);
3549: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
3550: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
3551: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
3552: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);

Line 3549: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);

3545: hr_utility.set_location(' entry grade rule id '||p_entry_grade_rule_id,881);
3546: hr_utility.set_location(' entry job id '||p_job_id_o,881);
3547: hr_utility.set_location(' entry location id '||p_location_id,881);
3548: hr_utility.set_location(' entry org id '||p_organization_id_o,881);
3549: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
3550: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
3551: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
3552: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
3553: hr_utility.set_location(' date eff '||p_date_effective,881);

Line 3550: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);

3546: hr_utility.set_location(' entry job id '||p_job_id_o,881);
3547: hr_utility.set_location(' entry location id '||p_location_id,881);
3548: hr_utility.set_location(' entry org id '||p_organization_id_o,881);
3549: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
3550: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
3551: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
3552: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
3553: hr_utility.set_location(' date eff '||p_date_effective,881);
3554: hr_utility.set_location(' date end '||p_date_end,881);

Line 3551: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);

3547: hr_utility.set_location(' entry location id '||p_location_id,881);
3548: hr_utility.set_location(' entry org id '||p_organization_id_o,881);
3549: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
3550: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
3551: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
3552: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
3553: hr_utility.set_location(' date eff '||p_date_effective,881);
3554: hr_utility.set_location(' date end '||p_date_end,881);
3555: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);

Line 3552: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);

3548: hr_utility.set_location(' entry org id '||p_organization_id_o,881);
3549: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
3550: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
3551: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
3552: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
3553: hr_utility.set_location(' date eff '||p_date_effective,881);
3554: hr_utility.set_location(' date end '||p_date_end,881);
3555: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
3556: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);

Line 3553: hr_utility.set_location(' date eff '||p_date_effective,881);

3549: hr_utility.set_location(' pos definitio'||p_position_definition_id,881);
3550: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
3551: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
3552: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
3553: hr_utility.set_location(' date eff '||p_date_effective,881);
3554: hr_utility.set_location(' date end '||p_date_end,881);
3555: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
3556: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
3557: hr_utility.set_location(' frequency '||p_frequency,881);

Line 3554: hr_utility.set_location(' date end '||p_date_end,881);

3550: hr_utility.set_location(' pos trans id'||p_position_transaction_id,881);
3551: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
3552: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
3553: hr_utility.set_location(' date eff '||p_date_effective,881);
3554: hr_utility.set_location(' date end '||p_date_end,881);
3555: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
3556: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
3557: hr_utility.set_location(' frequency '||p_frequency,881);
3558: hr_utility.set_location(' working hours '||p_working_hours,881);

Line 3555: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);

3551: hr_utility.set_location(' entry grage id'||p_entry_grade_id,881);
3552: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
3553: hr_utility.set_location(' date eff '||p_date_effective,881);
3554: hr_utility.set_location(' date end '||p_date_end,881);
3555: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
3556: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
3557: hr_utility.set_location(' frequency '||p_frequency,881);
3558: hr_utility.set_location(' working hours '||p_working_hours,881);
3559: hr_utility.set_location(' fte '||p_fte,881);

Line 3556: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);

3552: hr_utility.set_location(' barganingin d'||p_bargaining_unit_cd,881);
3553: hr_utility.set_location(' date eff '||p_date_effective,881);
3554: hr_utility.set_location(' date end '||p_date_end,881);
3555: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
3556: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
3557: hr_utility.set_location(' frequency '||p_frequency,881);
3558: hr_utility.set_location(' working hours '||p_working_hours,881);
3559: hr_utility.set_location(' fte '||p_fte,881);
3560: hr_utility.set_location(' name '||p_name,881);

Line 3557: hr_utility.set_location(' frequency '||p_frequency,881);

3553: hr_utility.set_location(' date eff '||p_date_effective,881);
3554: hr_utility.set_location(' date end '||p_date_end,881);
3555: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
3556: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
3557: hr_utility.set_location(' frequency '||p_frequency,881);
3558: hr_utility.set_location(' working hours '||p_working_hours,881);
3559: hr_utility.set_location(' fte '||p_fte,881);
3560: hr_utility.set_location(' name '||p_name,881);
3561: hr_utility.set_location(' position type '||p_position_type,881);

Line 3558: hr_utility.set_location(' working hours '||p_working_hours,881);

3554: hr_utility.set_location(' date end '||p_date_end,881);
3555: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
3556: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
3557: hr_utility.set_location(' frequency '||p_frequency,881);
3558: hr_utility.set_location(' working hours '||p_working_hours,881);
3559: hr_utility.set_location(' fte '||p_fte,881);
3560: hr_utility.set_location(' name '||p_name,881);
3561: hr_utility.set_location(' position type '||p_position_type,881);
3562: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);

Line 3559: hr_utility.set_location(' fte '||p_fte,881);

3555: hr_utility.set_location(' earliest hire date '||p_earliest_hire_date,881);
3556: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
3557: hr_utility.set_location(' frequency '||p_frequency,881);
3558: hr_utility.set_location(' working hours '||p_working_hours,881);
3559: hr_utility.set_location(' fte '||p_fte,881);
3560: hr_utility.set_location(' name '||p_name,881);
3561: hr_utility.set_location(' position type '||p_position_type,881);
3562: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
3563: hr_utility.set_location(' object version # '||p_object_version_number,881);

Line 3560: hr_utility.set_location(' name '||p_name,881);

3556: hr_utility.set_location(' earliest fill date '||p_fill_by_date,881);
3557: hr_utility.set_location(' frequency '||p_frequency,881);
3558: hr_utility.set_location(' working hours '||p_working_hours,881);
3559: hr_utility.set_location(' fte '||p_fte,881);
3560: hr_utility.set_location(' name '||p_name,881);
3561: hr_utility.set_location(' position type '||p_position_type,881);
3562: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
3563: hr_utility.set_location(' object version # '||p_object_version_number,881);
3564: hr_utility.set_location(' p_effective_date '||p_effective_date, 8887);

Line 3561: hr_utility.set_location(' position type '||p_position_type,881);

3557: hr_utility.set_location(' frequency '||p_frequency,881);
3558: hr_utility.set_location(' working hours '||p_working_hours,881);
3559: hr_utility.set_location(' fte '||p_fte,881);
3560: hr_utility.set_location(' name '||p_name,881);
3561: hr_utility.set_location(' position type '||p_position_type,881);
3562: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
3563: hr_utility.set_location(' object version # '||p_object_version_number,881);
3564: hr_utility.set_location(' p_effective_date '||p_effective_date, 8887);
3565: hr_utility.set_location(' *****************set up ************', 8887);

Line 3562: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);

3558: hr_utility.set_location(' working hours '||p_working_hours,881);
3559: hr_utility.set_location(' fte '||p_fte,881);
3560: hr_utility.set_location(' name '||p_name,881);
3561: hr_utility.set_location(' position type '||p_position_type,881);
3562: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
3563: hr_utility.set_location(' object version # '||p_object_version_number,881);
3564: hr_utility.set_location(' p_effective_date '||p_effective_date, 8887);
3565: hr_utility.set_location(' *****************set up ************', 8887);
3566: hr_utility.set_location(' **** in update position info',777);

Line 3563: hr_utility.set_location(' object version # '||p_object_version_number,881);

3559: hr_utility.set_location(' fte '||p_fte,881);
3560: hr_utility.set_location(' name '||p_name,881);
3561: hr_utility.set_location(' position type '||p_position_type,881);
3562: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
3563: hr_utility.set_location(' object version # '||p_object_version_number,881);
3564: hr_utility.set_location(' p_effective_date '||p_effective_date, 8887);
3565: hr_utility.set_location(' *****************set up ************', 8887);
3566: hr_utility.set_location(' **** in update position info',777);
3567:

Line 3564: hr_utility.set_location(' p_effective_date '||p_effective_date, 8887);

3560: hr_utility.set_location(' name '||p_name,881);
3561: hr_utility.set_location(' position type '||p_position_type,881);
3562: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
3563: hr_utility.set_location(' object version # '||p_object_version_number,881);
3564: hr_utility.set_location(' p_effective_date '||p_effective_date, 8887);
3565: hr_utility.set_location(' *****************set up ************', 8887);
3566: hr_utility.set_location(' **** in update position info',777);
3567:
3568: if (get_global('G_PSB_APPLICATION_ID') = 8401) then

Line 3565: hr_utility.set_location(' *****************set up ************', 8887);

3561: hr_utility.set_location(' position type '||p_position_type,881);
3562: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
3563: hr_utility.set_location(' object version # '||p_object_version_number,881);
3564: hr_utility.set_location(' p_effective_date '||p_effective_date, 8887);
3565: hr_utility.set_location(' *****************set up ************', 8887);
3566: hr_utility.set_location(' **** in update position info',777);
3567:
3568: if (get_global('G_PSB_APPLICATION_ID') = 8401) then
3569:

Line 3566: hr_utility.set_location(' **** in update position info',777);

3562: hr_utility.set_location(' pay basis '||p_pay_basis_id,881);
3563: hr_utility.set_location(' object version # '||p_object_version_number,881);
3564: hr_utility.set_location(' p_effective_date '||p_effective_date, 8887);
3565: hr_utility.set_location(' *****************set up ************', 8887);
3566: hr_utility.set_location(' **** in update position info',777);
3567:
3568: if (get_global('G_PSB_APPLICATION_ID') = 8401) then
3569:
3570: l_data_extract_id := get_global('G_PSB_DATA_EXTRACT_ID');

Line 3571: hr_utility.set_location(' l_data_extract '||l_data_extract_id, 8887);

3567:
3568: if (get_global('G_PSB_APPLICATION_ID') = 8401) then
3569:
3570: l_data_extract_id := get_global('G_PSB_DATA_EXTRACT_ID');
3571: hr_utility.set_location(' l_data_extract '||l_data_extract_id, 8887);
3572:
3573: For C_data_extract_rec in C_data_extract
3574: Loop
3575: l_validity_date := C_data_extract_rec.req_data_as_of_date;

Line 3606: hr_utility.set_location('error in get segments',9850);

3602: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
3603: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );
3604: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
3605: FND_MSG_PUB.Add;
3606: hr_utility.set_location('error in get segments',9850);
3607: RAISE FND_API.G_EXC_ERROR;
3608: end if;
3609:
3610: l_per_index := 1;

Line 3874: hr_utility.set_location('error in get combination id',9867);

3870: l_msg := FND_MESSAGE.get;
3871: FND_MSG_PUB.Add;
3872: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_CCID_FAILURE');
3873: FND_MESSAGE.SET_TOKEN('ERRMESG',l_msg);
3874: hr_utility.set_location('error in get combination id',9867);
3875: RAISE FND_API.G_EXC_ERROR;
3876: end if;
3877:
3878: hr_utility.set_location('pos id flex num in '||

Line 3878: hr_utility.set_location('pos id flex num in '||

3874: hr_utility.set_location('error in get combination id',9867);
3875: RAISE FND_API.G_EXC_ERROR;
3876: end if;
3877:
3878: hr_utility.set_location('pos id flex num in '||
3879: l_position_id_flex_num || ' ccid ' || l_ccid ,9867);
3880:
3881: l_concat_pos_name := null;
3882: l_concat_pos_name := FND_FLEX_EXT.Get_Segs

Line 3887: hr_utility.set_location('concat pos name is '|| l_concat_pos_name,9877);

3883: (application_short_name => 'PSB',
3884: key_flex_code => 'BPS',
3885: structure_number => l_position_id_flex_num,
3886: combination_id => l_ccid);
3887: hr_utility.set_location('concat pos name is '|| l_concat_pos_name,9877);
3888: hr_utility.set_location(' before insert ' ,881);
3889: hr_utility.set_location(' l_psb_position_id '|| l_psb_position_id , 881);
3890: hr_utility.set_location(' l_data_extract_id '|| l_data_extract_id ,881);
3891: hr_utility.set_location(' p_position_definition_id '|| p_position_definition_id ,881);

Line 3888: hr_utility.set_location(' before insert ' ,881);

3884: key_flex_code => 'BPS',
3885: structure_number => l_position_id_flex_num,
3886: combination_id => l_ccid);
3887: hr_utility.set_location('concat pos name is '|| l_concat_pos_name,9877);
3888: hr_utility.set_location(' before insert ' ,881);
3889: hr_utility.set_location(' l_psb_position_id '|| l_psb_position_id , 881);
3890: hr_utility.set_location(' l_data_extract_id '|| l_data_extract_id ,881);
3891: hr_utility.set_location(' p_position_definition_id '|| p_position_definition_id ,881);
3892: hr_utility.set_location(' p_position_id '|| p_position_id ,881);

Line 3889: hr_utility.set_location(' l_psb_position_id '|| l_psb_position_id , 881);

3885: structure_number => l_position_id_flex_num,
3886: combination_id => l_ccid);
3887: hr_utility.set_location('concat pos name is '|| l_concat_pos_name,9877);
3888: hr_utility.set_location(' before insert ' ,881);
3889: hr_utility.set_location(' l_psb_position_id '|| l_psb_position_id , 881);
3890: hr_utility.set_location(' l_data_extract_id '|| l_data_extract_id ,881);
3891: hr_utility.set_location(' p_position_definition_id '|| p_position_definition_id ,881);
3892: hr_utility.set_location(' p_position_id '|| p_position_id ,881);
3893: hr_utility.set_location(' c_pos_trx_rec.hr_employee_id '||

Line 3890: hr_utility.set_location(' l_data_extract_id '|| l_data_extract_id ,881);

3886: combination_id => l_ccid);
3887: hr_utility.set_location('concat pos name is '|| l_concat_pos_name,9877);
3888: hr_utility.set_location(' before insert ' ,881);
3889: hr_utility.set_location(' l_psb_position_id '|| l_psb_position_id , 881);
3890: hr_utility.set_location(' l_data_extract_id '|| l_data_extract_id ,881);
3891: hr_utility.set_location(' p_position_definition_id '|| p_position_definition_id ,881);
3892: hr_utility.set_location(' p_position_id '|| p_position_id ,881);
3893: hr_utility.set_location(' c_pos_trx_rec.hr_employee_id '||
3894: c_pos_trx_rec.hr_employee_id ,881);

Line 3891: hr_utility.set_location(' p_position_definition_id '|| p_position_definition_id ,881);

3887: hr_utility.set_location('concat pos name is '|| l_concat_pos_name,9877);
3888: hr_utility.set_location(' before insert ' ,881);
3889: hr_utility.set_location(' l_psb_position_id '|| l_psb_position_id , 881);
3890: hr_utility.set_location(' l_data_extract_id '|| l_data_extract_id ,881);
3891: hr_utility.set_location(' p_position_definition_id '|| p_position_definition_id ,881);
3892: hr_utility.set_location(' p_position_id '|| p_position_id ,881);
3893: hr_utility.set_location(' c_pos_trx_rec.hr_employee_id '||
3894: c_pos_trx_rec.hr_employee_id ,881);
3895: hr_utility.set_location(' p_business_group_id_o '|| p_business_group_id_o ,881);

Line 3892: hr_utility.set_location(' p_position_id '|| p_position_id ,881);

3888: hr_utility.set_location(' before insert ' ,881);
3889: hr_utility.set_location(' l_psb_position_id '|| l_psb_position_id , 881);
3890: hr_utility.set_location(' l_data_extract_id '|| l_data_extract_id ,881);
3891: hr_utility.set_location(' p_position_definition_id '|| p_position_definition_id ,881);
3892: hr_utility.set_location(' p_position_id '|| p_position_id ,881);
3893: hr_utility.set_location(' c_pos_trx_rec.hr_employee_id '||
3894: c_pos_trx_rec.hr_employee_id ,881);
3895: hr_utility.set_location(' p_business_group_id_o '|| p_business_group_id_o ,881);
3896: hr_utility.set_location(' p_effective_dat '|| p_effective_date ,881);

Line 3893: hr_utility.set_location(' c_pos_trx_rec.hr_employee_id '||

3889: hr_utility.set_location(' l_psb_position_id '|| l_psb_position_id , 881);
3890: hr_utility.set_location(' l_data_extract_id '|| l_data_extract_id ,881);
3891: hr_utility.set_location(' p_position_definition_id '|| p_position_definition_id ,881);
3892: hr_utility.set_location(' p_position_id '|| p_position_id ,881);
3893: hr_utility.set_location(' c_pos_trx_rec.hr_employee_id '||
3894: c_pos_trx_rec.hr_employee_id ,881);
3895: hr_utility.set_location(' p_business_group_id_o '|| p_business_group_id_o ,881);
3896: hr_utility.set_location(' p_effective_dat '|| p_effective_date ,881);
3897: hr_utility.set_location(' p_date_end '|| p_date_end ,881);

Line 3895: hr_utility.set_location(' p_business_group_id_o '|| p_business_group_id_o ,881);

3891: hr_utility.set_location(' p_position_definition_id '|| p_position_definition_id ,881);
3892: hr_utility.set_location(' p_position_id '|| p_position_id ,881);
3893: hr_utility.set_location(' c_pos_trx_rec.hr_employee_id '||
3894: c_pos_trx_rec.hr_employee_id ,881);
3895: hr_utility.set_location(' p_business_group_id_o '|| p_business_group_id_o ,881);
3896: hr_utility.set_location(' p_effective_dat '|| p_effective_date ,881);
3897: hr_utility.set_location(' p_date_end '|| p_date_end ,881);
3898: hr_utility.set_location(' c_pos_trx_rec.set_of_books_id '||
3899: c_pos_trx_rec.set_of_books_id ,881);

Line 3896: hr_utility.set_location(' p_effective_dat '|| p_effective_date ,881);

3892: hr_utility.set_location(' p_position_id '|| p_position_id ,881);
3893: hr_utility.set_location(' c_pos_trx_rec.hr_employee_id '||
3894: c_pos_trx_rec.hr_employee_id ,881);
3895: hr_utility.set_location(' p_business_group_id_o '|| p_business_group_id_o ,881);
3896: hr_utility.set_location(' p_effective_dat '|| p_effective_date ,881);
3897: hr_utility.set_location(' p_date_end '|| p_date_end ,881);
3898: hr_utility.set_location(' c_pos_trx_rec.set_of_books_id '||
3899: c_pos_trx_rec.set_of_books_id ,881);
3900: hr_utility.set_location(' c_pos_trx_rec.vacant_position_flag '||

Line 3897: hr_utility.set_location(' p_date_end '|| p_date_end ,881);

3893: hr_utility.set_location(' c_pos_trx_rec.hr_employee_id '||
3894: c_pos_trx_rec.hr_employee_id ,881);
3895: hr_utility.set_location(' p_business_group_id_o '|| p_business_group_id_o ,881);
3896: hr_utility.set_location(' p_effective_dat '|| p_effective_date ,881);
3897: hr_utility.set_location(' p_date_end '|| p_date_end ,881);
3898: hr_utility.set_location(' c_pos_trx_rec.set_of_books_id '||
3899: c_pos_trx_rec.set_of_books_id ,881);
3900: hr_utility.set_location(' c_pos_trx_rec.vacant_position_flag '||
3901: c_pos_trx_rec.vacant_position_flag ,881);

Line 3898: hr_utility.set_location(' c_pos_trx_rec.set_of_books_id '||

3894: c_pos_trx_rec.hr_employee_id ,881);
3895: hr_utility.set_location(' p_business_group_id_o '|| p_business_group_id_o ,881);
3896: hr_utility.set_location(' p_effective_dat '|| p_effective_date ,881);
3897: hr_utility.set_location(' p_date_end '|| p_date_end ,881);
3898: hr_utility.set_location(' c_pos_trx_rec.set_of_books_id '||
3899: c_pos_trx_rec.set_of_books_id ,881);
3900: hr_utility.set_location(' c_pos_trx_rec.vacant_position_flag '||
3901: c_pos_trx_rec.vacant_position_flag ,881);
3902: hr_utility.set_location(' l_availability_status '|| l_availability_status ,881);

Line 3900: hr_utility.set_location(' c_pos_trx_rec.vacant_position_flag '||

3896: hr_utility.set_location(' p_effective_dat '|| p_effective_date ,881);
3897: hr_utility.set_location(' p_date_end '|| p_date_end ,881);
3898: hr_utility.set_location(' c_pos_trx_rec.set_of_books_id '||
3899: c_pos_trx_rec.set_of_books_id ,881);
3900: hr_utility.set_location(' c_pos_trx_rec.vacant_position_flag '||
3901: c_pos_trx_rec.vacant_position_flag ,881);
3902: hr_utility.set_location(' l_availability_status '|| l_availability_status ,881);
3903: hr_utility.set_location(' c_pos_trx_rec.transaction_id '||
3904: c_pos_trx_rec.transaction_id ,881);

Line 3902: hr_utility.set_location(' l_availability_status '|| l_availability_status ,881);

3898: hr_utility.set_location(' c_pos_trx_rec.set_of_books_id '||
3899: c_pos_trx_rec.set_of_books_id ,881);
3900: hr_utility.set_location(' c_pos_trx_rec.vacant_position_flag '||
3901: c_pos_trx_rec.vacant_position_flag ,881);
3902: hr_utility.set_location(' l_availability_status '|| l_availability_status ,881);
3903: hr_utility.set_location(' c_pos_trx_rec.transaction_id '||
3904: c_pos_trx_rec.transaction_id ,881);
3905: hr_utility.set_location(' c_pos_trx_rec.transaction_status '||
3906: c_pos_trx_rec.transaction_status ,881);

Line 3903: hr_utility.set_location(' c_pos_trx_rec.transaction_id '||

3899: c_pos_trx_rec.set_of_books_id ,881);
3900: hr_utility.set_location(' c_pos_trx_rec.vacant_position_flag '||
3901: c_pos_trx_rec.vacant_position_flag ,881);
3902: hr_utility.set_location(' l_availability_status '|| l_availability_status ,881);
3903: hr_utility.set_location(' c_pos_trx_rec.transaction_id '||
3904: c_pos_trx_rec.transaction_id ,881);
3905: hr_utility.set_location(' c_pos_trx_rec.transaction_status '||
3906: c_pos_trx_rec.transaction_status ,881);
3907: hr_utility.set_location(' p_name '||p_name,881);

Line 3905: hr_utility.set_location(' c_pos_trx_rec.transaction_status '||

3901: c_pos_trx_rec.vacant_position_flag ,881);
3902: hr_utility.set_location(' l_availability_status '|| l_availability_status ,881);
3903: hr_utility.set_location(' c_pos_trx_rec.transaction_id '||
3904: c_pos_trx_rec.transaction_id ,881);
3905: hr_utility.set_location(' c_pos_trx_rec.transaction_status '||
3906: c_pos_trx_rec.transaction_status ,881);
3907: hr_utility.set_location(' p_name '||p_name,881);
3908:
3909: hr_utility.set_location(' before update position', 1887);

Line 3907: hr_utility.set_location(' p_name '||p_name,881);

3903: hr_utility.set_location(' c_pos_trx_rec.transaction_id '||
3904: c_pos_trx_rec.transaction_id ,881);
3905: hr_utility.set_location(' c_pos_trx_rec.transaction_status '||
3906: c_pos_trx_rec.transaction_status ,881);
3907: hr_utility.set_location(' p_name '||p_name,881);
3908:
3909: hr_utility.set_location(' before update position', 1887);
3910: -- ++++++
3911:

Line 3909: hr_utility.set_location(' before update position', 1887);

3905: hr_utility.set_location(' c_pos_trx_rec.transaction_status '||
3906: c_pos_trx_rec.transaction_status ,881);
3907: hr_utility.set_location(' p_name '||p_name,881);
3908:
3909: hr_utility.set_location(' before update position', 1887);
3910: -- ++++++
3911:
3912: PSB_POSITIONS_PVT.UPDATE_ROW
3913: (

Line 3962: hr_utility.set_location(' after update position', 1887);

3958: p_name => l_concat_pos_name,
3959: p_mode => 'R'
3960: );
3961:
3962: hr_utility.set_location(' after update position', 1887);
3963:
3964: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3965: hr_utility.set_location(' posb fail after update position', 1887);
3966: FND_MESSAGE.SET_NAME('PSB', 'PSB_POS_UPDATE_FAILURE' );

Line 3965: hr_utility.set_location(' posb fail after update position', 1887);

3961:
3962: hr_utility.set_location(' after update position', 1887);
3963:
3964: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3965: hr_utility.set_location(' posb fail after update position', 1887);
3966: FND_MESSAGE.SET_NAME('PSB', 'PSB_POS_UPDATE_FAILURE' );
3967:
3968: RAISE FND_API.G_EXC_ERROR;
3969: END IF;

Line 4022: hr_utility.set_location(' fail to update ws value ',888);

4018: p_position_id => l_psb_position_id,
4019: p_org_id => p_organization_id_o);
4020:
4021: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4022: hr_utility.set_location(' fail to update ws value ',888);
4023: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_WS_FAILURE' );
4024: RAISE FND_API.G_EXC_ERROR;
4025:
4026: RAISE FND_API.G_EXC_ERROR;

Line 4031: --hr_utility.trace_off;

4027: END IF;
4028:
4029: end if;
4030:
4031: --hr_utility.trace_off;
4032: /* For Bug No : 2739450 Start*/
4033: END IF;
4034: /* For Bug No : 2739450 End*/
4035:

Line 4078: --hr_utility.trace_on;

4074: connect by prior budget_group_id = parent_budget_group_id;
4075:
4076: BEGIN
4077:
4078: --hr_utility.trace_on;
4079: IF get_global('G_PSB_CURRENT_FORM') <> 'PSBWMPMD' and
4080: get_global('G_PSB_CURRENT_FORM') <> 'PSBBGRVS' THEN
4081: hr_utility.set_location(' exiting.. not from ws/bg',333);
4082: RETURN;

Line 4081: hr_utility.set_location(' exiting.. not from ws/bg',333);

4077:
4078: --hr_utility.trace_on;
4079: IF get_global('G_PSB_CURRENT_FORM') <> 'PSBWMPMD' and
4080: get_global('G_PSB_CURRENT_FORM') <> 'PSBBGRVS' THEN
4081: hr_utility.set_location(' exiting.. not from ws/bg',333);
4082: RETURN;
4083: END IF;
4084:
4085: hr_utility.set_location(' Inside update ws values',333);

Line 4085: hr_utility.set_location(' Inside update ws values',333);

4081: hr_utility.set_location(' exiting.. not from ws/bg',333);
4082: RETURN;
4083: END IF;
4084:
4085: hr_utility.set_location(' Inside update ws values',333);
4086: hr_utility.set_location(' WS id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),333);
4087: hr_utility.set_location(' BG id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_BUDGET_GROUP_ID'),333);
4088: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);
4089: hr_utility.set_location(' positionid ' || p_position_id ,888);

Line 4086: hr_utility.set_location(' WS id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),333);

4082: RETURN;
4083: END IF;
4084:
4085: hr_utility.set_location(' Inside update ws values',333);
4086: hr_utility.set_location(' WS id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),333);
4087: hr_utility.set_location(' BG id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_BUDGET_GROUP_ID'),333);
4088: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);
4089: hr_utility.set_location(' positionid ' || p_position_id ,888);
4090:

Line 4087: hr_utility.set_location(' BG id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_BUDGET_GROUP_ID'),333);

4083: END IF;
4084:
4085: hr_utility.set_location(' Inside update ws values',333);
4086: hr_utility.set_location(' WS id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),333);
4087: hr_utility.set_location(' BG id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_BUDGET_GROUP_ID'),333);
4088: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);
4089: hr_utility.set_location(' positionid ' || p_position_id ,888);
4090:
4091: -- get first budget group associated to input organization starting within the input bg's hierarchy

Line 4088: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);

4084:
4085: hr_utility.set_location(' Inside update ws values',333);
4086: hr_utility.set_location(' WS id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),333);
4087: hr_utility.set_location(' BG id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_BUDGET_GROUP_ID'),333);
4088: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);
4089: hr_utility.set_location(' positionid ' || p_position_id ,888);
4090:
4091: -- get first budget group associated to input organization starting within the input bg's hierarchy
4092: -- use position's org id

Line 4089: hr_utility.set_location(' positionid ' || p_position_id ,888);

4085: hr_utility.set_location(' Inside update ws values',333);
4086: hr_utility.set_location(' WS id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_WORKSHEET_ID'),333);
4087: hr_utility.set_location(' BG id' || PSB_HR_POPULATE_DATA_PVT.get_global('G_PSB_BUDGET_GROUP_ID'),333);
4088: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);
4089: hr_utility.set_location(' positionid ' || p_position_id ,888);
4090:
4091: -- get first budget group associated to input organization starting within the input bg's hierarchy
4092: -- use position's org id
4093: --l_in_org_id := get_global('G_PSB_ORG_ID');

Line 4107: hr_utility.set_location(' out org id ' || l_org_budget_group_id ,888);

4103: end if;
4104: close bgorg;
4105:
4106:
4107: hr_utility.set_location(' out org id ' || l_org_budget_group_id ,888);
4108: IF get_global('G_PSB_CURRENT_FORM') = 'PSBWMPMD' THEN
4109: PSB_WS_POSITION_CR_LINES_I_PVT.Insert_Row
4110: (
4111: p_api_version => 1.0,

Line 4123: hr_utility.set_location(' l_position_line_id is ' || l_position_line_id,333);

4119: p_position_id => p_position_id,
4120: p_budget_group_id => l_org_budget_group_id,
4121: p_position_line_id => l_position_line_id);
4122:
4123: hr_utility.set_location(' l_position_line_id is ' || l_position_line_id,333);
4124:
4125: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
4126: hr_utility.set_location(' fail to insert row ',888);
4127: --hr_utility.trace_off;

Line 4126: hr_utility.set_location(' fail to insert row ',888);

4122:
4123: hr_utility.set_location(' l_position_line_id is ' || l_position_line_id,333);
4124:
4125: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
4126: hr_utility.set_location(' fail to insert row ',888);
4127: --hr_utility.trace_off;
4128: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCR_INSERT_POS_WS_FAIL');
4129: raise FND_API.G_EXC_ERROR;
4130: END IF;

Line 4127: --hr_utility.trace_off;

4123: hr_utility.set_location(' l_position_line_id is ' || l_position_line_id,333);
4124:
4125: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
4126: hr_utility.set_location(' fail to insert row ',888);
4127: --hr_utility.trace_off;
4128: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCR_INSERT_POS_WS_FAIL');
4129: raise FND_API.G_EXC_ERROR;
4130: END IF;
4131: --++ end ws

Line 4189: --hr_utility.trace_off;

4185:
4186: END IF;
4187:
4188: p_return_status := FND_API.G_RET_STS_SUCCESS;
4189: --hr_utility.trace_off;
4190:
4191: EXCEPTION
4192:
4193: WHEN FND_API.G_EXC_ERROR THEN

Line 4195: --hr_utility.trace_off;

4191: EXCEPTION
4192:
4193: WHEN FND_API.G_EXC_ERROR THEN
4194: p_return_status := FND_API.G_RET_STS_ERROR;
4195: --hr_utility.trace_off;
4196:
4197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4198: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4199: --hr_utility.trace_off;

Line 4199: --hr_utility.trace_off;

4195: --hr_utility.trace_off;
4196:
4197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4198: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4199: --hr_utility.trace_off;
4200:
4201: WHEN OTHERS THEN
4202: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4203: --hr_utility.trace_off;

Line 4203: --hr_utility.trace_off;

4199: --hr_utility.trace_off;
4200:
4201: WHEN OTHERS THEN
4202: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4203: --hr_utility.trace_off;
4204:
4205: END Update_Worksheet_Values;
4206:
4207: /* ----------------------------------------------------------------------- */